IPL was established in 2008 and currently consists of ten teams in ten cities across India. The inaugural IPL season was won by Rajasthan Royals. As of May 2022, there have been fifteen seasons of the IPL tournament. The latest season was conducted with Gujarat Titans winning their first title. So, this repository contains Exploratory Data Analysis of IPL (2008-2020) using SQL (Structured Query Language).
| Files/Folder | Description |
|---|---|
| Dataset Folder | This folder provides you two datsets i.e IPL_MATCHES.csv and IPL_BALL.csv |
| Analyses Folder | This folder contains 2 PDF file i.e anlysing Questions and Answer of that questions. |
| IPL_SQL File | This file provides you .sql format file which you can download and work on analysis using SQL platform. |
o Fetching count of columns and rows.
o Top 5 matches which were won by maximum number of runs.
o Fetching the total number of boundaries and dot balls.
o Runs conceded in ipl by SK Warne.
o Top 5 bowlers who conceded maximum extra runs.
o Fetching duplicate data and doing many more analysis.
Must browse through from each folder of this repository must start with:
1.Always start with creating Database in SQL platform.
2.Then Import csv file. Below procedure and screenshot shows how to **import CSV** dataset in SQL SERVER.
o First go to Explorer window section.
o Left click on database in Explorer window
o Then select Task option
o And in last go to Import Flat file section and select CSV files and import it.
I'm an aspiring data analyst...
• Structured Query Language (SQL)
• Python
• Excel
• Tableau
• Python
• Analytical Visualisation
• PowerPoint
• MS Word