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
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
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.
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.
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...
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.
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.
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?
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 ?
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.
@@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.
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
For a Data Vault alternative: ua-cam.com/video/Tff34jj_V-0/v-deo.html
I think you meant this link ua-cam.com/video/D914nNWGP6E/v-deo.html
Brilliant video.
Makes a refreshing change to watch something which isn't so bogged down in the jargon.
Thanks! It's hard when there's so much jargon with data warehousing
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
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
Clear and pleasing, please keep it up you will get a lot of subscribers with content like that
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.
In Inmon approach, aren’t the data marts supposed to be dimensional and de-normalized? Hence, better suited for good query performance?
Any chance you could enable English auto-generated subtitles on this? For some reason it only has Vietnamese available
cool video . what software did you use to create the video/animations?
Which software you are using to edit videos
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.
Which software did you use to make this video? If not a secret
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...
Thank you, legend
Can't tell you how many jobs I've had where they list on the job description that must know Kimball 3rd Normal Form.
100 thumbs up. best explanation.
Really really really wonderful!
Amazing content !
Good stuff.. Really helpful
Nice job!
Amazing video!
Great video!
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.
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.
Great content thanks!
Glad you liked it!
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?
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 ?
Literally past explanation I’ve seen.
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
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.
@@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.
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