Data modeling patterns every analyst should know w/ Ergest Xheblati
Ergest Xheblati is the author of Minimum Viable SQL Patterns, and he's spent the last 15+ years mastering data modeling.
This workshop, you'll learn:
🎯 Patterns that Ergest uses to build robust and maintainable data models
🎯 How model a business processes with activities (Ergest's preferred method)
🎯 Why model a business process with activities (in-depth pros and cons included)
🎯 How to use activity models for multiple use cases (BI, analysis, reverse ETL)
During the last 20 minutes, Ergest answer various audience questions, including:
🤔 How should I go from basic fact & dims schema to activities and entities efficiently? How should I sell this to management?
🤔 What is your go-to for obtaining and playing around with practice data sets?
🤔 Would you suggest this modeling pattern for activity/event type of data or for all type of source data?
🤔 How does this modeling process relates to the Data Vault? Is it used instead of a Data Vault or do they work together?
Have more data modeling questions for Ergest? Ask him in the Operational Analytics Club Slack! 👇
Join here - https://www.operationalanalytics.club/