__STYLES__
Tools used in this project
Beyond Boundaries: IPL

Power BI Dashboard

About this project

The IPL (Indian Premier League) is one of the most popular and widely followed cricket leagues in the world. It features top cricket players from around the world playing for various franchise teams in India. The league is known for its high-scoring matches, intense rivalries, and innovative marketing strategies.

The IPL analysis dashboard created using Microsoft Power BI is a comprehensive visualization tool for analyzing Indian Premier League (IPL) cricket data. The IPL dataset on Kaggle contains information on over 900 IPL matches played from 2008 to 2022. It includes details on the date, time, venue, teams, players, and various statistics such as runs scored, wickets taken, and more which is use to create this dashboard. The dashboard also contains information on the individual performances of players and teams, as well as the overall performance of the league over the years.

The dashboard is designed to provide a comprehensive view of the IPL data, with a focus on key metrics such as team performance, player performance, season records by teams and match summary. The dashboard is also designed to be interactive, with users able to filter into the data to gain deeper insights.

One of the key features of the IPL dashboard is the use of complex DAX formulas to calculate metrics such as batting averages, bowling averages, run rate, boundaries, sixes and strike rates. These formulas are used to derive insights from the raw data, and are critical to the accuracy and reliability of the dashboard.

The dashboard also makes use of a variety of visualization types, including cards, tables, gauge charts, and multi-row cards. These visualizations are designed to provide different perspectives on the data, and to enable users to quickly identify trends and patterns.

The cards on the dashboard provide a high-level overview of key metrics such as the total number of matches played, the total number of runs scored, and the total number of wickets taken, top boundaries, sixes, etc. These cards are designed to be easy to read and provide a quick snapshot of the most important data.

The tables on the dashboard provide more detailed information, including team and player statistics. These tables are interactive, and users can filter and sort the data to find the information they need.

The gauge charts on the dashboard provide a visual representation of winning rates. These charts are designed to be easy to read and provide a quick snapshot of the data.

Finally, the multi-row cards on the dashboard provide detailed information on seasonal records such as orange caps, purple caps, highest strike rate, fours, sixes, dots balls, etc. These cards are designed to be easy to read and provide a quick snapshot of the most important data.

Overall, the IPL dashboard created using Power BI is a powerful visualization tool for analyzing IPL data. It provides users with a comprehensive view of the data, with a range of interactive visualizations and complex DAX formulas to help them gain deeper insights into the data.

🔗 Dataset: https://www.kaggle.com/datasets/logeshkumar04/ipl-analysis

Additional project images

Discussion and feedback(3 comments)
comment-1416-avatar
Shubham Khandekar
Shubham Khandekar
5 months ago
Hi Logesh, I loved your dashboard and i was in the process creating a similar dashboard. However i couldn't identify how can i display score and overs the way you have done over here. Would love to get your feedback on your thought process behind the calculations.

comment-1432-avatar
Logeshkumar S
Logeshkumar S
Project owner
5 months ago
Project owner
Hi Shubham. Thank you so much! I'm glad you liked it. I have included DAX below. Kindly refer and let me know if u have any queries. Over = IF(MOD(MAX(Inns_1[Ball]),1)>=0.6,ROUND(MAX(Inns_1[Ball]),0),MAX(Inns_1[Ball])) Score = CONCATENATE(FORMAT([Total runs inns_1], "0") & "/",CALCULATE(FORMAT([Total Wickets Inns_1], "0"),Inns_1[Wicket_type] <> BLANK()))

comment-1730-avatar
Ganesh ch
3 months ago
Hi Logesh please give your phone number
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.