What is Dimensional Modeling

Description -
Dimensional modeling is set of guidelines to design database table structure for easier and faster data retrieval. It is widely accepted technique. Big benefits of using dimensional modeling is its simplicity and faster query performance.
In this tutorial, we will talk about Dimensional modeling in Data Warehouse and will see how it is different from ER modeling. We will understand the concept and then we will look into process to design dimensional models.
Subscribe - / @aroundbi
About AroundBI : We are trying to create an educational platform with an aim to provide tutorials in a very simple and understandable way.

[@jayashreewani6237]

The first tutorial so far on DW concepts I have com across which is so clear and precise to the point. Thanks a lot !!!

[@shirshendudebroy2097]

Hi, from your playlist it's not clear from which video one should start. So, please mark it with a number. It will be really helpful.

[@aroundBI]

Yes, tutorial should be in correct order for better usability. Thanks very much for suggestion.

[@satishb9975]

Thank you sir you made such a difficult topic so easy to understand 🙏 your efforts are so valuable to new people and who don't have experience in database with this kind of tutorials anybody can who can learn and become best 😀 pls share post more videos thank you for all the efforts 🙂 🙏

[@MrIrrepressible]

Thanks for the videos, you are a good teacher, regards from UK.

[@badal8435]

Best tutorial on youtube regarding, datawarehousing ,thanks sir

[@ADNANAHMED-eo5xx]

bro you are too good, u should make a complete course of data warehouse

[@adilshaik7554]

excellent explansiion sir

[@samratkorupolu]

Good content, thanks from USA

[@siddhijadhav5071]

Good explanation. Please complete this course

[@subrahmanyaaws5974]

Nice Explanation.Good.Provide Informatica Related videos.It is very useful

[@elegantswordop3265]

Great video, understand everything

[@mansoor8228]

Nicely explained

[@badoiuecristian]

good job to summarise the concepts :)

[@keerthichandran6894]

The concept is clear. Thank you

[@arpitjain4031]

Good explanation on Dimension modeling

[@anjaneyulukatta4654]

Excellent brother.Short video more content which will save time and allow to grasp the more subject

[@sudhirreddi]

Awesome explanation. Thanks.

[@marcelo157films]

Excellent Tutorial! Thank you for share with us!

[@vysakhkailas940]

Thank you for the video.

[@poulameepal8065]

Very nicely explained!

[@jvrraghu]

Very nice and easily understandable video. Thanks a lot..

[@shrikantsalunke948]

Very well explained

[@awakened514]

Very helpful diagram at 6:18

[@OA-lx2zr]

awesome awesome

[@azyvideos]

thanks

[@technotv3227]

great work !

[@jojappakoyyuru8301]

excellent

[@aconejos]

SCD is not a thing any more... Taking snapshot is currently recommended.. Very nice videos

[@vmurthy9307]

really excellent videos from you. i want learn about snow flake and star schema . please provide these videos

[@daphne_moo]

Is dimensional modeling a kind of data modeling which mentioned in CRISP-DM Stage 4 Data Modeling?

[@madhuparnachatterjee1678]

Well explained. Also i would like to know if any tutorial video on star schema and snowflake schema?

[@yifan4178]

Dimension models store data in a denormalized way?? I thought it's normalized

[@wengmoreno6675]

Wow

[@amralkhatib5031]

perfect

[@rahelhariaty8874]

May I know the books you use as references?

[@STEAVEJOBS-kb3dx]

Do more videos ..

[@michalroesler]

What is ER modelling? I mean what does ER stand for?

[@mukeshnuvvula9782]

Entity Relationship model, Which is nothing but a Normal Form Model explained in the video and it is used for OLTP

[@AnilJacobs]

Very nice, thank you!

[@AshishSahu-zr4sk]

Sir please littile slower

[@geniusoff2]

Great English bro! ;)

[@sivakumaranbazhagan1672]

Ok

[@adibakhann_]

can you please go a little slow?

[@srin9867]

you can set the playback speed at 0.75 in Settings - That may help you

[@Djursnerable]

Oh shit that's a heavy Indian accent.

[@reryaa]

It hurts my ears