From the course: Excel Business Intelligence: Data Modeling 101
Unlock this course with a free trial
Join today to access over 22,500 courses taught by industry experts.
Active versus inactive relationships - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Data Modeling 101
Active versus inactive relationships
- [Instructor] Let's take a minute and talk about something called active versus inactive relationships. Consider this data model here, this is the same model that we're working with. You'll note that on the right side of the model you actually have two relationships drawn between the calendar look up table and this food mart transactions table. And the reason there are two lines is because there are two date fields in the transactions table and only one date field in calendar. So what we've done in this case is we've drawn a relationship between each of the date fields in the transaction table, but the issue is that both can't be active at the same time. So if you were to right click or double click each of those two lines, you would see following edit relationship windows. And if you look really closely at the bottom left corners, there's a box that says active and only one of the two is checked. Now the one that's checked is the one that produces the solid line, and the one that's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Data modeling introduction28s
-
Meet the Excel data model3m 38s
-
Data versus diagram view2m 33s
-
Database normalization4m 15s
-
Data tables versus lookup tables5m 40s
-
Relationships versus merged tables2m 7s
-
Create table relationships6m 55s
-
Modify table relationships2m 7s
-
Active versus inactive relationships3m 55s
-
Relationship cardinality5m 43s
-
Connect multiple data tables5m 59s
-
Filter direction5m 8s
-
Hide fields from client tools4m 59s
-
Define hierarchies3m 54s
-
Data model best practices1m 38s
-
-