Skip to content

README.md

Latest commit

 

History

History
580 lines (392 loc) · 13.9 KB

README.md

File metadata and controls

580 lines (392 loc) · 13.9 KB
Raw

🏏 IPL Performance Analytics Dashboard

Power BI Python Pandas License

An interactive Business Intelligence dashboard built using Power BI, DAX, Power Query, and Python to analyze historical Indian Premier League (IPL) data from 2008–2023. The project transforms raw cricket datasets into meaningful business insights through KPI reporting, interactive visualizations, and trend analysis.

📌 Overview

The IPL Performance Analytics Dashboard demonstrates the complete Business Intelligence lifecycle—from data collection and transformation to dashboard development and insight generation.

Using historical IPL match and ball-by-ball datasets, the dashboard enables users to analyze player performance, venue statistics, season trends, match outcomes, and toss impact through interactive reports.

This project showcases practical skills in:

  • Business Intelligence
  • Dashboard Development
  • Data Cleaning
  • Data Modeling
  • DAX Calculations
  • KPI Reporting
  • Data Visualization

🎯 Business Problem

IPL generates thousands of match records every season, making it difficult to manually identify player performance trends, venue statistics, and winning patterns.

Traditional spreadsheets cannot efficiently answer questions such as:

  • Who are the highest run scorers?
  • Which bowlers consistently perform well?
  • Which venues produce the highest scores?
  • Does winning the toss significantly influence match outcomes?
  • How has the IPL evolved over multiple seasons?

The objective of this project is to convert raw cricket datasets into an interactive Business Intelligence dashboard that enables quick, data-driven decision making.

💡 Solution

The dashboard provides a centralized analytical platform that allows users to:

  • Analyze batting performance across IPL seasons
  • Evaluate bowling statistics
  • Compare venue performance
  • Track season-wise growth
  • Measure toss impact on winning probability
  • Visualize match outcome distributions
  • Explore interactive KPIs using Power BI

📊 Dashboard Preview

The dashboard provides an interactive overview of IPL performance metrics including player statistics, venue analysis, match trends, and toss impact across multiple seasons.

Dashboard

📈 Key Performance Indicators (KPIs)

The dashboard provides interactive KPIs including:

  • 🏏 Total IPL Matches
  • 📅 Season-wise Match Trends
  • 👤 Top Run Scorers
  • 🎯 Top Wicket Takers
  • 🏟 High Scoring Venues
  • 🪙 Toss Win Percentage
  • 📊 Match Result Distribution
  • 📈 Historical Performance Trends

🎯 Dashboard Objectives

The dashboard was designed to help users:

  • Analyze player and team performance across seasons.
  • Compare venue statistics and match trends.
  • Evaluate toss impact on match outcomes.
  • Monitor season-wise IPL growth.
  • Generate interactive insights using Power BI.

💡 Key Business Insights

Analysis of IPL data revealed several meaningful insights:

  • Virat Kohli remains the highest run scorer across IPL history.
  • Winning the toss provides only a marginal advantage (~51%), indicating team performance has greater influence on match outcomes.
  • Bengaluru and Mumbai consistently host high-scoring matches.
  • Teams chasing targets have historically won slightly more matches than teams defending totals.
  • IPL has experienced steady expansion, reflected by the increasing number of matches each season.

🏗 Business Intelligence Workflow

Architecture

The dashboard follows a standard Business Intelligence workflow:

Historical IPL Dataset
        │
        ▼
Power Query
        │
        ▼
Data Cleaning
        │
        ▼
Data Modeling
        │
        ▼
DAX Measures
        │
        ▼
Power BI Dashboard
        │
        ▼
Business Insights

📊 Interactive Dashboard Components

📈 Season Trend Analysis

Season Trend

Visualizes the number of IPL matches conducted each season, highlighting tournament growth over time.

👤 Top Run Scorers

Top Run Scorers

Ranks the highest run-scoring batsmen across all IPL seasons.

🎯 Top Wicket Takers

Top Wicket Takers

Compares leading bowlers based on total wickets taken.

🏟 High Scoring Venues

High Scoring Venues

Highlights venues that consistently produce high-scoring matches.

🪙 Toss Impact Analysis

Toss Impact

Analyzes whether winning the toss significantly influences match outcomes.

📊 Match Result Distribution

Match Result Distribution

Displays the proportion of matches won by runs versus wickets.

💻 Technology Stack

Category Technologies
Dashboard Power BI
Data Transformation Power Query
Calculations DAX
Programming Python
Data Analysis Pandas
Development Jupyter Notebook
Dataset IPL Historical Dataset (2008–2023)

📁 Repository Structure

IPL-Analytics-Dashboard/
│
├── data/
│   ├── matches.csv
│   └── deliveries.csv
│
├── notebooks/
│   └── IPL_Analytics.ipynb
│
├── visuals/
│   ├── dashboard-overview.png
│   ├── season-trend.png
│   ├── top-run-scorers.png
│   ├── top-wicket-takers.png
│   ├── high-scoring-venues.png
│   ├── toss-impact-analysis.png
│   ├── match-result-distribution.png
│   └── architecture.png
│
├── IPL Analytics Dashboard.pbix
├── README.md
├── requirements.txt
└── LICENSE

🚀 Getting Started

Prerequisites

  • Power BI Desktop
  • Python 3.10+
  • Jupyter Notebook

Install required libraries:

🚀 Getting Started

Prerequisites

  • Power BI Desktop
  • Python 3.10+
  • Jupyter Notebook

Install Dependencies

pip install pandas matplotlib jupyter

Clone Repository

git clone https://github.com/rudrasave/IPL-Analytics-Dashboard.git
cd IPL-Analytics-Dashboard

Run Notebook

jupyter notebook notebooks/IPL_Analytics.ipynb

Open Dashboard

Open

IPL Analytics Dashboard.pbix

using Microsoft Power BI Desktop.

📈 Business Impact

This project demonstrates practical Business Intelligence capabilities including:

  • KPI Development
  • Dashboard Design
  • Power Query Transformations
  • Data Modeling
  • DAX Calculations
  • Sports Analytics
  • Executive Reporting
  • Data-Driven Decision Making

🔮 Future Enhancements

  • Live IPL API integration
  • Predictive player performance using Machine Learning
  • Advanced DAX calculations
  • Drill-through dashboard pages
  • Mobile-optimized dashboard
  • Automated data refresh pipeline

📜 License

This project is licensed under the MIT License.

👨‍💻 Author

Rudra Save

📧 Email: rudrasave1709@gmail.com

🔗 LinkedIn: https://www.linkedin.com/in/rudra-save-a90749358/

💻 GitHub: https://github.com/rudrasave