Data modelling

[Kieran-q_20]

Hi All,

Just wondering what you found to be best practice when creating a PowerBI dashboard from hard coded excel files. 

In short I have to create a new dashboard with work, but the data i have to use is a hard coded table which is updated weekly by simply inserting a new column every week. Is there a way to condese this into a better format? I have attatched a mock up example of the data below with some fake figures.

Any help at all is very much appreciated, thank you. 

[Idrissshatila]

Hello @Kieran-q_20 ,

the best practice is to build the Power BI Model as a star schema,

check it out here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin