What is Grain in Data warehouse

  Рет қаралды 46,676

aroundBI

aroundBI

6 жыл бұрын

Welcome to aroundbi.
Let’s understand what is grain in data warehouse and before designing warehouse schema, why it is important to correctly determine grain for dimensions and facts.

Пікірлер: 23
@rickmemmer5625
@rickmemmer5625 6 жыл бұрын
"crisp & clear" is perfectly put for all your videos. What you manage to pull off in a matter of minutes is just astonishing! Thank you!!
@Lego-tech
@Lego-tech 4 жыл бұрын
very crisp and point to point explanation. Its really helpful to take a quick tour around basic concepts. Nice work done!!
@shashikanthpai2034
@shashikanthpai2034 6 жыл бұрын
Ur content is crisp & clear
@venkatasurendra9037
@venkatasurendra9037 5 жыл бұрын
Nice explanation. Short & sweet
@rajarajeswari8614
@rajarajeswari8614 4 жыл бұрын
Your videos are to the point and are easy to understand. Try to put more vidoes about new technologies.
@vivekgaikwad5012
@vivekgaikwad5012 6 жыл бұрын
Good explanation
@haripalthakur2996
@haripalthakur2996 3 жыл бұрын
Hi, thanks for your series really enjoyed! How can we join multiple Fact Tables at different level of granularity?
@naimmulla1506
@naimmulla1506 Жыл бұрын
great video !
@srinivassiva3325
@srinivassiva3325 6 жыл бұрын
can you please uploaded the interview based questions and answers around bo
@MrAhmadAdli
@MrAhmadAdli 6 жыл бұрын
Thanks I enjoyed watching your video, again "Crisp & Clear", do you have anything about CRISP-DM
@sujusuresh
@sujusuresh Жыл бұрын
nice video!
@shahabkhan4896
@shahabkhan4896 4 жыл бұрын
I want to create Retail Business related Data-warehouse but unable to understand how should start to make model. Please suggest steps.
@asfandyarahmad7109
@asfandyarahmad7109 2 жыл бұрын
nice❤
@sankarmeganth
@sankarmeganth 3 жыл бұрын
Your content is good but one suggestion is , u can explain bit slowly
@shubhanshusahuu
@shubhanshusahuu 5 жыл бұрын
Good tutorial I got the point
@imsujitpaul
@imsujitpaul 2 жыл бұрын
Thank for the video. I have two questions, is it possible to design a fact table with multi level grain? And if it is possible to design a fact table without any grain?
@sandeeppai25
@sandeeppai25 2 жыл бұрын
No. There should be grain defined before creating any fact. If not defined properly, it will result in inconsistencies
@jayanthibhavani1764
@jayanthibhavani1764 6 жыл бұрын
Good content all I want to say is please speak little slow so that your sentences are much clear. I had to go back and forth in the video multiple times to understand the whole statement.
@rainonmyface
@rainonmyface 4 жыл бұрын
If you change to .75 speed, it is a little easier to keep up with.
@garyhuang11
@garyhuang11 4 жыл бұрын
deter mine, lol
@flexer7822
@flexer7822 2 жыл бұрын
i don't understand your pronuntation at all
@Sam-gn6og
@Sam-gn6og 3 жыл бұрын
can you please upload the video in english
@blaiseashun111
@blaiseashun111 Жыл бұрын
your accent is difficult to comprehend. sorry
What is Dimensional Modeling
7:21
aroundBI
Рет қаралды 119 М.
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37
Мы никогда не были так напуганы!
00:15
Аришнев
Рет қаралды 6 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 38 МЛН
Fact Tables and Types of fact tables
22:52
Tech Coach
Рет қаралды 66 М.
Why do we need Junk Dimension | Data Warehouse Concepts
6:15
SCD - Slowly Changing Dimension in Data Warehouse
12:28
aroundBI
Рет қаралды 84 М.
7 Different Types of Dimensions in a Data Warehouse!
8:56
Abhilash Marichi
Рет қаралды 34 М.
Building an Enterprise Data Warehouse
21:20
James Oliver
Рет қаралды 28 М.
Dimension & Fact Tables
31:17
Kamala - MSTR Videos D
Рет қаралды 41 М.
Why Surrogate Keys are used in Data Warehouse
7:03
aroundBI
Рет қаралды 138 М.
Dimensional Modeling
53:54
Bryan Cafferky
Рет қаралды 165 М.
Types of Facts | Data Warehouse Concepts
5:43
aroundBI
Рет қаралды 78 М.
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37