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 М.
Heartwarming moment as priest rescues ceremony with kindness #shorts
00:33
Fabiosa Best Lifehacks
Рет қаралды 10 МЛН
When You Get Ran Over By A Car...
00:15
Jojo Sim
Рет қаралды 29 МЛН
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 151 МЛН
마시멜로우로 체감되는 요즘 물가
00:20
진영민yeongmin
Рет қаралды 28 МЛН
SCD - Slowly Changing Dimension in Data Warehouse
12:28
aroundBI
Рет қаралды 84 М.
Why Surrogate Keys are used in Data Warehouse
7:03
aroundBI
Рет қаралды 138 М.
Aggregate Awareness | What, Why & How
17:50
aroundBI
Рет қаралды 23 М.
7 Different Types of Dimensions in a Data Warehouse!
8:56
Abhilash Marichi
Рет қаралды 34 М.
Dimensional Modeling
53:54
Bryan Cafferky
Рет қаралды 165 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 744 М.
Metadata Management & Data Catalog (Data Architecture | Data Governance)
8:12
Software Architecture Academy
Рет қаралды 67 М.
What's a Junk Dimension and when should you use it?
4:27
Guy in a Cube
Рет қаралды 12 М.
Kimball Explained
10:10
Lorcan Neary
Рет қаралды 21 М.
Heartwarming moment as priest rescues ceremony with kindness #shorts
00:33
Fabiosa Best Lifehacks
Рет қаралды 10 МЛН