- Welcome
-
Course Overview 3 min
- Lessons
-
Data Modeling Basics and Types of Data Models 12 min
-
Modeling Challenges 23 min
-
Role Playing Dimensions (Multiple Join Paths) 16 min
-
Hierarchies 32 min
-
Worksheet Design Guidelines and Join Directionality/Color 10 min
Please register to access Data Modeling Basics and Types of Data Models.
×
Advanced Data Modeling - Recorded Sessions
Adv Data Modeling
Building upon the skills learned in the Making Data Searchable course, this course will take a deep dive into data modeling and optimizing the loaded data for the ThoughtSpot search experience. Beginning with topics on data modeling design types you will learn about the benefits and detractions of different modeling design choices. The class quickly moves into hands-on lecture around Modeling challenges like many to many relationships, 1 to 1 relationships, chasm and fan traps, multiple join paths and hierarchies and how to resolve them. Guidelines for building worksheets within different models and understanding the worksheet join rule round out the course.
Topics Covered:
- Data Model Design Types
- Snowflake
- Star
- Inverted Star
- Flat Denormalized
- Modeling Challenges and How to Resolve them
- Many to Many
- 1 to 1
- Chasm Traps
- Fan Traps
- Multiple Join Paths
- Hierarchies
- Balanced
- Ragged
- Unbalanced
- Worksheet Join Rule and Directionality
- Worksheet Design Best Practices
Prerequisites
Previous courses in the Business User, Business Analyst, & Data Expert learning paths.