Our work
Institut Viavoice
BotiqueAI
Institut ViavoiceLLM · CodingMarket research · PowerPoint
Case Study

Market Survey

AI-coded verbatims to PowerPoint decks, in one platform.

Institut Viavoice is a market and opinion research institute. We built a web platform that codes open-ended questions with AI, extracts result tables from Excel, suggests relevant charts and generates PowerPoint decks with native charts.

AI
assisted codingCode plan generated then validated
PPTX
native chartsEditable in PowerPoint
20+
API endpointsCoding, extraction, charts, export
≈ 0–7 $
infra / monthPay-per-use Cloud Run (estimate)
Client
Institut Viavoice
Market and opinion research
Industry
Research & Consulting
France
Module 1
Coding
Open-ended questions
Module 2
Charts
From Excel tables
Module 3
PowerPoint
Chart basket
Stack
FastAPI · Next.js
Google Cloud Run
The Challenge

From Excel file
to client deliverable.

In a study, free-text answers must be coded one by one, then cross-tabulations are turned by hand into charts and slides. These steps are slow, repetitive and error-prone.

The goal: automate the bulk of the work while keeping the analyst in control of every step.

Coding verbatims
Hundreds or thousands of free-text answers to group into consistent themes, with a code plan the analyst can review and correct.
Using Excel tables
The institute’s cross-tabs have merged headers, subtotals, bases and mean rows that must not be confused with answer options.
Producing presentations
Readable, editable charts in the expected format, without rebuilding each slide by hand.
The Solution

Three modules,
one platform.

A Next.js application with authentication, driven by a FastAPI API. Long operations stream their progress live (SSE) so the analyst can follow along.

①
AI-assisted coding

Choose the column to code, generate a code plan (themes detected in batches processed in parallel), code each response, validate, browse responses by code and export to Excel. The system prompt is editable, plan clarity can be checked and test responses can be generated.

GPT-4o-miniBatches parallèlesSSEopenpyxlExport Excel
②
Extraction and charts

Table extraction from Excel (merged headers, subtotals, bases and means handled), chart suggestions by an LLM from the files, and 100 % stacked charts in two orientations (Y by X or X by Y).

GPT-4oExtraction ExcelStacked bar 100 %Formats
③
PowerPoint generation

Selected charts are collected in a basket then exported as a PowerPoint deck with real native charts, directly editable by the team.

python-pptxNative chartsCartDownload
④
Platform and deployment

Google or credentials login, admin area, trial banner and user feedback. Frontend and backend on Google Cloud Run (Europe), files on Cloud Storage, secrets in Secret Manager, built with Cloud Build.

NextAuthCloud RunCloud StorageSecret ManagerCloud Build
Impact

Less manual work,
more analysis.

3
automated steps
Coding, charts, PowerPoint
20+
API endpoints
A single backend
Live
live progress
Long operations tracked
0–7 $
infra cost / month
Scale-to-zero (estimate)
Tech Stack

AI stack
and serverless cloud

OpenAI LLMs for coding and chart suggestions, FastAPI and python-pptx for production, and Cloud Run for hosting that scales to zero when idle.

AI
🤖
OpenAI
Code plans, coding, chart suggestions
⚙️
Batch processing
Themes detected in parallel, progress via SSE
Backend
⚡
FastAPI
Coding, extraction, charts, export
📊
python-pptx · openpyxl
PowerPoint with native charts, Excel read and export
Frontend
🖥️
Next.js
Coding, dashboard, basket, administration
🔐
NextAuth
Google or credentials login
Cloud
☁️
Google Cloud Run
Frontend and backend, Europe, scale-to-zero
🗄️
Cloud Storage · Secret Manager
Files and secrets
BotiqueAI
Custom AI for research institutes
← Back to portfolio