Developed an interactive IPL dashboard in Power BI, highlighting team stats, player performance, and match outcomes. The project involved data cleaning, transformation in Power Query, and dynamic visualization using slicers, filters, and custom charts.
Welcome to my Power BI project analyzing the Indian Premier League (IPL) from 2008 to 2024! This dashboard delivers rich, interactive visuals to explore match outcomes, player performance, team dominance, and venue trends using real-world IPL data.
The goal of this Power BI-built dynamic and aesthetically interactive dashboard project is to extract insights from the IPL's more than 15 years of match data. The dashboard assists stakeholders, analysts, and cricket fans in examining important performance metrics such as:
- 🏅 Top performing players
- 🏟️ Match-winning patterns
- 🌍 City-wise outcomes
- 🏆 Team performance trends
-
🧹 Data Cleaning & Modeling
Utilized Power Query in Power BI to clean and prepare data frommatches.csv
,deliveries.csv
, andFinal IPL.xlsx
. -
📊 Interactive Visuals
Created dynamic visuals for Player of the Match, Orange & Purple Cap Holders, Team Wins, Toss Decisions, and more. -
📌 Dynamic Filtering
Added slicers for filtering by Year, City, and Teams to allow user-driven exploration. -
🧠 Insightful Analysis
Built visual storytelling to highlight strategic patterns, seasonal highs, and team-wise trends.
This section showcases the standout highlights derived from the dashboard.
-
🎖️ Most “Player of the Match” Awards:
ab de villiers leads with 25 awards. -
🟠 Orange Cap Holder:
Virat Kohli – Highest Run Scorer in IPL history. -
🟣 Purple Cap Holder:
Yuzvendra Chahal – Highest Wicket Taker till 2024.
-
🏆 Most Matches Won:
Mumbai Indians (MI) – 134 victories. -
🥈 Second Most Wins:
Chennai Super Kings (CSK) – 124 victories.
- 🎯 Teams that win the toss and choose to field first tend to have higher success rates, especially in key venues.
- 🧠 Reflects a common T20 strategy of chasing due to dew and pitch behavior.
-
🏟️ Most Matches Hosted:
Mumbai, followed by Bangalore and Delhi. -
📈 City Advantage:
Certain teams perform consistently better at home venues.
- 🔥 2016 saw the highest batting aggregates, with multiple high scores and centuries.
- 📊 Players like Kohli, Dhoni, and Rohit Sharma showed consistent performance over multiple seasons.
- 📅 Time-Based Filters: Select Year, City, or Team for dynamic analysis.
- 📊 Key Visuals:
- Orange & Purple Cap Holders
- Toss Decisions vs Match Outcomes
- Team Win Comparisons
- Player of the Match Stats
- Season-by-Season Performance Trends
File Name | Description |
---|---|
IPL Dashboard.pbix |
Power BI Dashboard File |
matches.csv |
Historical Match Data (2008–2024) |
deliveries.csv |
Ball-by-ball Delivery Data |
Final IPL.xlsx |
Custom Summary Data File |
IPL Dashboard.png |
Image Preview of the Dashboard |
- Kaggle IPL Dataset – matches.csv & deliveries.csv
- Custom curated Excel file (
Final IPL.xlsx
) for calculated statistics.
- 🟡 Power BI – Power Query, Data Modeling, DAX
- 🔵 Excel – Pre-processing, Summary Stats
- 🧠 Analytical Thinking – Trend & Pattern Recognition
If you liked this project, feel free to star ⭐ the repository and share your feedback or suggestions. I'm always open to learning and collaboration!