Market Research Automation

Sometimes it is fascinating how large the leverage of automation can be.

One of our customers, a market research institute, owns a panel and performs questionnaires and their analysis on other companies' behalf. For years they hand-filled the same Excel-Sheets and Powerpoint presentations with data from standardized questionnaires, while preparing the analysis in SPSS as an intermediary step. For each project they needed around two weeks of labour to prepare the results.

Python to the rescue. In around two weeks, we automated around 90% of the workflow. Thanks to great open source libraries like pandas for data analysis, matplotlib and others for data visualization, xlwings for Excel manipulations and python-pptx for PowerPoint creation. This was fun.

Long live the open source revolution.