Excel Business Intelligence Part 2: Data Modeling 101

Excel Business Intelligence Part 2: Data Modeling 101

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 05m | 212 MB

Learn the basics of data modeling in Microsoft Excel from experienced Excel trainer Chris Dutton. In this course—the second installment in the Excel Business Intelligence series—Chris discusses the essentials of database design and normalization. He steps through the data model interface in Excel and provides tried-and-true tips and tricks. The topics covered in this course can help you bolster your understanding of table relationships, hierarchies, and more.

Topics include:

  • Data versus diagram view
  • Database normalization
  • Data tables versus lookup tables
  • Creating and modifying table relationships
  • Differences between one-to-one, one-to-many, and many-to-many relationships
  • Connecting multiple data tables
  • Hiding fields from client tools
  • Defining hierarchies
Table of Contents

Introduction
1 Welcome

Getting Started
2 Important_ Versions and compatibility
3 Set expectations

Data Modeling 101
4 Data modeling introduction
5 Relationship cardinality
6 Connect multiple data tables
7 Filter direction
8 Hide fields from client tools
9 Define hierarchies
10 Data model best practices
11 Meet the Excel data model
12 Data versus diagram view
13 Database normalization
14 Data tables versus lookup tables
15 Relationships versus merged tables
16 Create table relationships
17 Modify table relationships
18 Active versus inactive relationships

Conclusion
19 Next steps