Plant managers needed a centralized automated solution that helped them monitor key metrics (operations focused) to help them better manage manufacturing plants.
– Work with the plant managers to identify key metrics & calculations to be displayed on dashboard
– Work with the IT managers to identify data source systems.
– Develop the Dashboard using SQL Server Reporting Services. (Built iteratively by making sure to have three checkpoint meetings with plant managers while working with IT/Business-Analysts to ensure data integrity)
– Developed drill down reports see detailed data at plant and machine level.