|
A company needed a means of measuring its customer service efficiency and performance as well as the different types of orders that were being placed for products. They needed to maintain historical data in order to perform analysis against the same week period in the previous year.
A database was designed to capture data through several external data sources as well as user entry. It then compiled the information and exported the data to an Excel spreadsheet that utilized a scorecard methodology and created charts and graphs as well as side-by-side comparisons, which were used for data analysis. This enabled the business to strengthen their business intelligence by providing them an automated means of conducting viable metric analysis.
| This is a screenshot of the Metric entry form for selecting the week to enter data for |
Metric data entry form |
 |
 |
Side-by-Side comparison of current and previous year in Excel.
|
