Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am currently making a star schema as pictured below:
I want to add a level of detail to each of the dimension tables, which will be a one : many from the detail table to the dimension table. I understand I can merge these detail and dimension tables in power query, but this will result in a larger dataset than just using relationships.
The new schema below looks like this:
Is this against best practice? It functions as expected but wanted to check before taking the report forward further!
Thanks,
Leo
Solved! Go to Solution.
With the mods you now have a snowflake schema structure, which generally is ok (depending as always on the depth/size of the dataset). You can keep a star schema structure (which appears to be the favoured structure in guru land) and still filter other dimensions using measures in the filter pane.
Proud to be a Super User!
Paul on Linkedin.
With the mods you now have a snowflake schema structure, which generally is ok (depending as always on the depth/size of the dataset). You can keep a star schema structure (which appears to be the favoured structure in guru land) and still filter other dimensions using measures in the filter pane.
Proud to be a Super User!
Paul on Linkedin.
@amitchandak I would do that, but I have to pivot the detailed tables - which when merged go from 1000 rows to 200,000+ !
Is this type of report flawed, or acceptable under these circumstances?
@LeoDavies , As long Details Dim and Dim is 1-M they should/can be merged. For Week you have check why not join date with Fact. and merge week and date
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |