E-Commerce Sales Report Dashboard
An advanced Excel dashboard for 2022 e-commerce sales analysis. Uses pivot tables, dynamic charts, conditional formatting, and VBA macros to deliver an interactive reporting tool — no external BI tool required.
Problem
E-commerce businesses often store transactional data in flat CSV exports with no built-in analysis layer. Stakeholders need to understand sales trends, top categories, and regional performance without learning a BI tool.
Solution
Structured Excel workbook with raw data, pivot layer, and dashboard sheets. Pivot tables aggregate sales by product category, region, month, and channel. Dynamic charts update via slicers. Conditional formatting highlights anomalies. VBA macros automate refresh and export.
Architecture
Cleaned raw transaction data in a structured table format with named ranges. Data validation ensures clean input for downstream pivots.
Multiple pivot tables aggregating by category, region, month, and sales channel. Linked to shared slicers for synchronized filtering across the dashboard.
Bar, line, and donut charts linked to pivot tables — update dynamically when slicers are applied. Formatted to match a consistent visual style.
Macros for data refresh, dashboard reset, and PDF export of the current filtered view.
Highlights
- Shared slicers across multiple pivot tables for synchronized dashboard filtering.
- Conditional formatting highlights underperforming categories and anomalies.
- VBA macros for automated refresh and PDF export.
- Zero external dependencies — fully self-contained Excel workbook.