Baselight

USA Bank Financial Data

Data set for Tableau practice

@kaggle.vishalsinghsangral_usa_bank_financial_data

Loading...
Loading...

About this Dataset

USA Bank Financial Data

Dataset Description:

The myusabank.csv dataset contains daily financial data for a fictional bank (MyUSA Bank) over a two-year period. It includes various key financial metrics such as interest income, interest expense, average earning assets, net income, total assets, shareholder equity, operating expenses, operating income, market share, and stock price. The data is structured to simulate realistic scenarios in the banking sector, including outliers, duplicates, and missing values for educational purposes.

Potential Student Tasks:

  1. Data Cleaning and Preprocessing:

    • Handle missing values, duplicates, and outliers to ensure data integrity.
    • Normalize or scale data as needed for analysis.
  2. Exploratory Data Analysis (EDA):

    • Visualize trends and distributions of financial metrics over time.
    • Identify correlations between different financial indicators.
  3. Calculating Key Performance Indicators (KPIs):

    • Compute metrics such as Net Interest Margin (NIM), Return on Assets (ROA), Return on Equity (ROE), and Cost-to-Income Ratio using calculated fields.
    • Analyze the financial health and performance of MyUSA Bank based on these KPIs.
  4. Building Tableau Dashboards:

    • Design interactive dashboards to present insights and trends.
    • Include summary cards, bar charts, line charts, and pie charts to visualize financial performance metrics.
  5. Forecasting and Predictive Modeling:

    • Use historical data to forecast future financial performance.
    • Apply regression or time series analysis to predict market share or stock price movements.
  6. Business Insights and Reporting:

    • Interpret findings to derive actionable insights for bank management.
    • Prepare reports or presentations summarizing key findings and recommendations.

Educational Goals:

The dataset aims to provide hands-on experience in data preprocessing, analysis, and visualization within the context of banking and finance. It encourages students to apply data science techniques to real-world financial data, enhancing their skills in data-driven decision-making and strategic analysis.

Tables

Myusabank

@kaggle.vishalsinghsangral_usa_bank_financial_data.myusabank
  • 38.94 KB
  • 523 rows
  • 11 columns
Loading...

CREATE TABLE myusabank (
  "date" TIMESTAMP,
  "interest_income" DOUBLE,
  "interest_expense" BIGINT,
  "average_earning_assets" BIGINT,
  "net_income" DOUBLE,
  "total_assets" BIGINT,
  "shareholder_equity" BIGINT,
  "operating_expenses" BIGINT,
  "operating_income" BIGINT,
  "market_share" BIGINT,
  "stock_price" BIGINT
);

Share link

Anyone who has the link will be able to view this.