Automated performance management and business intelligence reporting
Requirement: Automate the production of reports on sales of their household goods to an international supermarket chain.
Solution: SJM Training developed an automated weekly report system to analyse the source data and populate a number of spreadsheet reports comparing this year and last year sales for the same week, broken down into normal sales and promotional sales. Source data came from various Excel spreadsheets, some generated from Retail Link reports. The automated system produced the necessary reports in 15 minutes compared to the previous manual compilation time of 4 to 5 hours.