top of page

Automotive

Industry

Global Automotive Supplier

Manufacturing plant 700 employees

Services

data cleansing

data modeling

data analysis

visualizations

Challenges

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

Tools

Excel

Power Query

Power BI Direct Query

Solutions

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.

Data Sources

RDBMS

Excel

Records: 3M p.a. and Linie

bottom of page