Find out how >
IT Training solutions
designed around you
All our training is tailored to you and what you need to do your work; efficiently, effectively and with less frustration.

SC Johnson

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.