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.
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?
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.