Loading…
2 days per report. In Excel. Every analyst with their own workflow. This platform replaced the entire pipeline — import, codify, cross-tabulate, chart, benchmark, export — in real time. What took days now takes minutes. The architecture evolved into today's SynapInsight.
B&Optimos runs survey panels for brands across Latin America — consumer studies, brand tracking, market intelligence. Their business depends on turning raw survey data into client-ready reports. But in 2017, every report was built by hand: analysts exported data from Gandia BarbWin into Excel, ran cross-tabulations manually, built charts one at a time, and assembled PowerPoint decks slide by slide. The firm's longitudinal data — their most valuable IP — was locked in disconnected spreadsheets.
These are the operational bottlenecks that AI automation eliminates in a 2-week pilot.
Manual reporting pipeline — raw survey data → Excel → manual cross-tabs → manual charts → manual PowerPoint. Every step was a human task repeated per report. 2 days turn-around was normal.
No client self-service — clients couldn't explore their own study data. Every question meant a call to an analyst, who ran a new query and emailed a new file. Analysts were the bottleneck.
No cross-study comparison — each study was a silo. Comparing brand health across studies, sectors, or time periods meant manually extracting data from multiple Excel files and aligning formats.
No standardized methodology — each analyst had their own Excel workflow. Cross-tab structures varied. Chart styles varied. Report formats varied. Deliverable quality depended entirely on who ran the analysis.
A full-stack analytics platform that replaced the entire analyst workflow in one system. Survey data imported from Gandia BarbWin. Open-ended responses codified with automatic and manual coding engines. Data normalized with configurable virtual variables. A cross-tabulation engine generates frequency marginals, statistical marginals, crossed frequencies, crossed statistics, cell statistics, and summary statistics — all in real time. Eleven chart types available on demand: lines, bars, pies, histograms, frequency polygons, brand health pyramids, category comparisons, and multi-category comparisons. Seven specialized analysis modules handle advanced use cases: Tour the Brand, Brand Travel, Social ADS, Brand Penetration, Brand Strength, Colombia en Números, and Top 2 Top. A benchmark engine connects studies together — compare indicators across studies, sectors, and time periods. One-click export to PowerPoint, Excel, or PDF with consistent formatting. Role-based access means clients log in to explore their own study data without calling an analyst. Python + PostgreSQL. 4-month build, 1,473 total hours. Full IP transfer.
Every technology in this stack is production-proven across CAMTECH AI client engagements.
Import GBX survey data → automatic and manual codification → normalization engine with virtual variables → cross-tabulation engine (frequency marginals, crossed statistics, cell statistics) → 11 chart types on demand → 7 specialized brand-health modules → benchmark across studies and sectors → one-click export. All in real time. No Excel. No wait.
Architecture diagram coming soon
Analysts stopped formatting charts and started analyzing data. What took 2 days per report in Excel became a real-time web workflow: select a study, define cross-variables, generate tables and charts, export. Clients got self-service access — log in, explore their study, apply filters, generate their own charts. The firm's longitudinal data became a queryable benchmark asset instead of disconnected files. The domain knowledge and architecture from this platform evolved directly into SynapInsight.
Every CAMTECH AI engagement starts with a scoped 2-week pilot and a measurable outcome. Book a discovery call and we'll scope your first project.
WANT THE SAME RESULTS?
Book a Free Discovery Call →WANT A CUSTOM BUILD?
Explore SynapInsight →WANT TO SEE MORE?
See All Featured Projects →Every CAMTECH AI pilot ships in 2 weeks — clear scope, fixed timeline, measurable ROI.
Real client projects with measurable outcomes — scoped, built, and shipped by CAMTECH AI.
38 DB-enforced business rules
Independent microservice: catalog, subscriptions, wallets, ledger with 9 operations, Mercado Pago integration.
70–88% monthly cost reduction
Full AWS rebuild. Terraform/Terragrunt 100% coverage. EKS Karpenter+Spot. Aurora Serverless v2. Argo CD GitOps.
50% fewer support tickets
Conversational chatbot explaining background check results in plain language. Web + WhatsApp. LangGraph + FastAPI.
3× panelist engagement
Dashboard replacing Excel. Points balance, payment history, email notifications. Transparency drove loyalty.
3× smoother completion rate
Flutter mobile survey. Branching logic, auto-save, cross-device resume. Connects PanelWhy → Orión.
Manual reconciliation eliminated
Decision engine connecting Mercado Pago + Siigo + Bitrix24. Auto-generates receipts, invoices, CRM updates.
