Let's Compare the Kimball and Inmon Data Warehouse Architectures

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

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

50% 1

Let's look at the Kimball and Inmon approaches to data warehouses. Which should you chose for your solution? What are the advantages and disadvantages and which will benefit your organization most?
⏯RELATED VIDEOS⏯
Data Vault vs Traditional Data Warehouse: • Data Vault vs Traditio...
------------------------------------------------------------------------------
Data Podcast ►► open.spotify.com/show/4PWmW2g...
Website ►► www.nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: click.linksynergy.com/deeplin...
DE Essentials, hands on: click.linksynergy.com/deeplin...
------------------------------------------------------------------------------
📷VIDEO GEAR📷
Programming Mouse: amzn.to/3zEom7f
Lighting: amzn.to/3o8tXAM
RGB light: amzn.to/3o8AQBS
USB Microphone: amzn.to/3m3hjAt
Mixer: amzn.to/2ZyqMIk
XLR Microphone: amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: 1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact nullQueries@gmail.com
Some of the links in this description are affiliate links and support the channel. Thanks for the support!

Наука

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

18 янв 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@nullQueries 2 года назад

For a Data Vault alternative: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Tff34jj_V-0.html

@vincentiustimothy9344 2 года назад

I think you meant this link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D914nNWGP6E.html

@hdebbache2000 3 года назад

Clear and pleasing, please keep it up you will get a lot of subscribers with content like that

@prod-school 3 года назад

Amazing to get started. Please make sure you post an update of this one with the latest of inmon modelling as it has changed a lot recently. But pretty clean videos. Amazing work mate

@nullQueries 3 года назад

Thanks! I wanted to start with the traditional methods and do a future video on data vaults and other modern designs. Every video spawns a dozen of ideas for new videos I can hopefully get to

@wordonparliamentstreet6076 2 года назад

Brilliant video. Makes a refreshing change to watch something which isn't so bogged down in the jargon.

@nullQueries 2 года назад

Thanks! It's hard when there's so much jargon with data warehousing

@thedatawaiter1026 Год назад

Really really really wonderful!

@alansilva3826 3 года назад

Amazing video!

@nazimbandoui Год назад

Amazing content !

@farhan789 3 года назад

100 thumbs up. best explanation.

@jesflo4 3 года назад

Great video!

@letsplay8009 2 года назад

Good stuff.. Really helpful

@lcwl100 Год назад

Excelent explanation. Thank you for the great content, but can be hard to undertand since subtitles are only available in vietnamese. Please consider addind subtitles in english for those with hearing impairments.

@pranavagashe 3 года назад

In Inmon approach, aren’t the data marts supposed to be dimensional and de-normalized? Hence, better suited for good query performance?

@KahanDataSolutions 3 года назад

Nice job!

@top_1_percent Год назад

Thank you, legend

@wojpaw5362 2 года назад

Great content thanks!

@nullQueries 2 года назад

Glad you liked it!

@nits_koh 8 месяцев назад

cool video . what software did you use to create the video/animations?

@arthursimeon2620 9 месяцев назад

Any chance you could enable English auto-generated subtitles on this? For some reason it only has Vietnamese available

@00EagleEye00 3 года назад

Good day sir. I would like to ask on how to include a dimension on a hierarchical design (recursion) to a fact? Kindly set an example and provide explanation if possible. Thank you.

@AlbertoSimeoni-wi9wj 6 месяцев назад

Integrated tools in dwh like the ones from SAP can do that. Otherwise you need to flatten the hierarchy into a dimension table then add a column with the level of the node. And put the level as prompt in the report or define different attribute based on the level. There is basically no way to have the full relations without tricks or integrated procedure/tool to manage recursive hierarchies.

@spreadsheetsplays871 Год назад

Can't tell you how many jobs I've had where they list on the job description that must know Kimball 3rd Normal Form.

@ahmednaqvi3568 Год назад

Which software did you use to make this video? If not a secret

@ch012 3 года назад

Why would denormalized data create duplication across data marts is not clear...data marts are created based on business domain of specific groups of the orgrnization...you may design these marts with whatever level of duplication/isolation you want to have across these marts...In fact the deformalized form of data by nature of design itself will have duplication in data...

@allisoneduardo2404 2 года назад

Excelente explanation. I trying to produce some vídeos like that but I l've no ideia how to do animations like that, can you give me a direction please ?

@GDveertje 2 года назад

Literally past explanation I’ve seen.

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

You are contradicting yourself. Inmon's model has a datamarts layer with denormalized and ready to consume data, so how should that slow down reporting queries?

@user-zv9um9pb6w 3 года назад

Fyi this is wrong you are describing classic inmon. More recently like 10 -13 years ago he changed to what is identical to the data vault

@RoflcopterV22 3 года назад

Classic Inmon is the only Inmon, data vaults were not a concept created by Inmon, but rather something that he agreed was better for enterprise data warehousing than his concept. You can't credit Inmon with Dan Linstedt's data vault modeling method.

@fanyang7459 3 года назад

@@RoflcopterV22 Agreed, Inmon's concept is really old. But Kimball will bring more troubles to the enterprise warehouse. Data vault similar like Inmon's concept but much more complex that both.

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

Querying a data vault for analytical/report style queries is terrible. 5 or 6 or more tables to join to get one thing?! Whereas with a fact table that’s pre aggregated based on some granularity the query could be as simple as a single select