This chapter utilizes the queries described in Chapter 2, Connecting to Sources and Transforming Data with M, to create both an import and a DirectQuery Data Model. Relationships are created between fact and dimension tables to enable business users to analyze the fact data for both Internet Sales and Reseller Sales simultaneously by using common dimension tables and across multiple business dates. A combination of relationships, bidirectional cross-filtering, and DAX measures will be used to support the analysis of actual sales data versus the Annual Sales and Margin Plan. Additionally, the product dimension table is enhanced with a hierarchy to enable simple drill up/down, and a custom sort order ...
Designing Import and DirectQuery Data Models
Get Mastering Microsoft Power BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
