Skip to content

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.

Notifications You must be signed in to change notification settings

niravtrivedi23/IPL-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

IPL-Dashboard

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.

🏏 IPL Analysis Dashboard (2008–2024) – Power BI Project

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.


🚀 Project Overview

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

🔧 What I Did

  • 🧹 Data Cleaning & Modeling
    Utilized Power Query in Power BI to clean and prepare data from matches.csv, deliveries.csv, and Final 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.


📊 IPL Performance Insights (2008–2024)

This section showcases the standout highlights derived from the dashboard.

✅ Top Player Insights:

  • 🎖️ 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.


✅ Team Dominance:

  • 🏆 Most Matches Won:
    Mumbai Indians (MI)134 victories.

  • 🥈 Second Most Wins:
    Chennai Super Kings (CSK)124 victories.


✅ Toss Strategy Insights:

  • 🎯 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.

✅ City-Wise Match Insights:

  • 🏟️ Most Matches Hosted:
    Mumbai, followed by Bangalore and Delhi.

  • 📈 City Advantage:
    Certain teams perform consistently better at home venues.


✅ Seasonal Standouts:

  • 🔥 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.

📌 Dashboard Features

  • 📅 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

📁 Files in This Repository

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

🖼️ Dashboard Preview

IPL Dashboard Preview


📦 Dataset Sources

  • Kaggle IPL Dataset – matches.csv & deliveries.csv
  • Custom curated Excel file (Final IPL.xlsx) for calculated statistics.

🛠️ Tools & Skills Used

  • 🟡 Power BI – Power Query, Data Modeling, DAX
  • 🔵 Excel – Pre-processing, Summary Stats
  • 🧠 Analytical Thinking – Trend & Pattern Recognition

🔗 Check It Out


⭐ Feedback Welcome!

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!


About

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.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published