Forum Discussion
Should I create a dim table?
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!
1 Reply
Anonymous
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-analysis/). 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/
