Manufacturing Cycle Times

[JaredMay]

I am modeling manufacturing KPI data (productivity, etc).  Some of the measures will be based on the machine output per minute.  I have an excel table that has a column for machine name, part number, and the output per minute.  The output per minute may chance depending on process improvements.  How can I model this in PowerBi?  I would want my historical data to use the previous output per minute. 

[ALLUREAN]

Hi, @JaredMay 

Following best practice you can have one fact table with all records of the machine activity by date. Then you can create dimension tables for Machine name, Part number, Date. If you want to track the machine output speed change, somewhere this has to be defined, e.g. in a separate column in order to track why the output is increased or decreased based on process improvement or simply by date.

It is difficult to say in detail since I don't have a look into the data structure and what exactly will be the business logic.