Sales Performance Dashboard0%
End-to-End Project with Real Dataset

Sales Performance Dashboard

Beginner12 min read•Updated: Jul 11, 2026
Study MaterialsCheatsheet

Real-World Project: Commercial Sales Performance Dashboard

The Sales Performance Dashboard is the most widely deployed analytical application in global enterprise BI. It provides sales directors, regional managers, and account executives with visibility into revenue velocity, quota attainment, product margins, and customer concentration.

1. Sales KPI Definitions & Business Targets

In this project, we utilize the real-world superstore_sales_analytics.csv dataset from public/downloads/datasets/:

  • Orders, discounts, categories, customer segments, regional geographies, and delivery modes.
Output
Core Sales Metrics Hierarchy:
[Total Gross Sales] ---> [Discounts Given] ---> [Total Net Sales]
|
+---------------------+---------------------+
| |
[Cost of Goods] [Sales Quota Target]
| |
v v
[Gross Profit] [Quota Attainment %]

2. Advanced Sales DAX Measures

DAX
-- 1. Total Net Sales
Total Sales = SUM(Fact_Sales[Sales])
 
-- 2. Total Profit
Total Profit = SUM(Fact_Sales[Profit])
 
-- 3. Overall Profit Margin %
Profit Margin % =
DIVIDE(
[Total Profit],
[Total Sales],
0
)
 
-- 4. Target Quota Attainment %
Quota Attainment % =
VAR Target = SUM(Dim_SalesTargets[AnnualQuota])
RETURN
DIVIDE([Total Sales], Target, 0)
 
-- 5. Average Order Value (AOV)
Average Order Value =
DIVIDE(
[Total Sales],
DISTINCTCOUNT(Fact_Sales[OrderID]),
0
)
 
-- 6. Dynamic Tier Assignment (SWITCH TRUE Pattern)
Performance Status =
VAR Attainment = [Quota Attainment %]
RETURN
SWITCH(
TRUE(),
Attainment >= 1.00, "Target Achieved (Green)",
Attainment >= 0.85, "On Track (Yellow)",
"Critical Risk (Red)"
)

3. Interactive Visual Architecture

Visual Architecture Blueprint
+-----------------------------------------------------------------------------+
| COMMERCIAL SALES OPERATIONS PORTAL                                          |
| [Sales: $4.2M | +14% YoY] [Profit: $1.1M | 26.2%] [AOV: $1,420] [Target: 98%]|
+-------------------------------------+---------------------------------------+
| Revenue by Product Sub-Category     | Regional Quota Attainment Gauge       |
| - Laptops:     $1.2M                | [ Gauge Visual: Target = $4.5M        |
| - Accessories: $850k                |                 Actual = $4.2M        |
| - Chairs:      $600k                |                 Needle at 93.3% ]     |
+-------------------------------------+---------------------------------------+
| Sales vs Profit Correlation Matrix  | Top 10 High-Value Customers           |
| [ Scatter Plot: Sales vs Margin %   | [ Ranked Table with Data Bars:        |
|   Bubbles sized by Order Count ]    |   Rank | Customer | Sales | Profit ]  |
+-------------------------------------+---------------------------------------+
Interactive Quiz

Multiple Choice Questions

Question 1
What DAX function is used to calculate the Average Order Value (AOV) correctly when a single order contains multiple product line items?
Question 2
Which visual type is standard for displaying actual performance against a fixed numerical goal (such as $4.5M annual sales target)?
Question 3
In the DAX pattern SWITCH(TRUE(), [Attainment] >= 1.0, "Green", [Attainment] >= 0.85, "Yellow", "Red"), what does SWITCH(TRUE()) accomplish?
Question 4
When analyzing customer profitability, what risk does a high sales volume accompanied by a negative profit margin indicate?
Question 5
What formatting feature in Power BI table and matrix visuals allows columns to display miniature horizontal color bars proportional to sales values?
Next Lesson

End-to-End Project with Real Dataset

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous LessonNext Lesson
HR Analytics DashboardEnd-to-End Project with Real Dataset

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

PreviousNext
PrevNext