Cricsheet-Match-Analysis

Cricsheet Match Data Analysis

A comprehensive data analysis project that processes, and visualizes cricket match data from Cricsheet.org using Python, SQL, and Power BI.

Project Overview

This project aims to analyze cricket match data across different formats (Test, ODI, T20, IPL) to derive meaningful insights about player performance, team statistics, and match outcomes. The analysis includes automated data collection, SQL-based analysis, and interactive visualizations.

Features

• Data processing and transformation of JSON files using Python
• SQL database management and analysis
• Interactive visualizations using Power BI
• Exploratory Data Analysis (EDA) using Python libraries
• 20 analytical SQL queries for cricket insights

Tech Stack

• Python
• Pandas
• SQL (MySQL)
• Power BI
• Matplotlib
• Seaborn
• Plotly

Key Features

1. Data Collection

   • JSON file processing and validation

2. Data Analysis

   • Player performance metrics
   • Team statistics
   • Match outcome analysis
   • Performance trends

3. Visualizations

   • Interactive Power BI dashboards
   • Statistical plots and charts
   • Performance trend analysis