An interactive Excel dashboard built using PivotTables, PivotCharts, and slicers to analyze sales, operating profit, and profit margins across retailers and product categories. The workbook transforms raw sales data into actionable KPIs and visual insights for performance tracking, trend analysis, and data-driven decision-making.
This project demonstrates how raw sales data can be transformed into an interactive business intelligence dashboard. Users can explore performance through dynamic filtering, compare retailers and product categories, monitor key business metrics, and uncover trends that support data-driven decision-making.
| Worksheet | Purpose |
|---|---|
| Data | Raw sales dataset |
| Analysis | PivotTables, PivotCharts, and supporting calculations |
| Dashboard | Interactive dashboard with KPIs, charts, and slicers |
- Interactive slicers for filtering by retailer, product, and time period
- PivotTables and PivotCharts for dynamic reporting
- KPI tracking for Sales, Operating Profit, and Profit Margin
- Performance comparison across retailers and product categories
- Trend analysis to identify business opportunities
- Clean workflow separating data, analysis, and reporting
- Microsoft Excel
- PivotTables
- PivotCharts
- Slicers
- Conditional Formatting
- KPI Development
- Data Cleaning
- Data Visualization
- Data Analysis
- Dashboard Design
- Business Intelligence
- KPI Reporting
- Data Visualization
- Trend Analysis
- Performance Monitoring
- Excel Analytics
- Business Decision Support
| File | Description |
|---|---|
Excel_Performance_Dashboard.xlsx |
Complete workbook containing the Data, Analysis, and Dashboard worksheets |
dashboard-overview.png |
Dashboard preview |
Author: Cynthia Osiemo