Types of Facts | Data Warehouse Concepts

No video

Types of Facts | Data Warehouse Concepts

Рет қаралды 79,097

7 жыл бұрын

In this tutorial, we will walk through different types of fact. The nature of aggregation of facts for dimensions divides Facts into 3 groups that we can call 3 different fact types:
1. if fact can be summed up for all dimensions in then it is called Additive Fact.
2. if it can be summed up for some dimensions in table but not all then it is semi-additive fact and
3. if it cannot be summed up for any of the dimensions present in the table then it is non-additive fact.

Пікірлер: 34

@budmonk2819 3 жыл бұрын

Loved it, especially the quick summary at the end of each video.

@vishalmali1417 2 жыл бұрын

Best explanation about types of fact I ever seen ... Nice video boss

@surabhisrivastava1604 2 жыл бұрын

Understood very well..Thanks for sharing!!

@AnilJacobs 5 жыл бұрын

Good one especially for people Hands on with MBSI. Thanks!

@pawanpillai 5 жыл бұрын

Really helpful tutorials.. Thanks a lot for sharing your knowledge.

@tejaswijagini 4 жыл бұрын

Hello Great explanation. I have a question about Transaction ID, could you please explain? Is transaction id a dimension or fact? If it is a fact, is it under non-additive facts? I think it falls under dimension because it doesn't provide any value to measure. thank you.

@msmktester 4 жыл бұрын

Once again, liked it as I found it useful and simple

@abhishekmamidi8829 6 жыл бұрын

You are awesome !! Thank you for the explaination.

@aroundBI 6 жыл бұрын

Thanks. A big motivation for continuing our effort.

@akhilsai8171 2 жыл бұрын

very good explanation

@praveenpeddi8057 6 жыл бұрын

nice explanation with good examples.. keep going!!

@akulabhavyachannel9799 4 жыл бұрын

Great explanation sir thank you

@nimmaturipadma6942 Жыл бұрын

Great explanation

@salonibhatia9438 3 жыл бұрын

Great video

@ajayfargade7985 2 жыл бұрын

Very Helpful

@AMARKEWAT 2 жыл бұрын

🔥

@satyanadella6754 5 жыл бұрын

Excellent Fantastic Lecture. You Missed Factless Fact

@damansharma6737 3 жыл бұрын

Cuteee

@salonibhatia9438 3 жыл бұрын

Well explained

@asmarehaklogh2188 3 жыл бұрын

This man has good tutorial. The problem is fast speak with accent hard to understand. At some point, I repeat two three times still I could not get what he said.

@rohitdadhwal2709 6 жыл бұрын

Nice Explanation Sir.... What about fact-less fact table?

@MrIrrepressible 5 жыл бұрын

Thank you for these video, they are a great help.

@indranisandur9644 6 жыл бұрын

I think quantity in hand cannot be semi-additive since it cannot be summed up across just products or stores as per the table in the video . AT 3:50 its mentioned that total inventory at the end of 2 days i.e 5th march and 6th march would be 50+30=80 but I think that should be 30. on 5th march ,store had 50 and on 6th march, 20 sold out and 30 are remaining. So the store never had 80 products. Please correct me If my understanding is wrong :).

@aroundBI 6 жыл бұрын

Very good question. You are right. It does not make sense to add quantity in hand for a product. But for date, adding up that measure gives an average of inventory. (Sum of quantity in hand)/Days In this example, 5(0+30)/2 = 40 per day. Since quantity in hand is additive across some dimensions but not all, we can call it as semi-additive fact.

@PK-nc5dt 4 жыл бұрын

@@aroundBI Why it does not make sense to add quantity in hand for a product. It is always makes sense to know what is the quantity of product in hand to meet the customer demands. Is not it?

@discoveredwildworld932 2 жыл бұрын

yeah, total inventory at the end of 2 days should be 30.

@MyGodIsGreater35 7 жыл бұрын

Very helpful. Thank you!

@ramaraoav5413 7 жыл бұрын

Helpful video and good explanation

@discoveredwildworld932 2 жыл бұрын

if in the next day 20 quantity was sold from remaining quantity in hand (i.e, 50) then the current remaining quality is 30 so how come total inventory at the end of 2 days should be sum of two(80)???

@ShivamDhawan330 2 жыл бұрын

What if we take average of sales tax.. since it will be same across any dimension.. ex. Average sales tax for Miami - 5+5+5+5+5/5 = 5.. so will this make sales tax as semi additive if we consider for this example ??