Тёмный
No video :(

Types of Facts | Data Warehouse Concepts 

aroundBI
Подписаться 13 тыс.
Просмотров 79 тыс.
50% 1

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.

Опубликовано:

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@budmonk2819
@budmonk2819 3 года назад
Loved it, especially the quick summary at the end of each video.
@vishalmali1417
@vishalmali1417 2 года назад
Best explanation about types of fact I ever seen ... Nice video boss
@tejaswijagini
@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.
@surabhisrivastava1604
@surabhisrivastava1604 2 года назад
Understood very well..Thanks for sharing!!
@satyanadella6754
@satyanadella6754 5 лет назад
Excellent Fantastic Lecture. You Missed Factless Fact
@damansharma6737
@damansharma6737 3 года назад
Cuteee
@AnilJacobs
@AnilJacobs 5 лет назад
Good one especially for people Hands on with MBSI. Thanks!
@msmktester
@msmktester 4 года назад
Once again, liked it as I found it useful and simple
@abhishekmamidi8829
@abhishekmamidi8829 6 лет назад
You are awesome !! Thank you for the explaination.
@aroundBI
@aroundBI 6 лет назад
Thanks. A big motivation for continuing our effort.
@nimmaturipadma6942
@nimmaturipadma6942 Год назад
Great explanation
@akulabhavyachannel9799
@akulabhavyachannel9799 4 года назад
Great explanation sir thank you
@salonibhatia9438
@salonibhatia9438 3 года назад
Great video
@akhilsai8171
@akhilsai8171 2 года назад
very good explanation
@ajayfargade7985
@ajayfargade7985 2 года назад
Very Helpful
@AMARKEWAT
@AMARKEWAT 2 года назад
🔥
@pawanpillai
@pawanpillai 5 лет назад
Really helpful tutorials.. Thanks a lot for sharing your knowledge.
@indranisandur9644
@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
@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
@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
@discoveredwildworld932 2 года назад
yeah, total inventory at the end of 2 days should be 30.
@asmarehaklogh2188
@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.
@MyGodIsGreater35
@MyGodIsGreater35 7 лет назад
Very helpful. Thank you!
@ramaraoav5413
@ramaraoav5413 7 лет назад
Helpful video and good explanation
@salonibhatia9438
@salonibhatia9438 3 года назад
Well explained
@rohitdadhwal2709
@rohitdadhwal2709 6 лет назад
Nice Explanation Sir.... What about fact-less fact table?
@praveenpeddi8057
@praveenpeddi8057 6 лет назад
nice explanation with good examples.. keep going!!
@ShivamDhawan330
@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 ??
@discoveredwildworld932
@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)???
@MrIrrepressible
@MrIrrepressible 5 лет назад
Thank you for these video, they are a great help.
@lujainfahad8405
@lujainfahad8405 4 года назад
Thank you.
@ziedx5
@ziedx5 6 лет назад
Great explanation, thank you!
@Manisood001
@Manisood001 3 года назад
do you have a paid course on udemy?
@PK-nc5dt
@PK-nc5dt 4 года назад
Semi additive is not clear
Далее
Dimension Table Structure in Data warehouse
5:07
Просмотров 25 тыс.
SCD - Slowly Changing Dimension in Data Warehouse
12:28
Useful gadget for styling hair 💖🤩
00:20
Просмотров 2,1 млн
7 Different Types of Dimensions in a Data Warehouse!
8:56
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
Fact Tables and Types of fact tables
22:52
Просмотров 67 тыс.
FASTEST Way To Learn Coding and ACTUALLY Get A Job
10:44
12 Desk Setup Upgrades That ACTUALLY Matter
11:20
Просмотров 671 тыс.