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.
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.
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.