Chapter 8. Many-to-many relationships
Many-to-many relationships are an important tool in the data analyst’s toolbelt. Often, they are viewed as problematic because many-to-many relationships tend to make the model more complex than usual. However, we suggest you start thinking about many-to-many relationships as an opportunity instead. In fact, it’s easy to handle many-to-many relationships. You only need to learn the basic technique and then use it at your convenience.
As you will learn in this chapter, many-to-many relationships are extremely powerful and let you build great data models—even if they hide some complexity both in the modeling and in the interpretation of the results. Moreover, many-to-many relationships are present in nearly ...
Get Analyzing Data with Power BI and Power Pivot for Excel, First 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.
