How to think and structure data with different intervalls / quality aspects of the products

[langbergs]

Hi!

Im setting up a enviroment where our sales is exported from our systems once a week and have built a few reports based on that. We have about 50 sites across our country. Now im intressted in to be able to add different quality aspects from customer surveys everey half year, quality reports every year, economic data every month and so on.

I think i still whant to have the weekly sales to be my date/calender key where i shoice a week and get that weeks sales, (changes to averages/last week and so on) but allso the latest data from the customer survey or the latest economic data based on the selected week.

Iwe looked on a lot of youtube videos and searched for guides on how to reason and think about this but cant find it.. Does anyone have an idea of how to do this or have read/seen anything like this where i can inspire from? 

Kind regards

Andreas

[v-yulgu-msft · Accepted solution]

Hi @langbergs,

From current description, your requirement is so general. Please refer to this blog to provide more detailed information so that we can give you more advice.

Regards,

Yuliana Gu