The Challenge
Odaptic had been relying on Microsoft Forms and Power BI to deliver survey and reporting solutions to their customers. While this setup allowed for the creation of elegant, complex reports, the system failed to scale efficiently. Each new customer onboarding required significant manual effort, making the process expensive and time-consuming. This inefficiency hindered growth and drove up costs as the user base expanded.
Additionally, Power BI posed several limitations in terms of customisation—especially around UI/UX. While powerful analytics features were possible, creating highly tailored, rich visualisations was either constrained or required building custom components anyway, adding further complexity and time.
Odaptic needed a scalable, self-service solution that could handle growth, reduce manual overhead, and deliver a fully customisable reporting experience aligned with their needs.
The Solution
To address these challenges, Odaptic decided to replace their Microsoft-based survey and reporting system with a fully custom solution built on AWS. The new platform enabled users to:
- Self-Service Onboarding: Customers could sign up and start using the platform without any manual intervention from Odaptic, drastically improving scalability and accessibility.
- Scalable Architecture: Using Amazon DynamoDB to handle the high-load of survey response ingestion, paired with Postgres on Amazon RDS for structured reporting, the system balanced cost optimisation and performance. DynamoDB allowed scaling for input-heavy operations without bottlenecks, while Postgres handled reporting with minimal costs.
- Custom Reporting Solution: Instead of relying on third-party tools like Power BI or Apache Superset, the team built a custom reporting engine using Svelte, AG Grid, and AG Chart. This approach unlocked full control over visuals and user experience, enabling rich, interactive reports with AI-driven insights.
- Advanced Admin Capabilities: A seamless impersonation feature in the admin panel allowed Odaptic's team to instantly log in as any customer, providing troubleshooting and support capabilities that were nearly impossible with Power BI.
- Security by Design: Built-in multi-factor authentication (MFA), password resets via SMS/email, and user management powered by Amazon Cognito ensured enterprise-grade security.
The Results
The transformation yielded significant benefits for Odaptic:
- Scalability: Users can now sign up independently and start working on the platform without delays, allowing for exponential growth.
- Reduced Costs: Automating customer onboarding and leveraging DynamoDB/Postgres architecture helped Odaptic cut operational costs significantly.
- Improved Visuals: Reports matched Power BI's analytic depth while offering a richer, more interactive experience with complete control over visuals.
- Streamlined Admin Support: The impersonation feature enabled Odaptic admins to troubleshoot or review client data instantly, saving support time and effort.
- AI-Powered Insights: Advanced integration of AI insights ensured reports delivered actionable, dynamic data in a user-friendly format.