Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Let's imagine we have fact tables with 100k sales. There is 20k of dictinct customers and they could buy stuff with delivery to home or without.
Should I create a dim table where I would put an information with my customers and type of delivery?
Or maybe that info should stay in fact table because of the high caridnality?
Thank you in adnvance!
Normally I would advise you to create a dim table, so that you do not repeat customer information unnecessarily in a fact table. Due to the high cardinality, it is now difficult to estimate whether it will actually have a positive result (or maybe even a negative one). That's why I advise you to install DAX Studio. This is a free tool that gives you insight into information related to your data model. See how your data model looks now, and how it looks after you've created a dim table, via the Vertipaq Analyzer option (link showing you more info about this: https://www.fourmoo.com/2020/11/11/how-to-use-vertipaq-analyzer-with-dax-studio-for-power-bi-model-a.... This allows you to clearly see what the effect is, and depending on that you can actually implement it or not. Download DAX Studio from this link: https://daxstudio.org/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |