One of the most important topic for interviews. Well explanation

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

@AbhilashMarichi

3 жыл бұрын

I am glad it helped! :)

Outstanding explanation sir , keeping short and simple

concise n upto the point 🤘

Explanation is good sir! Thank you

@AbhilashMarichi

3 жыл бұрын

Glad it helped!

Precise explaination upto the point 😊

great explanation

Thank you!

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

@AbhilashMarichi

Жыл бұрын

More to come!

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

@AbhilashMarichi

2 жыл бұрын

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

@Eldo_thomasbaby

Жыл бұрын

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

Thank you very much

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

2 жыл бұрын

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

Nicely explained!

@AbhilashMarichi

3 жыл бұрын

Thanks Tosh :)

Great video!

@AbhilashMarichi

3 жыл бұрын

I am glad you liked it 🙂

Easy to understand 👍

@AbhilashMarichi

3 жыл бұрын

👍

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

@AbhilashMarichi

3 жыл бұрын

Thanks Sharad, I will try to make it.

Good one!

@AbhilashMarichi

3 жыл бұрын

Thanks!

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

Super bro

@AbhilashMarichi

3 жыл бұрын

Thanks Mayur!

Can you explain about the Informed Dimensions ?

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

@AbhilashMarichi

3 жыл бұрын

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

3 жыл бұрын

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

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

2 жыл бұрын

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

2 жыл бұрын

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

@AbhilashMarichi

2 жыл бұрын

@@mithunnambiar1433 Most of the times yes.

@kanoranpariya5033

11 ай бұрын

Very good question asked.

what is rapidely changing dimension

@AbhilashMarichi

3 жыл бұрын

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.

can you make one video practical like by showing power bi

@AbhilashMarichi

2 жыл бұрын

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

@sandeepchowdary6338

2 жыл бұрын

Then how we will come to know

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

@AbhilashMarichi

2 жыл бұрын

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

@brandonbakhtiar7451

2 жыл бұрын

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

2 жыл бұрын

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.

good 1

@AbhilashMarichi

2 жыл бұрын

:)

@kanchan421

2 жыл бұрын

Abhilash are you conducting any classes

@AbhilashMarichi

2 жыл бұрын

@@kanchan421 Nope.

@kanchan421

2 жыл бұрын

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

@AbhilashMarichi

2 жыл бұрын

@@kanchan421 🙂 will think of it!

What is behavioral dimension??

@AbhilashMarichi

3 жыл бұрын

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

3 жыл бұрын

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

3 жыл бұрын

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

@AbhilashMarichi

3 жыл бұрын

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.

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

@AbhilashMarichi

2 жыл бұрын

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

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!

music is terrible, but anyway great video

@AbhilashMarichi

2 жыл бұрын

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

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

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” 🙂

Apparently "Gender" is no longer a static dimension 🤣

@AbhilashMarichi

10 ай бұрын

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.

Gender is static 😂🤣

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

@AbhilashMarichi

3 ай бұрын

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

Thank you!

@AbhilashMarichi

3 жыл бұрын

I am glad it helped you! 🙂