IPL Data Analysis Case Study Using SQL

Data Analytics Portfolio Project using real world data for beginners

Case study on iThinkData By Vaibhav Chavan

Subscribe to iThinkData for more SQL case studies and tutorials.

Introduction

This repository contains a series of SQL queries designed to answer insightful questions about IPL (Indian Premier League) matches and player performances from 2008 to 2024. The dataset used for this case study consists of two CSV files:

• Matches Data: Information about every match, including teams, venue, result, and other match-related details.
• Deliveries Data: Ball-by-ball data for each match, including details about the runs, wickets, and other actions in each delivery.

These SQL queries have been crafted to explore key cricket statistics, including team performances, player consistency, and other insights that are commonly discussed by cricket enthusiasts.

Purpose

The main objective of this case study is to:

• Understand how SQL can be used to extract meaningful insights from large datasets.
• Solve real-world analytical questions related to IPL matches and player performances.
• Demonstrate SQL techniques, including JOINs, Window Functions, GROUP BY, HAVING, and Ranking Functions.

Dataset

To follow along with the SQL queries, you can download or connect to the IPL datasets (matches and deliveries) which include match data from 2008 to 2024.

How to Use

• Clone or download the repository.
• Open the provided SQL queries in your preferred SQL environment. ( I have used MySQL)
• Run the queries on the IPL dataset to generate insights.
• Feel free to adapt the queries to your specific needs or explore additional questions based on the data.

Contributing

Contributions to the case study are welcome! If you have additional questions or insights related to the dataset, feel free to submit a pull request or open an issue.

Click Here to go to Questions, SQL Queries Solutions and Outputs.

---

🙋‍♂️ About Me

I’m Vaibhav Chavan, the creator of iThinkData, a platform dedicated to making data analytics and SQL easy to understand for everyone. Follow along as I dive deep into SQL tutorials, case studies, and data projects on YouTube.

🌟 Stay Connected with iThinkData ! 🌟

🎥 Subscribe to iThinkData : 🔔 Don't miss out on weekly data challenges, tutorials, and expert insights! 💡📈

👨‍💼 LinkedIn : 📊 Let’s connect professionally and build a powerful data-driven network! 💼🌐

💬 Join My WhatsApp Channel : 📱 Be the first to get exclusive content, project updates, and new videos! 🚀📊