DEV Community

Punitha
Punitha

Posted on

IPL Match Analysis Dashboard

Step 1: Import the Dataset

  • Open Power BI Desktop

  • Click Get Data

  • Select the IPL dataset(CSV/Excel)

  • Click Load

Step 2: Data Cleaning using Power Query Editor

  • Click Transform Data

  • Verify data types

  • Remove duplicate records

  • Handle missing values

  • Rename column names

  • Remove unnecessary columns

  • Click Close & Apply

Step 3: Create DAX Measures

  • Total Matches 
Total Matches = COUNT(Cricket_data[id])
Enter fullscreen mode Exit fullscreen mode
  • Total Runs 
Total Runs = SUM(Cricket_data[home_runs]) + SUM(Cricket_data[away_runs])
Enter fullscreen mode Exit fullscreen mode
  • Total Wickets 
Total Wickets = SUM(Cricket_data[home_wickets]) + SUM(Cricket_data[away_wickets])
Enter fullscreen mode Exit fullscreen mode
  • Total Boundaries 
Total Boundaries = SUM(Cricket_data[home_boundaries]) + SUM(Cricket_data[away_boundaries])
Enter fullscreen mode Exit fullscreen mode
  • Total Venues 
Total Venues = DISTINCTCOUNT(Cricket_data[venue_name])
Enter fullscreen mode Exit fullscreen mode

Step 4: Create Slicers

Season Slicer

  • Field: Season

Venue Slicer

  • Field: VenueName

Home Team Slicer

  • Field: HomeTeam

Step 5: Create KPI Cards

  • Card 1 - Total Matches

  • Card 2 - Total Runs

  • Card 3 - Total Wickets

  • Card 4 - Total Boundaries

  • Card 5 - Total Venues

Step 6: Create Matches by Season Chart

  • Select Column Chart

  • Drag Season -> Axis

  • Drag Match Count -> Values

Step 7: Create Winner Distribution Chart

  • Select Donut Chart

  • Drag Winner -> Legend

  • Drag Values -> Match Count

Step 8: Create Wickets by Team Chart

  • Select Column Chart

  • Drag Bowling Team -> Axis

  • Drag Total Wickets -> Values

Step 9: Create Team Wise Wins Chart

  • Select Bar Chart

  • Drag Winner -> Axis

  • Drag Values -> Values

Step 10: Create Decision Distribution

  • Select Donut Chart

  • Drag Decision -> Legend

  • Count of Matches -> Values

Step 11: Create Runs by Team Chart

  • Select Column Chart

  • Drag Batting Team -> Axis

  • Drag Total Runs -> Values

Step 12: Create Venue Wise Matches Chart

  • Select Bar Chart

  • Drag Venue Name -> Axis

  • Drag Match Count -> Count

Step 13: Create Super Over Analysis

  • Select Donut Chart

  • Drag Super Over -> Axis

  • Drag Match Count -> Values

Step 14: Create Toss Decision vs match Won Chart

  • Select Column Chart

  • Drag Decision -> Axis

  • Drag Matches Won -> Values

Step 15: Dashboard Formatting

  • IPL stadium background image

  • Consistent color theme

  • Card icons for KPIs

  • Borders around visuals

  • Data labels enabled

  • Titles added for all visuals

Top comments (0)