This project involves creating an interactive Tableau dashboard to analyze IPL (Indian Premier League) statistics from 2008 to 2017. The data is sourced from two datasets, matches.csv
and deliveries.csv
, which contain detailed match and ball-by-ball information. The primary objective is to generate insights through visualizations on match, player, and team statistics, which can be used for reports and newsletters.
The goal of this project is to build a comprehensive and interactive dashboard in Tableau that covers three major categories:
-
Match Statistics
- Toss outcome vs Match outcome (for each Ground/Venue)
- Biggest wins (by runs and by wickets)
- Highest totals (across all the seasons)
-
Player Statistics
- Orange Cap contenders (batsmen with the most runs in a season)
- Purple Cap contenders (bowlers with the most wickets in a season)
- Batsmen who have hit the most number of fours and sixes (per season and overall)
-
Team Statistics
- Season-wise team performance (wins vs losses)
- Win percentage (home vs away)
- matches.csv: Contains match-level information for all IPL matches from 2008 to 2017, including teams involved, match results, and other specifics like umpires and venues.
- deliveries.csv: Contains ball-by-ball data for each match, including details on runs scored, wickets, batsmen, bowlers, and other events.
- Data Preparation & Cleaning: Cleaned and combined the datasets to ensure seamless integration for analysis.
- Data Visualizations: Created various visualizations to analyze key match, player, and team statistics.
- Interactivity: Implemented filters and customizations to allow interactive exploration of the data for deeper insights.
- Dashboards: Built three distinct dashboards focusing on Match, Player, and Team statistics.
- Tableau: For data visualization and dashboard creation.
- Data Processing: Excel or Python (if required for any preprocessing steps).
- IPL_Statistics_Dashboard.twbx: The Tableau workbook containing the interactive dashboards.
- matches.csv: Dataset with match-level information.
- deliveries.csv: Dataset with ball-by-ball information.
- Summary_Presentation.pptx: PPT summarizing the analysis with key insights from the dashboards.
Through this analysis, I explored trends and patterns in IPL matches, player performances, and team statistics. Some of the key findings include:
- Impact of toss outcome on match results across various venues.
- Top-performing players in each season and their statistics.
- Comparison of home vs away match win percentages for each team.
- Download the
.twbx
Tableau workbook to open the dashboards in Tableau. - Open the file in Tableau Desktop or Tableau Reader.
- Use filters to explore different categories and view insights for various IPL seasons.