Project Overview
A UK market research agency running 200+ surveys per year for FTSE 250 clients needed to replace their fragmen...
Technology Stack
Compliance & Standards
The Challenge
A UK market research agency running 200+ surveys per year for FTSE 250 clients needed to replace their fragmented data workflow: survey creation in Qualtrics, analysis in Excel, visualisation in Power BI, and client delivery via PowerPoint — four tools, extensive manual data manipulation between each step, and no single source of truth. The agency wanted to launch the platform as a SaaS product to other market research agencies. Budget: £130,000.
Our Approach
Dashboard Pipeline
End-to-end data pipeline: survey builder (React drag-and-drop, conditional logic, quota management), response collection (REST API, 2,000 responses/second capacity), automated data cleaning (flagging speeders, straight-liners, and duplicate IP responses), SPSS-style cross-tabulation engine, and real-time dashboard with 40+ chart types.
UK GDPR for Survey Respondent Data
- Survey data is personal data — respondents are identifiable by IP, device fingerprint, and potentially responses.
- PECR consent for email recruitment.
UK GDPR
consent as lawful basis for most research, legitimate interest for B2B research.
Data minimisation
IP addresses anonymised after 48 hours (sufficient for deduplication, not retained).
Retention
- respondent data deleted after 24 months.
- Multi-
Tenant SaaS Architecture
- PostgreSQL separate schema per agency client.
- Survey templates shareable within an agency (but not across agency tenants).
- Respondent panel management per agency (agencies maintain their own respondent databases).
- White-label capability: agencies can brand the respondent-facing survey interface with their own logo and colours.
Client deliverable generation
- automated PowerPoint report (python-pptx) from dashboard data — reducing 8 hours of manual slide building to 12 minutes.
- PDF executive summary (WeasyPrint).
- Excel cross-tab export (openpyxl).
- All reports generated on-demand and cached for 24 hours.
The Results
Launched at 18 weeks, £124,000 — under budget.
Survey-to-client report time: 3.5 days → 4 hours.
SPSS cross-tab replacement: 100% of standard analysis now done in platform (SPSS licence eliminated — £12,000/year saving).
SaaS launch: 6 paying agency clients in first 4 months at £2,400/year each.
Data quality flags caught 8.2% of responses as suspect (speeders/straight-liners) — previously undetected.
“Three and a half days to four hours — that is not a small improvement, it is a different business. Our senior researchers now spend time on insight, not Excel manipulation. The PowerPoint automation alone justified the investment in the first quarter." — CEO, UK Market Research Agency (name withheld)”
Project Details
Ready to Transform Your Business?
Let's discuss how our technical expertise can help you achieve remarkable results.