- Requirement Gathering
- Stakeholders in project
- Import Data in MS SQL server
- Import Data in PostgreSQL DB
- Connecting Power Bi to database
- Data Cleaning
- Data Processing
- Data Modelling
- Time Intelligence Function
- Data Visualization
- Creating Dashboard
- Generating Insights
Develop a IPL Dashboard for season 2008 to 2022 to have a detailed insight on below problem statement.
-
Find the Title Winner, Orange Cap Winner, Purple Cap Winner, Tournament 6's and 4's for the respective seasons on IPL.
-
Develop IPL Batting and Bowling Stats and add a filter where user can select the bowler and batsman to see the stats.
-
Winning percentage based on the toss decision
-
Match win by venue
-
Total wins by team in a season
-
Matches won based on the result type
- BCCI
- Franchise Owners
- Team Management
- Coaches
- Players
- Media
- Public
- How to connect Power BI to MS SQL server and PostgreSQL
- Data Modelling with three tables
- Data cleaning in Power Query
- Time Intelligence Function
- Creating KPI's
- DAX Queries
- Creating and formatting charts
- Different DAX functions like Calculate, SUM, SUMX, Filter, ALLselected, values, selectedvalue, return, concatenate, divide etc
- Creating different shapes and formatting
- Generating insights from charts
- Export report