NBA Player Stats & MVP Analysis (Excel)
Data-driven analysis of NBA player performance across seasons and eras using Excel Pivot Tables and Charts.
This project explores NBA player statistics to compare performance across different eras (1990sā2020s), analyze efficiency metrics, and identify MVP-level players using a weighted index model. The analysis was conducted entirely in Excel using Pivot Tables, Pivot Charts, and calculated fields.
Key Insights
- Top scorers, rebounders, and playmakers by season
- Efficiency comparison using TS% and Usage%
- Era-based comparison of player size and performance
- MVP ranking using weighted performance metrics
Excel Data Cleaning & Dashboard Project
A complete Excel project involving data cleaning, transformation, analysis, and dashboard creation using Pivot Tables and Charts.
.png)
This project focuses on analyzing sales data to uncover key business trends. After cleaning and organizing the dataset, detailed insights were generated using pivot tables and dynamic charts. The final dashboard showcases KPIs such as Monthly Sales, Top Products, and Category-wise performance. This project demonstrates strong skills in Excel analytics and visualization.
š View Full Excel Project on GitHub
Data Cleaning Steps
- Removed duplicate records
- Handled missing/blank values
- Fixed inconsistent date formatting
- Split and organized product categories
Dashboard Features
- Total Sales by Month
- Product-wise Performance
- Interactive slicers and filters
- Top 5 Best-Selling Items
