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

Unlock this course with a free trial

Join today to access over 23,400 courses taught by industry experts.

Active versus inactive relationships

Active versus inactive relationships - 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

Active versus inactive relationships

“

All right, guys, at the risk of sounding like a broken record, I want to take just one minute to really drive home this concept of table relationships versus merged tables. So I know there are some of you guys out there like this anonymous, confused man who's thinking, you know, I just want to merge these queries or I want to use lookup or related functions to pull all these attributes into one place. I want to blend that lookup in that fact table so that I have everything I need in a single monster table, kind of like this. You know, you've got fact table fields in the left, you've got attributes from your Calendar_Lookup there in the middle, you've got attributes from your Product_Lookup table. And this could go on and on until you're dealing with hundreds of different columns. And this is a normal habit to be in if you're a long-time Excel user. It was the habit that I was in as well. And the reason we have this habit is because tools haven't existed in Excel to let us model the…

Contents