Global Automotive Supplier

Manufacturing plant 700 employees

​

​

​

​

​

data cleansing

data modeling

data analysis

visualizations

​

​

The machine data records only contain one time stamp and a high rate of incorrect entries.

​

​

​

​

Excel

Power Query

Power BI Direct Query

​

​

​

Development of reports to measure several productivity indicators and the cycle time of several production lines (OEE Overall Equipment Effectiveness) . Automation of visualizations with direct query and automatic refresh. Creation of management dashboards.

RDBMS

Excel

Records: 3M rows p.a. and Linie

​

​

​