Capstone Portfolio Projects

Real-World BI Projects

Apply DAX to realistic business scenarios, build production measure suites, and earn XP bounties.

Project 01 • Enterprise Model

+500 XP

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.

Omnichannel Sales Star Schema

8 Progressive DAX Tasks

0 of 8 Tasks Completed0%

Key Metrics Built:

Total Revenue & Orders
Average Order Value (AOV)
Prior Year Revenue (Time Intel)
YoY Growth Rate %
Top 5 Concentration (TOPN)
Revenue Contribution % (ALL)

Unlocks the BI Architect collectible trophy badge upon completion.