Manually updating dozens of PowerPoint slides for an ongoing tracking study
As a research analyst for dunnhumby, Dóra Török is responsible for several client projects. One of her ongoing projects is a long-term tracking study for a major retailer, tracking their loyalty program’s image. The study began in 2019 and is updated quarterly with data from four different countries.
“We do most of our reporting in PowerPoint,” Dóra explains.
When we have a report like these that include 50-100 slides, that’s a lot of copying and pasting. Creating the charts and everything takes so much time.
The questionnaire the study was based on was the same every quarter—the answers changed, but the questions didn’t, as the client was interested in finding trends and changes in the data over time. But updating the reports with new data was still taking weeks every quarter.
“We have so many charts to redo, but it’s the same structure each time, based on the same questionnaire,” Dóra says.
Dóra and her supervisor, Jan Osička, knew there had to be an easier way to update their data each quarter. And they also wanted to be able to give their clients data in a more dynamic format.
“We saw an opportunity to look for new solutions,” Jan says. “And provide our clients with something different, rather than giving them hundreds of PowerPoint slides to look at.”
Dóra knew that with the right tool, she could save countless hours on her tracking study each quarter and give her clients engaging, visual data presentations. Now she just needed to find it.