BI schema design problem

[Syndicate_Admin]

Hello everyone

I am writing to you because I am starting in this and I have a series of recurring problems, I am trying to optimize the data flows and automate as much as possible the existing.

I pose my problem to see if they can help me or guide me on how to solve it.

I manage 4 small workshops, which daily report the final stock, are 6 different products and these products can have 6 different states.

I would like to be able to relate each of the workshops with their daily production and with the state of each of them.

The idea is that each of the workshops fills out this table daily and that later the stocks of all the different products of the different workshops are related to me.

What kind of scheme should I use? What fields should I relate? , I have tried with format and date, but it is not working as I think it should.

Thank you very much in advance to tod@s!

[v-henryk-mstf · Accepted solution]

Hi @Syndicate_Admin ,

According to your description, you need the date sheet, the shop corresponding to the work record sheet. Then try the star architecture to build the corresponding model. For details, you can refer to several model examples provided by the official.

Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

Tutorial: Explore a Power BI sample - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.