9
Star Schema and Data Modeling Common Best Practices
In the previous chapter, we learned about data modeling components in Power BI Desktop, including table and field properties. We also learned about featured tables and how they make dataset tables accessible across an organization. We then learned how to build summary tables with DAX. We also 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
- Avoiding bidirectional relationships
- Dealing with inactive relationships
- Using configuration tables
- Avoiding ...
Get Expert Data Modeling with Power BI - Second Edition 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.
