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 courses (Not Produced by nullQueries)🎓

------------------------------------------------------------------------------

📷VIDEO GEAR📷

💻VIDEO SOFTWARE💻

------------------------------------------------------------------------------

Some of the links in this description are affiliate links and support the channel. Thanks for the support!

[hdebbache]

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

[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

[wordonparliamentstreet]

Brilliant video.

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

[lcwl]

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]

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

[arthursimeon]

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

[nits_koh]

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

[spreadsheetsplays]

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

[EagleEye]

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.

[Techie-in-Cloud]

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

[ahmednaqvi]

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

[allisoneduardo]

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 ?

[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?

[zvumpbw]

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