GS
Back to projects
📊

Sales Performance Dashboard

Consolidating three years of regional sales data into one live decision-making surface.

ExcelPower BIDAX
View repository

Problem Statement

Regional sales leads were pulling numbers from five disconnected spreadsheets, and monthly reporting took a full day to assemble by hand.

Dataset Overview

36 months of transaction-level sales data across 4 regions and 120+ SKUs, originally split across weekly export files.

Cleaning Process

  • Standardized inconsistent date and currency formats across source files
  • Removed duplicate transactions using composite keys
  • Built a Power Query pipeline to auto-refresh new monthly exports

SQL / Analysis Queries

SELECT region, SUM(revenue) FROM sales GROUP BY region ORDER BY 2 DESC
Revenue trend DAX measure using CALCULATE + SAMEPERIODLASTYEAR

Business Insights

  • Two regions accounted for 61% of total revenue
  • Top 10 products drove nearly half of quarterly growth
  • A seasonal dip in Q1 was consistent across all four years

Results

Cut monthly reporting prep time from a full day to under an hour
Gave regional leads a self-serve dashboard instead of ad-hoc requests
Back to all projects