Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have the following data sources:
Market share actual
Market share targets
Cost actual
Cost target
Sales actual
Sales target
Those will be used to measure various metrics, and will be linked with dimensional tables such as personal (eg. Sales rep), geographical (eg. District) and product (eg. Serial number).
Should I put everything together in one big table, or is there a way to handle this following a star-shaped schema ?
Thanks,
Solved! Go to Solution.
The data model/schema depends on your specific senario. I would suggest you refer to the tutorial below:
https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The data model/schema depends on your specific senario. I would suggest you refer to the tutorial below:
https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You need to make a decision depending on the structure and most importantly on the granularity of this fact tables if the granularity of one or more tables are different, and you want to preserve it for reporting of some numbers on that specific level, then you will need to keep it separate and use dimensions as filters, if however, they all are the same granularity then you can merge, but it will all depend on your model and what you want to achieve.
This video course will give you a good idea of how to create your data model.
https://www.sqlbi.com/training/data-modeling/
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |