Creating the Excel Data Model

Topics Covered

• Understanding relational databases
• Creating relationships
• Primary and foreign keys
• Data normalization
• Fact and dimension tables
• Star schema concepts
• Data Model optimization
• Relationship management
• Data integrity
• Model validation

Module Description

• Participants build efficient relational data models within Excel by linking multiple tables. The module introduces best practices for designing scalable and high-performance analytical models.

Hands-on Lab

• Create a relational business data model
• Validate table relationships