DEV Community

Ashok Kumar
Ashok Kumar

Posted on

IPL Data Analysis Dashboard

๐Ÿ IPL Data Analysis Dashboard using Power BI

Project LINK:(https://github.com/Ashokkumarrk/IPL-Data-Analysis-Dashboard)

๐Ÿ“Š Project Overview

This project focuses on analyzing IPL (Indian Premier League) data using Power BI to uncover key insights about players, teams, and match performance.

The dashboard provides a comprehensive visual analysis of IPL data including:

  • Top run scorers & wicket takers
  • Team performance trends
  • Win percentages by toss decisions
  • Player comparisons
  • Year-wise analysis

โš™ Tools & Technologies Used

  • Power BI for data visualization
  • Excel / CSV dataset for IPL data
  • DAX for calculated columns and measures
  • Power Query for data cleaning and transformation

๐Ÿงฉ Dashboard Features

  • ๐ŸŽฏ Player-wise Performance Analysis
  • ๐Ÿ† Team Stats & Yearly Trends
  • ๐Ÿ“… Match Analysis (Home/Away)
  • ๐Ÿ“ˆ Interactive filters for teams, venues, and seasons

๐Ÿงฎ Key DAX Measures Used


DAX
Total Runs = SUM(Batting[Runs])
Total Wickets = SUM(Bowling[Wickets])
Strike Rate = DIVIDE(SUM(Batting[Runs]), SUM(Batting[Balls Faced])) * 100
Win Percentage = DIVIDE([Total Wins], [Total Matches]) * 100
Enter fullscreen mode Exit fullscreen mode

Top comments (0)