Sales Performance Analytics Dashboard
Project Overview
This Power BI dashboard analyzes sales performance across multiple dimensions including product categories, territories, stores, and time periods. Built with DAX calculations, it provides stakeholders with actionable insights into profit margins, regional performance, and seasonal trends.
Key Metrics
- • Total Sales: $38.58M
- • Total Profit: $16.61M
- • 5 Product Categories
- • 4 Store Locations
Technical Skills
- • DAX Calculations
- • Data Modeling & Relationships
- • Interactive Visualizations
- • Cross-filtering & Drill-downs
Dashboard Screenshots
Profit Analysis by Product Category
Garden and Plumbing categories lead in profitability, with Garden generating $3.4M in profit
Store Performance & Satisfaction Analysis
Combined revenue and profit analysis with customer satisfaction metrics by store manager
Territory Sales Trends (2018-2021)
Four-year trend analysis showing sales peaked in 2020 with gradual decline in 2021
Quarterly Performance by Store (2019-2021)
Detailed quarterly breakdown showing seasonal patterns and store-specific performance variations
Q1-Q3 2020 Profit Analysis by Store
Store 102 contributed the highest profit ($0.60M) during the peak performance period
Product Category Performance by Quarter (Q1-Q4 2020)
Garden and HVAC categories show strong Q1 performance, with consistent profit margins across quarters
Organization Members: Access the live interactive dashboard below
Technical Implementation
DAX Calculations
DAX formulas were implemented to calculate complex business metrics. Example calculation below:
Profit = CALCULATE(
SUM(Sales Detail 2018 to 2023[Revenue])
- SUM(Sales Detail 2018 to 2023[Cost])
* SUM(Sales Detail 2018 to 2023[Sales_Quantity])
)Key Features
- Multi-dimensional profit analysis across 5 product categories
- Store performance tracking with manager-specific metrics
- Time-series analysis spanning 4 years (2018-2021)
- Quarterly trend analysis with seasonal insights
- Interactive cross-filtering across all visualizations
- Customer satisfaction correlation with financial performance
Business Impact
- Identified Garden category as top profit driver ($3.4M)
- Revealed 2020 as peak performance year
- Highlighted Store 102 exceptional Q1-Q3 2020 performance
- Enabled data-driven territory and product planning
- Improved decision-making speed with real-time insights
Data Sources & Modeling
- Sales transaction data (2018-2023)
- Product category and inventory information
- Store location and manager assignments
- Customer satisfaction survey results