BI schema design problem

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!