Skip to content

🏏 Power BI Cricket Analytics Dashboard This project delivers an interactive Power BI dashboard that visualizes cricket match data to uncover insights on team performance, player stats, and match outcomes. It includes cleaned datasets, DAX measures, Power Query scripts, and PDF reports to support a complete analytics workflow. Key insights include

Notifications You must be signed in to change notification settings

Ruchir-Huchgol/Data_analysis_projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

3 Commits
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“‚ Repository Structure powerbi-cricket-analysis/ β”œβ”€β”€ data/ # Raw cricket datasets (CSV/Excel/JSON) β”‚ └── matches_data.csv β”œβ”€β”€ powerbi/ # Power BI-specific files and assets β”‚ β”œβ”€β”€ cricket_dashboard.pbix # Main Power BI dashboard file β”‚ β”œβ”€β”€ visuals/ # Exported PNG/SVGs of visuals β”‚ β”œβ”€β”€ measures.md # DAX measures used β”‚ └── queries/ # Power Query M code snippets β”œβ”€β”€ reports/ # Report exports and descriptions β”‚ β”œβ”€β”€ overview_report.pdf β”‚ └── player_performance.pdf β”œβ”€β”€ exports/ # Optional: CSV exports from Power BI β”‚ β”œβ”€β”€ team_wins.csv β”‚ └── top_players.csv β”œβ”€β”€ documentation/ # Project documentation and notes β”‚ β”œβ”€β”€ README.md β”‚ └── analysis_plan.md β”œβ”€β”€ LICENSE └── .gitignore

🏏 Power BI Cricket Analytics Dashboard

This repository hosts a Power BI-based analysis of cricket match data. The goal is to visualize trends, performance metrics, and match outcomes through an interactive dashboard.


πŸ“ Structure

  • data/: Contains cleaned datasets used in Power BI
  • powerbi/: Main .pbix dashboard, DAX measures, Power Query scripts
  • reports/: PDF reports exported from Power BI
  • exports/: Data tables exported from Power BI visuals
  • documentation/: Analysis plan and README

πŸ“Š Dashboard Highlights

Key features of the dashboard include:

  • Team vs. Team Win Comparison
  • Venue-wise Performance Analysis
  • Toss Effect on Match Results
  • Top Players (Batting & Bowling) by Performance
  • Timeline-based Win Trends

πŸ“Œ See the .pbix file in /powerbi/ to open and explore the full interactive report.


βš™οΈ Requirements

  • Power BI Desktop (latest version)
  • Source Dataset: CSV files located in /data/

πŸš€ Getting Started

  1. Download or clone the repo
  2. Open powerbi/cricket_dashboard.pbix in Power BI Desktop
  3. Make sure the data source path is updated if you move the dataset
  4. Refresh the dataset to load the latest data

πŸ“„ Documentation

  • See documentation/analysis_plan.md for analysis strategy
  • DAX Measures used are documented in powerbi/measures.md
  • Power Query M transformations can be found in powerbi/queries/

🀝 Contributing

Pull requests are welcome. For any major changes, please open an issue first to discuss improvements or feature requests.

About

🏏 Power BI Cricket Analytics Dashboard This project delivers an interactive Power BI dashboard that visualizes cricket match data to uncover insights on team performance, player stats, and match outcomes. It includes cleaned datasets, DAX measures, Power Query scripts, and PDF reports to support a complete analytics workflow. Key insights include

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published