Capstone Semantic Model Project

Build a Sales Analytics Semantic Model

Step into the role of a Lead Power BI Developer. You've been given raw transactional data for an omnichannel technology distributor. Your mission is to construct the foundational DAX measure suite required by the CFO and Sales Operations team.

Project Bounty

+500 XP

BI Architect Certification

Progress: 0 / 8 Measures Built0%

Project Deliverables (0/8)

Task 1: Foundational Total Revenue

Create the core measure 'Total Revenue' aggregating all transactional revenue from the Sales table.

[fx]Task 1: Foundational Total Revenue=

Loading DAX Formula Studio...

Ctrl+Enter Check•Ctrl+Shift+F Format•Type [ for fields

Build a Sales Analytics Semantic Model

Project Deliverables (0/8)

Foundational Total Revenue

Order Volume Metric

Average Order Value (AOV)

Software Category Revenue

Equivalent Prior Year Revenue

YoY Growth Rate Percentage

Top 5 Customer Revenue

Revenue Contribution %

Task 1: Foundational Total Revenue