Forum Discussion
Star Schema Model Suggestions
- 5 years ago
I don't think you should worry about it too much. As long as you know how to deal with repeated values, it'll be ok. Just don't SUM them, there are plenty of aggregate functions in DAX to return what you want in any visualisation.
Also, unless file size and performance is critical, I wouldn't use surrogate keys for the country. It makes it easier when inspecting the data in Data View. You'll still want a country dimension (or two, import and export).
There are design theories in data warehousing that deal with this stuff, however powerbi can cope with lots of different designs. So I say keep it simple - you can always redesign if required.
Anonymous
What is the structure of the source tables?
I posted a reply before Paul but it just randomly disappeared.
It's just a flat table like in the image, but I guess thats probably not the best way to show it.
I can't post the table here, but here's a link to the data in a google document.
Thanks very much.
DM