Free resource / Microsoft Fabric
Build reporting on a model you can trust.
A seven-page guide to dimensional modeling in Microsoft Fabric: facts, dimensions, keys, relationships, and warehouse practices that support Power BI reporting.
Get the free guide
Enter your email in Microsoft Forms. Opens in a new tab.
PDF · 7 pages · Published April 2025
PHOENIX DATAWORKS / FIELD GUIDE
Master Data
Modeling
in Microsoft Fabric
What you’ll learn
A practical foundation for your next warehouse.
- Fact and dimension table design
- Kimball dimensional modeling principles
- Keys and relationships for analytical queries
- Fabric warehouse practices and Power BI integration
Inside the guide
Give every measure a clear context.
The guide explains how fact tables capture measurable events while dimensions describe those events. For sales reporting, product and date dimensions provide the context around each transaction.
Product dimensionSales fact
Quantity · amountDate dimension
Quantity · amountDate dimension
Illustration of a pattern discussed in the guide. The PDF covers dimensions, keys, relationships, and modeling practices.
Preview a page from the PDF
