برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Excel Business Intelligence: Data Modeling 101

1h 5mIntermediate2018-05-17

Authors

Chris Dutton

Certified Microsoft Excel Expert, Analytics Consultant

Course details

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.

Learning objectives
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

Skills covered

Data ModelingSpreadsheetsMicrosoft ExcelData ScienceBusiness Software and ToolsMicrosoftOne-Off

Concepts

0. Introduction

01 - Welcome

1. Getting Started

02 - Important - Versions and compatibility
03 - Set expectations

2. Data Modeling 101

04 - Data modeling introduction
05 - Meet the Excel data model
06 - Data versus diagram view
07 - Database normalization
08 - Data tables versus lookup tables
09 - Relationships versus merged tables
10 - Create table relationships
11 - Modify table relationships
12 - Active versus inactive relationships
13 - Relationship cardinality
14 - Connect multiple data tables
15 - Filter direction
16 - Hide fields from client tools
17 - Define hierarchies
18 - Data model best practices

Conclusion

19 - Next steps