Building the Hospital Data Model

Learning Objectives

• Primary keys, foreign keys, and relationship cardinality
• Build a working data model connecting all 5 hospital tables
• Distinguish fact tables from dimension tables in the hospital dataset
• Diagnose and fix an incorrect or missing relationship in Model view

Key Topics Covered

• Model view walkthrough
• One-to-many relationships and cross-filter direction
• Autodetect vs. manual relationships
• Fact tables vs. dimension tables
• Hiding technical fields and organizing display folders
• Building a Date table