A collection of interactive Excel dashboards focused on business, sales, customer, and healthcare data analysis.
This repository contains Excel-based data analytics projects created to explore data cleaning, PivotTables, PivotCharts, KPI analysis, slicers, and interactive dashboard development.
Each project focuses on transforming structured datasets into visual reports that make trends, patterns, and operational metrics easier to understand.
An interactive healthcare analytics dashboard designed to analyze emergency room activity and patient-related operational metrics.
- Total patient volume
- Average patient wait time
- Patient satisfaction score
- Gender-wise patient distribution
- On-time vs delayed attendance
- Admission status analysis
- Patient age-group distribution
- Department-wise patient volume
- Monthly and yearly filtering
- PivotTables
- PivotCharts
- Slicers
- KPI Cards
- Data aggregation
- Percentage analysis
- Interactive filtering
- Dashboard layout design
📁 Excel Workbook: Hospital-ER-Dashboard.xlsx
A business sales dashboard designed to analyze sales performance, profit, sales channels, payment methods, product categories, and delivery activity.
- Total sales
- Total profit
- Regional sales performance
- Monthly performance distribution
- Online vs offline sales
- Payment mode distribution
- Product category analysis
- Product sub-category filtering
- City-level analysis
- Delivery status analysis
- PivotTables
- PivotCharts
- KPI Cards
- Timeline filters
- Slicers
- Donut and pie charts
- Bar and line charts
- Interactive dashboard filtering
- Multi-dimensional sales analysis
📁 Excel Workbook: Sales-Analytics-Dashboard.xlsx
An Excel dashboard focused on customer demographics and bike purchasing patterns.
- Gender-based income comparison
- Bike purchase distribution
- Customer age-group analysis
- Commute distance analysis
- Regional filtering
- Education-level filtering
- Gender-based filtering
- PivotTables
- PivotCharts
- Slicers
- Customer segmentation
- Demographic analysis
- Interactive filtering
- Comparative visual analysis
📁 Excel Workbook: Bike-Sales-Dashboard.xlsx
flowchart LR
DATA[📁 Raw Dataset]
--> CLEAN[🧹 Data Preparation]
CLEAN --> PIVOT[📊 PivotTables]
PIVOT --> KPI[🎯 KPI Analysis]
PIVOT --> CHARTS[📈 PivotCharts]
KPI --> DASH[🖥️ Interactive Dashboard]
CHARTS --> DASH
DASH --> FILTER[🎛️ Slicers & Timelines]
FILTER --> INSIGHTS[💡 Data Insights]
| Category | Skills |
|---|---|
| Analytics Tool | Microsoft Excel |
| Data Analysis | PivotTables, Aggregation, Percentage Analysis |
| Visualization | PivotCharts, KPI Cards, Dashboard Design |
| Interactivity | Slicers, Timelines, Dynamic Filtering |
| Analysis Areas | Sales, Customer, Business, Healthcare Analytics |
excel-data-analytics-projects/
│
├── Hospital-ER-Dashboard.xlsx
├── Hospital-ER-Dashboard-Preview.png
│
├── Sales-Analytics-Dashboard.xlsx
├── Sales-Analytics-Dashboard.png
│
├── Bike-Sales-Dashboard.xlsx
├── Bike-Sales-Dashboard-preview.png
│
└── README.md
These projects were created to strengthen practical skills in:
- Data analysis using Microsoft Excel
- Business KPI identification
- Interactive dashboard development
- Data visualization
- Customer and demographic analysis
- Healthcare operational analytics
- Converting raw data into understandable visual reports
- Power Query-based automated data transformation
- Advanced Excel formulas and lookup workflows
- Power Pivot and Data Model integration
- DAX-based measures
- Power BI dashboard versions
- Automated dashboard refresh workflows
Built with 📊 by Mayank Pradhan