Challenge

• A well-known consultancy needs a KPI dashboard for one of its clients to measure the performance of different production sites
• The KPI dashboard should not only show aggregated key performance indicators, but also detailed indicators about each site
• It should be used to constantly track and monitor whether budgets are achieved for each KPI

Solution

• An Excel dashboard will provide an overview of all aggregated key performance indicators
• Each KPI can be drilled down by clicking the button next to it
• Each KPI can be visualized on demand with a budget versus actual comparison and a forecast based on the latest numbers

Benefits

• Increased transparency of the performance of each production site
• Enables the management to actively track and monitor each site
• User-friendly and appealing user interface ensures constant use of the tool

Screenshot

Click on the picture to enlarge it.