A collection of Excel-based analytics projects demonstrating skills in data cleaning, pivot tables, dashboards, and visualization.
- Bike Sales Dashboard
- File:
BikeSales_Project CSV.xlsx - Focus: Customer demographics, income vs. purchase behavior, commute distance analysis, and age brackets.
- Features: Interactive slicers (Marital Status, Region, Education, Occupation), pivot tables, and a professional dashboard.
- File:
- End-to-end workflow: raw data β formatted tables β pivot tables β dashboards
- Interactive slicers for dynamic filtering
- Clean, accessible visuals (color-blindβfriendly design)
- Business insights from real-world datasets
- Microsoft Excel
- Pivot Tables
- Charts & Slicers
- Data Cleaning & Formatting
- Download the
.xlsxfile. - Open in Microsoft Excel.
- Explore the dashboard using slicers and charts.