Let's Compare the Kimball and Inmon Data Warehouse Architectures

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.c...
Website ►► www.nullquerie...
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: click.linksyne...
DE Essentials, hands on: click.linksyne...
------------------------------------------------------------------------------
📷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.marke...
------------------------------------------------------------------------------
For business inquiries please contact [e-mail]
Some of the links in this description are affiliate links and support the channel. Thanks for the support!

[@nullQueries]

For a Data Vault alternative: th-cam.com/video/Tff34jj_V-0/w-d-xo.html

[@vincentiustimothy9344]

I think you meant this link th-cam.com/video/D914nNWGP6E/w-d-xo.html

[@prod-school]

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]

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

[@arthursimeon2620]

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

[@pranavagashe]

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

[@Techie-time]

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...

[@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.

[@wordonparliamentstreet6076]

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

[@nullQueries]

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

[@kvbd2710]

Thank you for such a wonderful video. For some reason, the subtitles for this video got messed up, I am unable to get it in English. It is defaulting to Vietnamese. Please help.

[@ahmednaqvi3568]

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

[@nits_koh]

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

[@top_1_percent]

Thank you, legend

[@hdebbache2000]

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

[@thghtfl]

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?

[@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.

[@allisoneduardo2404]

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 ?

[@farhan789]

100 thumbs up. best explanation.

[@GDveertje]

Literally past explanation I’ve seen.

[@letsplay8009]

Good stuff.. Really helpful

[@KahanDataSolutions]

Nice job!

[@thedatawaiter1026]

Really really really wonderful!

[@00EagleEye00]

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]

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.

[@nazimbandoui]

Amazing content !

[@alansilva3826]

Amazing video!

[@jesflo4]

Great video!

[@wojpaw5362]

Great content thanks!

[@nullQueries]

Glad you liked it!

[@user-zv9um9pb6w]

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]

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]

@@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]

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