IPL Data Analysis using MySQL

Share your love

In this project, we explore the vast dataset of the Indian Premier League (IPL), a renowned cricket league in India. Leveraging SQL queries, we aim to uncover key insights and statistics related to player performance, team achievements, umpire records, toss decisions, and match results within the IPL.

Through data analysis, we bring to light intriguing patterns and trends, showcasing the power of SQL as a tool for sports data analysis. Whether you’re a cricket enthusiast, team strategist, or data aficionado, join us in unraveling the captivating story of the IPL, as told by the data.

Data Source:

Queries and Analysis:

  1. which player has won the highest man of the match?
select player_of_match,count(*) as topplayer 
from ipl 
group by player_of_match 
order by count(*)
desc limit 1;

2. list out top 10 players with most man of the match?

select player_of_match,count(*) as topplayer 
from ipl 
group by player_of_match 
order by count(*)
desc limit 10;

3. Which team has won the most number of matches?

select winner, count() as top_win 
from ipl 
group by winner 
order by count()
desc limit 1;

4. Find out the number of matches each team has won so far?

select winner, count(*) as win from ipl
group by winner 
order by count(*)
desc ;

5. List out all the ground with total number of matches played each of them?(stadium-Total match)

select venue,count(*) as Stad_all_matches 
from ipl 
group by venue 
order by count(*) desc;

6. List out the top 10 umpires who have stood in most of match?

select concat(umpire1, umpire2,umpire3) as ump,count(*) as most_stood 
from ipl 
group by ump
order by count(*) desc limit 10;

7. List out top umpires who have stood the most umpire 1 ?

SELECT umpire1, COUNT(*) AS ump_1
FROM ipl
GROUP BY umpire1
ORDER BY ump_1 DESC;

8. List out top umpires who have stood the most umpire 2 ?

select umpire2,count(*) as upm2 
from ipl 
group by umpire2 
order by count(*) desc ;

9. Find out the name of every who has been a third umpire along with the number of matches?

SELECT umpire3 , COUNT(*) AS number_of_matches 
FROM ipl 
WHERE umpire3 IS NOT NULL 
GROUP BY umpire3;

10. Find out unique toss decision that have been taken by captain? (how many times fielding & bating)

select toss_decision,count(*) as unique_decision 
from ipl group by toss_decision;

11. Find out the list of unique results of matches?(win, tie, no result)

SELECT result, COUNT(*) AS unique_result_total
FROM ipl
GROUP BY result;

12. Find out all the team names who have won matches with more than 50 matches?

select 
winner, count(*) as won
from ipl
group by winner
having count(*) >50;

In summary, our analysis of IPL match data has unveiled key insights. We’ve identified standout players with the most ‘Man of the Match’ awards and highlighted the team with the most wins. Venue popularity and umpire contributions were also assessed. Toss decisions showcased captains’ strategies, and match outcomes reflected the excitement of IPL matches. Lastly, we recognized teams with over 50 wins, demonstrating their consistent success. This data-driven approach offers valuable insights for cricket enthusiasts, team management, and IPL stakeholders, aiding in strategic decisions and a deeper understanding of tournament dynamics.

Share your love
Tanmaya Sahu
Tanmaya Sahu

Tanmaya Sahu's Journey from Chemistry to IT and Data Science

Hello, I'm Tanmaya Sahu, a determined individual hailing from Bhubaneswar, India. My journey has been one of transformation, from a fresh graduate with a degree in Chemistry Honors to a budding professional with a passion for Information Technology and Data Science.

Educational Pursuits:

My academic journey began at Brajrajnagar College, where I pursued my Bachelor's degree in Chemistry Honors from 2018 to 2021. During those years, I found myself immersed in the world of chemistry, yet uncertain about my future path. Like many students, I was relishing the college experience but lacked a clear vision of my career aspirations.

It was only during my final year of graduation that I realized the importance of securing a stable job. I embarked on a quest for local employment opportunities, but my initial search was plagued by confusion and uncertainty. However, these challenges pushed me to reassess my ambitions and contemplate further studies.

Choosing a Path:

The decision-making process was not straightforward. I contemplated pursuing an MSc in Chemistry or venturing into the world of business and technology with an MBA or MCA. The plethora of options and my evolving interests made the choice a difficult one. Ultimately, I decided to pursue an MBA because it offered a versatile platform with diverse specializations, including Human Resources and Information Technology.

Although I was passionate about the IT sector, some external factors initially steered me toward HR and Finance. However, my heart continued to beat for Information Technology. After careful consideration, I decided to merge my interests and specialize in both HR and IT during my MBA journey.

Diving into the IT World:

During my MBA, I realized that merely scratching the surface of IT was not enough for me. I craved a deeper understanding and practical experience. This led me to explore various additional courses, and I delved into the world of Python programming.

Python was a challenge for me as a non-IT background student, but my determination pushed me forward. I discovered the fascinating world of data science, SQL, Power BI, Tableau, and statistics. With relentless dedication, I honed my skills and embarked on numerous projects, including creating voice assistants, developing GUI-based games, web scraping, and data analysis.

The Skill Set:

Today, I am proud to list Python, SQL, Data Science, Power BI, Tableau, and Statistics among my core competencies. I have undertaken a multitude of projects, demonstrating my proficiency in each of these domains. These projects have not only enriched my knowledge but have also provided practical, hands-on experience in the IT and data science fields.

In the realm of data analysis, I have uncovered valuable insights and trends, providing organizations with actionable information for strategic decision-making. My journey into IT has transformed me into a multifaceted professional, ready to contribute to the ever-evolving landscape of technology and data.

Get in Touch:

If you'd like to connect with me, discuss potential collaborations, or explore how my skills can benefit your organization, please feel free to reach out to me at 8594811431 or via email at [email protected]. I'm always eager to engage with like-minded individuals and tackle exciting projects that push the boundaries of innovation.

In my ever-evolving journey, I am excited to see what the future holds and how I can leverage my unique blend of expertise to make a positive impact in the world of Information Technology and Data Science. Thank you for joining me on this incredible adventure.

Articles: 72

Leave a Reply

Your email address will not be published. Required fields are marked *