7 Different Types of Dimensions in a Data Warehouse!

Hello!
In this video, I give an overview of different kinds of Dimensional tables which are majorly used in a Data Warehouse.
Let me know if this video was informational for you in the comment.
For the stock footages and pictures, I would like to thank you all :
Ketut Subiyanto
Marcus Aurelius
Olya Kobruseva
CottonBro
Tim Mossholder

[@narendrakishore8526]

One of the most important topic for interviews. Well explanation

[@letsdoit6438]

Outstanding explanation sir , keeping short and simple

[@meerahyfashaik129]

very precisely explained and straight to the point...excellent overview and simple examples...Thanks a lot :)

[@AbhilashMarichi]

I am glad it helped! :)

[@arslan_latif]

concise n upto the point 🤘

[@nagendravishnu4554]

Explanation is good sir! Thank you

[@AbhilashMarichi]

Glad it helped!

[@rajnigoyal6653]

great explanation

[@toshvyas]

Nicely explained!

[@AbhilashMarichi]

Thanks Tosh :)

[@sahillohiya7658]

great video! We need more videos like this and videos with more in-depth explanation :)

[@AbhilashMarichi]

More to come!

[@s-sugoi835]

Thank you!

[@paulasouza6619]

Great video!

[@AbhilashMarichi]

I am glad you liked it 🙂

[@harshalunhale4369]

Precise explaination upto the point 😊

[@5WsHealthyLifeStyle]

Easy to understand 👍

[@AbhilashMarichi]

👍

[@GamingFan1]

Thanks for the excellent practical examples. While everyone mentions the definitions only, you provided some real life examples.

[@AbhilashMarichi]

I am happy that it was of some help! 👍🏻

[@Eldo_thomasbaby]

Yeah , this is unique video with more suitable example . Great job 👍

[@Anonymous-rg3tp]

Thanks for the awesome video! It would be great if you can create a detailed video with example of each type of dimension. This will help the people who are new to Data Modeling.

[@AbhilashMarichi]

Thanks for the suggestion! I will plan to make separate videos.

[@ashokbhum06]

Thank you very much

[@Prabhusparta]

Good one!

[@AbhilashMarichi]

Thanks!

[@sharadsatpute4]

Best info with less words ...great one..👍can u add actual table examples of conformed,degenerated and junk please.

[@AbhilashMarichi]

Thanks Sharad, I will try to make it.

[@mayurak5305]

Super bro

[@AbhilashMarichi]

Thanks Mayur!

[@mohammadthousif7439]

Your explanations are super easy to understand! Why haven't you been coming up with videos lately??

[@kannekanti]

Can you explain about the Informed Dimensions ?

[@mithunnambiar1433]

Hi Abhilash... 5:05, you mentioned 'invoice num' falls under dimensions not facts. That sounds confusing! invoice numbers are random and differs from transaction to transactions, an ideal fit for a fact table. How is it a dimension? Could you us get thru it

[@AbhilashMarichi]

Yeah! Invoice Number is not a measure. Sum or any aggregate function won’t make sense on invoice number but usually on a measure like sales amount, you can apply aggregations. So invoice number is a dimension, but it’s a degenerate dimension and we keep it in fact table usually as I mentioned in the video.

[@mithunnambiar1433]

@@AbhilashMarichi so, ideally a value upon which analytical or aggregation can be applied is only considered as a fact?

[@AbhilashMarichi]

@@mithunnambiar1433 Most of the times yes.

[@kanoranpariya5033]

Very good question asked.

[@sandeepchowdary6338]

can you make one video practical like by showing power bi

[@AbhilashMarichi]

I am not a BI developer but I keep this on my list!

[@sandeepchowdary6338]

Then how we will come to know

[@crazycom9807]

Is SCD type 1 and OLTP are of same kind?? Because we are storing current data only and not any history??

[@AbhilashMarichi]

Hey! We cannot say that because SCD Type 1 is a ‘dimension’, OLTP is a whole system design it can be in any level of normalization (Usually 3rd) and it is NOT restricted only to Dimensions.

[@crazycom9807]

@@AbhilashMarichi thanks for the quick response...I got the difference now

[@ytsmcsmcm]

good 1

[@AbhilashMarichi]

:)

[@kanchan421]

Abhilash are you conducting any classes

[@AbhilashMarichi]

@@kanchan421 Nope.

[@kanchan421]

@@AbhilashMarichi you must plan though... :)

[@AbhilashMarichi]

@@kanchan421 🙂 will think of it!

[@sakshinaik05]

what is rapidely changing dimension

[@AbhilashMarichi]

