Data Modeling - Walking Through How To Data Model As A Data Engineer - Dimensional Modeling 101

Подписаться 96 тыс.

Просмотров 28 тыс.

50% 1

Data modeling is key skill data engineers need to know.
In particular dimensional modeling. Whether you eventually decide to go into one big table or you just need to go through and think about your data model.
You'll likely put together a dimensional model.
So here is a quick rundown of dimensional modeling with a walk through.
If you enjoyed this video, check out some of my other top videos.
Data Modeling Challenges - The Issues Data Engineers & Architects Face When Implementing Data Models
• Data Modeling Challeng...
What Is Change Data Capture - Understanding Data Engineering 101
• What Is Change Data Ca...
If you would like to learn more about data engineering, then check out Googles GCP certificate
bit.ly/3NQVn7V
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
seattledataguy.substack.com/
Or check out my blog
www.theseattledataguy.com/
And if you want to support the channel, then you can become a paid member of my newsletter
seattledataguy.substack.com/s...
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: / @seattledataguy
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@user-ps3gr3ed1z 2 дня назад

the increase in quality and production is awesome

@HoneyCombAI 5 месяцев назад

I’ve been thinking about talking on the same subject (dimensional modeling), excited to take a look at this and seeing this knowledge propagated correctly. Nice work.

@SeattleDataGuy 5 месяцев назад

Thank you, I am doing my best to stay true to the sources and add in some real life experience

@SeattleDataGuy 5 месяцев назад

If you guys want to learn more about data engineering, then sign up for my newsletter here seattledataguy.substack.com/ or join the discord here discord.gg/2yRJq7Eg3k

@Milhouse77BS 5 месяцев назад

Yay, dimensional modeling. Kimball and Adamson and Reeves and Ross.

@jusaverage6347 4 месяца назад

I’ve actually used “bridging” or “linking” tables in databases I’ve designed. I just have logic included that makes sure to grab the latest item when bridging/linking like an IS_Current or IS_Latest column.

@carstenklausman4832 5 месяцев назад

Nice video that touch on the basics - but maybe some reflection on today’s capabilities e.g. compression/ column store, that were not around when he wrote the book, that could change some of the design patterns. But overall his principles are still valid today.

@chrisclarke5 5 месяцев назад

Thanks very much for this great video!

@SeattleDataGuy 5 месяцев назад

My pleasure!

@raphaeldayan Месяц назад

great video thank you so much

@KPYCHIK 5 месяцев назад

Great video. What other books you may suggest to read on this topic?

@vikram--krishna 5 месяцев назад

Thanks for the video! I would love to learn about One big table model and its use cases and its pros, cons. Thanks

@poojasikdar3583 4 месяца назад

size, redundancy, performance, compute time.. - few of the factors to be mindful of when dealing with big flat tables

@firefoxmetzger9063 5 месяцев назад

An example of where a bridge table is necessary (and I havend found a good way around it): UserID and DeviceID stitching in clickstream data. You want to follow user behavior across devices, but you will likely only discover the link between two devices much later. I.e. both devices will generate data in the big fact table, but only much later (often days) will you realize that this was actually the same user. You don't want to run "update" queries against a clickstream fact table for cost reasons, but you need some way to say that this data is all from the same user.

@poojasikdar3583 4 месяца назад

can we have two dimensions instead of a bridge table - users and devices. Both of these are connected to the fact table in a 1:N relationship with user_id and device_id, as the FKs. So, from the users' slicer when you select a specific user - corresponding devices will appear in the table view and when you select a device from devices' slicer corresponding users will appear in the table view. Is my understand correct or is the requirement different?

@firefoxmetzger9063 3 месяца назад

@@poojasikdar3583 whay happens if a visitor browses the site without being logged in (no userID available) and then logs in on the same device 1 week later? You have stored events with userID 'null' in your fact table (you didn't know the correct value at insertion time). Any slicing and joining on userID will now filter out these events, but they are crutial to track aquisitions. You can fix this by doing a self-join of the fact table to work out the missing userID at query time ... but the performance is dysmal and you are essentially building a dynamic bridge table.

@elcoxeroni8273 Месяц назад

Thank you for this really great content! Which is the book you are referring to in your video? I like the structure much and am considering buying it. Thanks in advance!

@Aristocle Месяц назад

Is there a service or scripting language that allows me to write relationships between tables/databases in a modern material design style?

@alibachoy 2 месяца назад

what's the difference of a bridge table on a star scheme? Is bridging like 2 databases that have no relevance with one another like for example a PK(customer ID) on one table and just a reference transaction number PK on the other? The question is what makes bridging different from a star scheme/snowflake scheme?

@ansonnn_ 3 месяца назад

Need that Slowly Changing Dimension video please!

@SeattleDataGuy 3 месяца назад

Thanks for the reminder!

@richardduncan3403 5 месяцев назад

Bridge table looks like the Excel version of link workbooks... always ends in tears :)

@madbaumer215 5 месяцев назад

Good info. One related question that I cannot seem to get a straight answer to online - how do interviews work in terms of laying out your data model? I understand the interviewee talks through their thought process and that's the main point, but is it on pen and paper? A whiteboard? A lucid diagram? How do you actually display your tables and do they give you a prompt right then and there or ahead of time?

@poojasikdar3583 4 месяца назад

it depends - they would give you a problem statement and would ask you to design a data model around it- that can be on paper and you just have to walk them through your thought process or they would ask you to share your system and structure it on a notepad or that could be over a shared file.

@shilashm5691 4 месяца назад

@@poojasikdar3583i have hard time in understanding data model vs database model, can you explain it?

@niniolarotimi5639 4 месяца назад

Great content! Please what is the name of the book that was shown in the video?

@Curious_human_ 3 месяца назад

Yay even I need the name there are multiple books by Kimball

@davidshaked9209 5 месяцев назад

Do you recommend any books on data modelling for relational databases?

@davidshaked9209 5 месяцев назад

(Besides the text mentioned in the video)

@babuganesh2000 5 месяцев назад

Can you make a video about Databricks for Students who are interested to learn on how much it would cost for learning it using pay as you go and what all the techniques we can use to reduce the cost. There are many videos in youtube unless we do hands on nothing goes into head

@SnippetSensations 5 месяцев назад

can you make videos on these 2 topics 1. Day in the life of a Data Engineer (where you'll actually show your routine by also going in your company and stuff like that) 2. Your programming setup