This project is an interactive Microsoft Excel dashboard designed to analyze Counter-Strike 2 (CS2) player and team performance using tournament data.
The dashboard provides insights into player performance, team performance, win/loss trends across maps, role-based analysis, fatigue impact, and top-performing players. It enables users to explore the data dynamically through interactive slicers and KPI cards.
- Analyze player and team performance in CS2 tournaments.
- Compare win and loss rates across different maps.
- Identify the best-performing player roles.
- Evaluate the impact of fatigue levels on performance.
- Highlight top-performing players using key performance metrics.
- Build an interactive dashboard using Microsoft Excel.
The dashboard includes key performance indicators:
| KPI | Value |
|---|---|
| Total Records | 6,000 |
| Average K/D Ratio | 2.71 |
| Win Rate | 51.9% |
| Average Performance Score | 39.5 |
| MVP Awards | 469 |
Compares the average performance score of different esports teams.
Shows how teams perform on different maps and compares win and loss percentages.
Analyzes performance across player roles such as:
- AWPer
- Entry Fragger
- IGL
- Lurker
- Support
Examines how fatigue levels influence player performance scores.
Highlights the highest-performing players based on performance score and K/D ratio.
The dashboard includes slicers that allow users to filter and explore the data dynamically.
- Team Name
- Player Role
- Map Played
All charts, KPIs, and tables update automatically based on slicer selections.
- Microsoft Excel
- Git
- GitHub
- Pivot Tables
- Pivot Charts
- Slicers
- KPI Cards
- Data Cleaning
- Data Formatting
- Dashboard Design
- Interactive Reporting
├── CS2_Esports_Master_Dataset.csv
├── Dashboard_Screenshot.png
├── esports_player_performance_tournament_analytics.xlsx
└── README.md
- Team performance varies significantly across tournaments.
- Certain maps consistently show higher win rates.
- Different player roles contribute differently to overall team success.
- Fatigue levels can impact performance scores.
- A small group of players consistently outperforms the rest of the dataset.
- Data Analysis using Excel
- Interactive Dashboard Development
- KPI Design
- Data Visualization
- Pivot Table Reporting
- Performance Analytics
- Business-Oriented Storytelling
- Dashboard UI/UX Design
Devansh Gupta
Aspiring Data Analyst focused on Data Analytics, Data Visualization, and Business Intelligence.
- GitHub: https://github.com/DevanshGupta03
- LinkedIn: www.linkedin.com/in/devansh-gupta03
⭐ If you found this project interesting, consider giving the repository a star.