As the name says it is something that changes often. For example: Stock Prices, it varies every second. So usually in DataWarehouse this is avoided.

[@brandonbakhtiar7451]

Would you consider answering specific questions for a paid rate of $? If so please reply so we can discuss further. Thank you

[@AbhilashMarichi]

Nope! But if you have a question, let me know, I will try to answer it here. :)

[@brandonbakhtiar7451]

@@AbhilashMarichi Thank you I'll try to be short. I wish to send customers a QR code as a receipt for a pack of minutes of time of a service (assisted stretch) with the goal of the QR code being able to record or refer to a data mart or small data warhouse where a updated balance can be maintained. For example, we offer 3 products. A pack 100 minutes, 200 minutes and 300 minutes. If a customer purchases a 100 minute pack, the QR code they are emailed as part of a receipt would then contain or record or refer to a record of their balance of 100 minutes. If they meet us to use the service, we wish to track the use of their minutes by scanning the QR code. A 1st scan would log the start of the service & a 2nd would mark the end, so if they had 100 minutes, and a1st scan of the QR code was done at 1pm and a 2nd at 130pm, 30 minutes of the service was used up, 30 would be deducted from the balance of 100 and the new balance of 70 minutes of service time remaining on their QR code invoice would remain. I wish to better understand options for how to organize this. Could times of a QR code scan be stored on one dimension table, the product (100, 200 or 300) on another, the customer info (address on another) and the credit card be the non volatile fact table at the center of a star schema? Or given the above can I get guidance on a general overview of how to organize the backend to store this info and reliably use QR codes this way? My question was longer to explain than I hoped but I hope I was clear. Thank you. Happy to share more information if you like.

[@AbhilashMarichi]

You should look at building an OLTP system and NOT a data warehouse at this point for making your application to function optimally. I say this because, your writes to the database needs to be faster. Functionally separate the data into multiple tables and store it in 3rd Normal Form as much as possible. Once you have an operating OLTP then we can think of building a Data Warehouse.

[@girijeshkr1]

great video, it really didn't need this disturbing music though..

[@AbhilashMarichi]

Yeah! Sorry about that. I was still new to editing when I created this video. I am trying to improve the quality continuously.

[@rushikeshbhavsar1564]

What is behavioral dimension??

[@AbhilashMarichi]

Hey Rushikesh! I believe that is something related to Psychology! 😊 I am not sure if it’s related to Data Warehousing! Let me know if you find something related to DW!

[@rushikeshbhavsar1564]

@@AbhilashMarichi NO its not i was reading this book by Christopher named star schema where he have mention this 👉👉👉👉👉👉👉👉👉 " A very powerful analytic technique uses behavior patterns to analyze facts. Consider this question: “Are customers who generate over $1 million in sales receiving better discounts than those who generate $500,000 or less?” Orders are tracked by a fact. To answer this question, we must group the customers based on their past order activity. The groupings are then used as a dimension, and they are used to study discount A dimension that is computed based on facts is called a behavioral dimension"

[@rushikeshbhavsar1564]

I found that example lil bit confusing hence i asked you to simplify it for me.

[@AbhilashMarichi]

Thanks for sharing it! Let me check that out. I have never used it. I will go through it and make a video about it. Appreciate for sharing the info.

[@satyambhardwaj4631]

Bro why didn't you use some metal song with max volume, so that I can hear u properly

[@AbhilashMarichi]

Ha ha! Next time 😆 I did get the feedback and in my recent videos, I have ensured to have the low music volume or no music at all. Thanks!

[@poojasikdar3583]

Card transaction number can be another example of a degenerate dimension.

[@JanUnitra]

music is terrible, but anyway great video

[@AbhilashMarichi]

Ah I know, I will take care of it in the future videos! 🙂Thank you 🙂

[@youssef-attai]

7:08 "There are set of genders, but it's not going to grow over a period of time." Well, you see..

[@AbhilashMarichi]

Let’s amend it and say “Gender at birth” 🙂

[@houstonfirefox]

Apparently "Gender" is no longer a static dimension 🤣

[@AbhilashMarichi]

Though we have 19 different Genders now. I would still say it is static from Dimensional modeling perspective and it allows the association between Person Dimension and Gender Dimension to change as needed.

[@wendysimpson1211]

Gender is static 😂🤣

[@rickygrewal8]

Too much talk no diagrams to support. Rule #1 any visual cues are important when explaining technical concepts!!!

[@AbhilashMarichi]

Thanks for the feedback. I have started including them in my new videos.

[@arsalsohail298]

Thank you!

[@AbhilashMarichi]

I am glad it helped you! 🙂