Перейти к содержимому

Data modeling patterns every analyst should know w/ Ergest Xheblati

Census, a Fivetran company

0:00 / 0:00

Data modeling patterns every analyst should know w/ Ergest Xheblati

2 201 просмотр · 3 года назад
Census, a Fivetran company
1,62 тыс. подписчиков
2 201 просмотр · 3 года назад
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/