Building a Power BI Data Model

In this chapter, we will cover the following recipes:

• Designing a multi fact data model
• Implementing a multi fact data model
• Handling one-to-many and many-to-many relationships
• Assigning data formatting and categories
• Configuring Default Summarization and sorting
• Setting the visibility of columns and tables
• Embedding business definitions into DAX measures
• Enriching a model with analysis expressions
• Building analytics into data models with DAX
• Integrating math and statistical analysis via DAX
• Supporting virtual table relationships
• Creating browsable model hierarchies and groups