Home»2022»December»15»Linkedin Excel Business Intelligence Part 2 Data Modeling 101
08:49:51
Linkedin Excel Business Intelligence Part 2 Data Modeling 101
Included Exercise Files
Skill Level : Advanced
Duration : 1h 5m
Language : English
Released : 5/17/2018
Size : 185,50 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
