Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Star Schema Model Suggestions

Hi there.    I'm fairly new to modelling in PowerBI but have a large amount of experience in your typical normalised ER data modelling for RDBMS.    I have a table of data which shows outputs bet...
  • HotChilli's avatar
    HotChilli
    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.