One of the most important topic for interviews. Well explanation
@letsdoit64382 жыл бұрын
Outstanding explanation sir , keeping short and simple
@sahillohiya7658 Жыл бұрын
great video! We need more videos like this and videos with more in-depth explanation :)
@AbhilashMarichi Жыл бұрын
More to come!
@GamingFan12 жыл бұрын
Thanks for the excellent practical examples. While everyone mentions the definitions only, you provided some real life examples.
@AbhilashMarichi2 жыл бұрын
I am happy that it was of some help! 👍🏻
@Eldo_thomasbaby Жыл бұрын
Yeah , this is unique video with more suitable example . Great job 👍
@meerahyfashaik1293 жыл бұрын
very precisely explained and straight to the point...excellent overview and simple examples...Thanks a lot :)
@AbhilashMarichi3 жыл бұрын
I am glad it helped! :)
@Anonymous-rg3tp2 жыл бұрын
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.
@AbhilashMarichi2 жыл бұрын
Thanks for the suggestion! I will plan to make separate videos.
@harshalunhale43695 ай бұрын
Precise explaination upto the point 😊
@sharadsatpute43 жыл бұрын
Best info with less words ...great one..👍can u add actual table examples of conformed,degenerated and junk please.
@AbhilashMarichi3 жыл бұрын
Thanks Sharad, I will try to make it.
@mohammadthousif74395 ай бұрын
Your explanations are super easy to understand! Why haven't you been coming up with videos lately??
@arslan_latif Жыл бұрын
concise n upto the point 🤘
@ashokbhum066 ай бұрын
Thank you very much
@rajnigoyal66532 жыл бұрын
great explanation
@5WsHealthyLifeStyle3 жыл бұрын
Easy to understand 👍
@AbhilashMarichi3 жыл бұрын
👍
@nagendravishnu45543 жыл бұрын
Explanation is good sir! Thank you
@AbhilashMarichi3 жыл бұрын
Glad it helped!
@s-sugoi8352 жыл бұрын
Thank you!
@toshvyas3 жыл бұрын
Nicely explained!
@AbhilashMarichi3 жыл бұрын
Thanks Tosh :)
@paulasouza66193 жыл бұрын
Great video!
@AbhilashMarichi3 жыл бұрын
I am glad you liked it 🙂
@mithunnambiar14332 жыл бұрын
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
@AbhilashMarichi2 жыл бұрын
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.
@mithunnambiar14332 жыл бұрын
@@AbhilashMarichi so, ideally a value upon which analytical or aggregation can be applied is only considered as a fact?
@AbhilashMarichi2 жыл бұрын
@@mithunnambiar1433 Most of the times yes.
@kanoranpariya5033 Жыл бұрын
Very good question asked.
@Prabhusparta3 жыл бұрын
Good one!
@AbhilashMarichi3 жыл бұрын
Thanks!
@kannekanti10 ай бұрын
Can you explain about the Informed Dimensions ?
@mayurak53053 жыл бұрын
Super bro
@AbhilashMarichi3 жыл бұрын
Thanks Mayur!
@sandeepchowdary63382 жыл бұрын
can you make one video practical like by showing power bi
@AbhilashMarichi2 жыл бұрын
I am not a BI developer but I keep this on my list!
@sandeepchowdary63382 жыл бұрын
Then how we will come to know
@crazycom98073 жыл бұрын
Is SCD type 1 and OLTP are of same kind?? Because we are storing current data only and not any history??
@AbhilashMarichi3 жыл бұрын
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.
@crazycom98073 жыл бұрын
@@AbhilashMarichi thanks for the quick response...I got the difference now
@sakshinaik053 жыл бұрын
what is rapidely changing dimension
@AbhilashMarichi3 жыл бұрын
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.
@girijeshkr12 жыл бұрын
great video, it really didn't need this disturbing music though..
@AbhilashMarichi2 жыл бұрын
Yeah! Sorry about that. I was still new to editing when I created this video. I am trying to improve the quality continuously.
@ytsmcsmcm2 жыл бұрын
good 1
@AbhilashMarichi2 жыл бұрын
:)
@kanchan4212 жыл бұрын
Abhilash are you conducting any classes
@AbhilashMarichi2 жыл бұрын
@@kanchan421 Nope.
@kanchan4212 жыл бұрын
@@AbhilashMarichi you must plan though... :)
@AbhilashMarichi2 жыл бұрын
@@kanchan421 🙂 will think of it!
@poojasikdar35835 ай бұрын
Card transaction number can be another example of a degenerate dimension.
@brandonbakhtiar74512 жыл бұрын
Would you consider answering specific questions for a paid rate of $? If so please reply so we can discuss further. Thank you
@AbhilashMarichi2 жыл бұрын
Nope! But if you have a question, let me know, I will try to answer it here. :)
@brandonbakhtiar74512 жыл бұрын
@@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.
@AbhilashMarichi2 жыл бұрын
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.
@rushikeshbhavsar15643 жыл бұрын
What is behavioral dimension??
@AbhilashMarichi3 жыл бұрын
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!
@rushikeshbhavsar15643 жыл бұрын
@@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"
@rushikeshbhavsar15643 жыл бұрын
I found that example lil bit confusing hence i asked you to simplify it for me.
@AbhilashMarichi3 жыл бұрын
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!
@JanUnitra2 жыл бұрын
music is terrible, but anyway great video
@AbhilashMarichi2 жыл бұрын
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” 🙂
@rickygrewal84 ай бұрын
Too much talk no diagrams to support. Rule #1 any visual cues are important when explaining technical concepts!!!
@AbhilashMarichi4 ай бұрын
Thanks for the feedback. I have started including them in my new videos.
@wendysimpson1211 Жыл бұрын
Gender is static 😂🤣
@houstonfirefox Жыл бұрын
Apparently "Gender" is no longer a static dimension 🤣
@AbhilashMarichi11 ай бұрын
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.