Excel Business Intelligence: Data Modeling 101

Learn the basics of data modeling in Microsoft Excel from experienced Excel trainer Chris Dutton.

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.

Introduction

• Welcome

1. Getting Started

• Important: Versions and compatibility
• Set expectations

2. Data Modeling 101

• Data modeling introduction
• Meet the Excel data model
• Data versus diagram view
• Database normalization
• Data tables versus lookup tables
• Relationships versus merged tables
• Create table relationships
• Modify table relationships
• Active versus inactive relationships
• Relationship cardinality
• Connect multiple data tables
• Filter direction
• Hide fields from client tools
• Define hierarchies
• Data model best practices

Conclusion

• Next steps