Scribd
Upload
250 views1 page

Excel Project

The project involved detailed analysis of IPL cricket data using Microsoft Excel, focusing on data cleaning, transformation, and analysis to derive performance insights. Key tasks included data preparation, exploration through Pivot Tables and Charts, and generating insights on team performance and match outcomes. The outcome showcased Excel skills and produced valuable insights for commentators, coaches, and analysts.

Uploaded by

manshuramna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
250 views1 page

Excel Project

The project involved detailed analysis of IPL cricket data using Microsoft Excel, focusing on data cleaning, transformation, and analysis to derive performance insights. Key tasks included data preparation, exploration through Pivot Tables and Charts, and generating insights on team performance and match outcomes. The outcome showcased Excel skills and produced valuable insights for commentators, coaches, and analysts.

Uploaded by

manshuramna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel Data Analysis Project – IPL Match Insights

Performed detailed match-level data analysis on IPL cricket data using


Microsoft Excel. This project involved cleaning, transforming, and analyzing
raw match data to generate meaningful sports performance insights.

Key Tasks Performed:

• Data Collection & Preparation:


o Used [Link] dataset from Kaggle (IPL dataset).
o Cleaned and standardized raw data: handled missing values, removed
duplicates, and fixed inconsistent team names.

• Data Exploration & Visualization:


o Built dynamic Pivot Tables and Charts to explore match results, venues,
and winning teams.
o Calculated most successful teams by win count and win percentage.
o Analyzed toss decisions and their impact on match results.
o Determined teams’ home vs away match performance.

• Insights Generated:
o Found the most match-winning teams in IPL history.
o Identified stadiums and cities with the highest match count.
o Analyzed how often teams won after winning the toss.
o Compared team performance by batting first vs chasing.

• Tools Used: Microsoft Excel (Pivot Tables, Conditional Formatting, Charts,


Filters)

Outcome: Demonstrated Excel data cleaning and analysis skills on a real-world sports
dataset; produced insights that could assist commentators, coaches, and analysts.

GitHub Repository: [[Link]

You might also like