Business goal:
Plant managers needed a centralized automated solution that helped them monitor key metrics (operations focused) to help them better manage manufacturing plants.
Technical Summary:
– 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.
Mockup:
That’s a very clean looking report, Paras. Simple, bold and easy to read. Nice example.
Thanks Paul! it was fun working on it.