Skip to content

Latest commit

 

History

History
58 lines (44 loc) · 1.54 KB

README.md

File metadata and controls

58 lines (44 loc) · 1.54 KB
Raw

IPL Analysis Dashboard

  1. Requirement Gathering
  2. Stakeholders in project
  3. Import Data in MS SQL server
  4. Import Data in PostgreSQL DB
  5. Connecting Power Bi to database
  6. Data Cleaning
  7. Data Processing
  8. Data Modelling
  9. Time Intelligence Function
  10. Data Visualization
  11. Creating Dashboard
  12. Generating Insights

Problem Statement :

    Develop a IPL Dashboard for season 2008 to 2022 to have a detailed insight on below problem statement.

  1. Find the Title Winner, Orange Cap Winner, Purple Cap Winner, Tournament 6's and 4's for the respective seasons on IPL.

  2. Develop IPL Batting and Bowling Stats and add a filter where user can select the bowler and batsman to see the stats.

  3. Winning percentage based on the toss decision

  4. Match win by venue

  5. Total wins by team in a season

  6. Matches won based on the result type

Stakeholders :

  1. BCCI
  2. Franchise Owners
  3. Team Management
  4. Coaches
  5. Players
  6. Media
  7. Public

Power BI Functionalities you are working in :

  1. How to connect Power BI to MS SQL server and PostgreSQL
  2. Data Modelling with three tables
  3. Data cleaning in Power Query
  4. Time Intelligence Function
  5. Creating KPI's
  6. DAX Queries
  7. Creating and formatting charts
  8. Different DAX functions like Calculate, SUM, SUMX, Filter, ALLselected, values, selectedvalue, return, concatenate, divide etc
  9. Creating different shapes and formatting
  10. Generating insights from charts
  11. Export report

Output

Screenshot