Consolidated Sales Dashboard

Consolidated Sales Dashboard (Excel-Based)
Automated, Filterable, Insight-Driven

This project is a hands-on example of how to build a powerful, interactive Sales Dashboard using just Microsoft Excel—ideal for fast-paced environments where simplicity and automation matter.

Core Workflow:

• All monthly sales data files are stored in a folder.

• Using Power Query, the system automatically imports and updates all available sheets.

• Data is transformed, modeled, and analyzed using pivot tables.

• The dashboard provides a clean UI with timeline filters and category-wise drilldowns.

Dashboard Highlights:

• Total Sales and Transactions

• Min & Max Sales with corresponding months

• Monthly Sales Trend (Line Chart)

• Sales by Product (Bar Chart)

• Product Contribution to Total Sales (Clustered Bar Chart)

• Transactions (Bar Chart)

Interactive Filters:

• Time Range

• Region

• Channel Category

• Product Type

Why it matters:
This dashboard proves that Excel, when used right, can deliver BI-level performance for sales tracking, performance insights, and stakeholder reporting—without complex setups.

Built With:

• Microsoft Excel

• Power Query

• Pivot Tables

• Native Charts and Slicers