From the course: Excel Business Intelligence: Data Modeling 101
Join today to access over 22,500 courses taught by industry experts.
Data modeling introduction - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Data Modeling 101
Data modeling introduction
- Hey, guys. Welcome to Section Four, Data Modeling 101. Now, this section is a little bit more conceptual. We're going to cover a lot of the fundamentals of database design and normalization, which are absolutely critical when it comes to working with these tools, like Power Pivot, and DAX. So we'll cover concepts like table relationships, cardinality, lookup and data tables, and then get back into the hands-on work as soon as we've laid that groundwork. So let's do it.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
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
-
-