FBE Line view

FBE Line view is a report that on its surface isn't anything new - it's a segment chart showing where the inventory is for one portion of the factory.  It has several different views and slicers as well as some preset filter buttons that will show the things that factory managers and other groups are interested in. 

Apart from the wealth of data within the report itself the most innovative feature of FBE line view is the pre-processing and grouping of the data that happens beforehand.  

While any given lot will only go through at most 30 or 40 distinct operations in this portion of the factory, the increasing number of technology nodes and flows means that there are actually thousands of distinct operations captured in this view.  Previously someone would have to manually sort all of those operations to put them in order, and then we would view the inventory for each of them individually.  FBE line view pulls historical data about the lots and operations in the factory and runs them through an algorithm to place each operation into a bucket of other similar operations having to do with the toolset as well as how close to the end of the factory segment it is.  

The configs are calculated and pushed to a database less frequently - then the Power BI report can pull those configs and match them to live factory data to generate the views above.

The algorithm pulls data using SQL and runs calculations in Python.

Users can also drill into specific items to see details on the WIP or the toolset where it resides.  The interface of the report is made in Power BI.

The below screen captures have been edited as to not reveal any sensitive information - which unfortunately makes the report difficult to read.