From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Relationship cardinality

Relationship cardinality - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Relationship cardinality

“

- [Instructor] Time to talk about cardinality and specifically table relationship cardinality. So by definition, cardinality refers to the uniqueness of values in a column. So if you hear people talk about a one-to-one relationship, or a one-to-many, or many-to-many, those are examples of relationship cardinalities. Now, in Power Pivot, at least in the current version, all relationships in a data model really should follow a one-to-many cardinality. And you already know what this means, It just means that each column or key that we're using to join tables can only have one instance of each unique value in the lookup table, which is exactly what makes those primary keys. But they may have many instances of each unique value in the data tables. That's why we call them foreign keys. So none of this is really new, it's just kind of putting the academic definition around it. So in this case that we're looking at here, you…

Contents