IPL Data Analysis Using Power BI

Phase 2 – Data Cleaning, EDA & Dashboard Explanation

Submitted by: Kapalavayi Ramtrinadh

Course: Data Analytics

Table of Contents
1. Project Overview
2. Objectives of the Project
3. Domain
4. Data Cleaning Steps
5. Data Cleaning & Preparation
6. Exploratory Data Analysis (EDA)
7. Dashboard Design and Explanation
8. Observations & Insights
9. Conclusion
1. Project Overview
This project, titled “IPL Data Analysis Using Power BI”, focuses on analyzing
historical Indian Premier League (IPL) data to extract meaningful insights about
team and player performances, match outcomes, and season-wise trends. The
main goal is to build an interactive dashboard using Power BI that helps visualize
and interpret key cricket statistics, enabling better understanding of the factors
influencing team success, toss decisions, and overall game outcomes.

2. Objectives of the Project

• Identify the most successful teams and players in IPL history.
• Evaluate factors contributing to a team’s or player’s success.
• Analyze the impact of match venues, cities, and toss outcomes.
• Discover seasonal and trend patterns across IPL tournaments.
• Create an interactive Power BI dashboard that displays insights effectively.

3. Domain
Domain: Sports Analytics
Tool Used: Power BI
Dataset Format: CSV (Matches and Deliveries)
Sports analytics focuses on using data to evaluate and improve player
performance, team strategy, and fan engagement. The IPL dataset provides an
excellent foundation for applying these principles.

4. Datasets Used
Matches Dataset – Contains high-level match details (teams, venues, results,
umpires).
Deliveries Dataset – Contains ball-by-ball details (runs, wickets, dismissals,
bowlers, etc.).

🔹 Data Cleaning Steps

1. Imported Datasets
 Uploaded both matches and deliveries datasets into Power BI.
 Verified column data types (e.g., dates, numeric values, team names).
2. Removed Unnecessary Data
 Removed duplicate rows to ensure data accuracy.
 Deleted blank rows in both datasets, especially in columns like umpire3,
which contained no useful information.
3. Standardized Column Names
  Adjusted inconsistent column headers to maintain uniformity for merging
and filtering.
 Ensured proper naming conventions for easier identification (e.g.,
match_id, player_of_match, etc.).
4. Data Merging
 Created a relationship between matches and deliveries using the match_id
column.
 This allowed us to combine match-level and ball-level data for deeper
insights (like total runs, wickets, etc.).
5. Validated Data Integrity
 Checked for missing values and invalid team names.
 Confirmed that the season column aligned correctly with match records.

🔹 Exploratory Data Analysis (EDA)

EDA was carried out in Power BI to extract insights from the cleaned dataset. The
analysis focused on player performance, team success, and match trends.
Key Metrics Calculated:
 Total Dismissals – Counted how many players got out across all
matches.
 Total Wickets – Calculated the total number of wickets taken by bowlers.
 Total Runs – Summed up all runs scored across seasons.
 Total Matches – Counted the total matches available in the dataset.
Derived Insights:
 Top Run Scorers – Identified players like DA Warner and G Gambhir as
consistent top scorers.
 Top Wicket Takers – Highlighted players such as HV Patel and MP Stoinis
for their strong bowling performances.
 Top Fielders – Players like KA Pollard and MS Dhoni emerged as key
fielders based on dismissals and catches.
 Most Match Wins – Showed that teams like Mumbai Indians and Kolkata
Knight Riders had the highest win counts.
🔹 Dashboard Explanation
The Power BI dashboard (as shown in the image) visually represents the IPL data
and allows interactive exploration through filters.
Dashboard Components:
1. Header Section:
o Title: “IPL DATA ANALYSIS USING POWER BI”

o Displays four main KPIs:

 Total Dismissals (14K)

 Total Wickets (14K)
 Total Runs (19K)
 Match Count (59)
2. Visuals and Charts:
o Top Run Scorers (Team-wise): Shows which teams have top
batsmen contributing the most runs.
o Most Match Wins: Bar chart showing teams with the highest
match wins.
o Toss Decision Analysis (Bat vs Field): Compares team
performance based on toss decisions.
o Top Fielders: Highlights players with the most dismissals or
catches.
o Top Wicket Takers: Visualizes leading bowlers by total wickets.
 o Top Individual Run Scorers: Displays top 10 batsmen and their
cumulative runs.
3. Filters Section:
o Team Filter: Lets you select specific teams like Mumbai Indians,
Kolkata Knight Riders, etc.
o Season Filter: Filters data between 2008–2015 to study year-wise
trends.
o Venue Filter: Filters performance based on stadiums like Eden
Gardens or M. Chinnaswamy Stadium.
o City Filter: Helps analyze results city-wise such as Bangalore,
Mumbai, Delhi, etc.

🔹 Observations & Insights

 Mumbai Indians and Kolkata Knight Riders dominated most matches
during the selected seasons.
 Toss Decision Analysis indicates that fielding first gave a better winning
chance in several cases.
 Top Bowlers like HV Patel consistently contributed to team success
through high wicket counts.
 Top Batsmen such as DA Warner and G Gambhir remained among the
most reliable scorers across multiple seasons.
 Top Fielders like MS Dhoni played crucial roles in run-outs and catches,
improving team defense.

10. Conclusion
The IPL Data Analysis project demonstrates how Power BI can transform raw
cricket data into powerful visual insights. Through careful cleaning, EDA, and
dashboard design, it becomes easy to analyze team and player performances,
identify patterns, and draw meaningful conclusions for sports analytics
applications.