From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

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

Optimize relationships

Optimize relationships - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Optimize relationships

“

- [Instructor] Okay, so in this sub lesson we're going to discuss optimizing relationships. So let's go ahead and just retake a look at the relationships we built. So if I take a look at the relationship between customer and sales, we can see that those are built on the customer key. The relationship here between sales territory and sales is built on the sales territory region, and the one over here is based on the keys as well. If I was to go back into my tables here and let's just go ahead and do that, I'm just going to go ahead and take a look at my product table. And if I take a look the product key, I'll see this as a whole number. So for a number of these relationships, the relationship is built on numeric-based columns. But for the relationship between sales and the sales territory region, we're actually basing the relationship on this text-based column, which is not an optimal way to build a relationship. Ideally, we'd like to have a relationship built between the sales…

Contents