Case Study
Menu
Client
Unilever
Completed
March 2018
Timeframe
3 Weeks
Automating manual reporting task and reassigning resource to higher value-added tasks
Challenge
Each month, a team needed to generate numerous powerpoint presentations to multiple stakeholders. However, this task was very manually intensive. If a data set arrived incorrectly, the team needed to recreate the charts again. Sometimes, this task had to be re done multiple times which meant that valuable resource were deployed for days or weeks doing a task that could have been automated.
Solution
Within 3 weeks, a Python script had been written to read in data from multiple sources and create unique powerpoint presentations for each country/department based on the results of the data. We were also able to tailor the commentary and titles to highlight any key insights, rendering to total process automated apart from the sense checking and any additional ad-hoc comments.
Outcome
A task that once took a team days/weeks each month to complete now could be done by one person in about an hour. The team were able to significantly free up a large proportion of their time and their talents can utilised in other, more value added tasks.
Address
info@bnmanalytics.com
4th Floor, Radius House,
51 Clarendon Road, Watford, WD17 1HP
Tel:
