Chapter 9: Star Schema and Data Modeling Common Best Practices
In the previous chapter, we learned a lot about data modeling components in Power BI Desktop, including table and field properties. We also learned about the feature tables and how they make a table from our data model accessible across the organization. We then learned how to build summary tables with DAX. Then we looked at the relationships in more detail; we learned about different relationship cardinalities, filter propagation, and bidirectional relationships. In this chapter, we look at some star schema and data modeling best practices, including the following:
- Dealing with many-to-many relationships
- Being cautious with bidirectional relationships
- Dealing with inactive relationships
- Using configuration tables
- Avoiding calculated columns when possible
- Organizing the model
- Reducing model size by disabling auto date/time
In this chapter, we use the Chapter 9, Star Schema and Data...
