Result

Healthcare software provider upgrades their SaaS application with embedded, feature-rich analytics

Could a real-time, self-serve, data reporting platform in the hands of your team members help your organization?

Overview

Our client wanted to gain a competitive advantage with their SaaS application by offering feature-rich analytics embedded into the application.
Existing analytics was driven off the single-tenant operational databases using complex SQL statements that could not be reused across customers due to the different data models per customer. Any needed changes were restricted by the legacy approach that required extensive labor and testing to enhance. The application experienced severe performance issues.
A scalable solution was needed to expose the trove of data for customers that could be easily integrated into their application.

 

chordline case study

Our solution

OneSix designed an end-to-end automated framework to load multi-model databases per customer into a Data Lake and transformed that into a multi-tenet Data Warehouse addressing Cases, Authorizations, To-do lists, and Compliance threshold reporting.

All new tools and platforms were introduced that would help automate new customer loads by using a simple control table.

A live connection to the data warehouse using the powerful Snowflake engine served embedded analytics using Sisense visualization.

The complex security model was simplified via 2 security tables that allowed bi-directional integration between Sisense and the SaaS application.

OneSix took advantage of many powerful cloud data platforms to create the appropriate best-of-breed solution for our client:

Results

A robust, scalable, and feature-rich data solution was integrated into the client’s SaaS application requiring minimal effort to enhance per future customer needs.

The highlight was to deliver a single warehouse and transformation architecture that catered to the multiple versions of their applications and customers subscribing to one of those different versions. Intelligence was designed in Matillion transformations for this approach.

The SaaS application performance improved as analytics was driven off a separate database and not contending for resources off their main application.

OneSix was termed as one of their easiest vendors to work with.

results

My experience was fantastic with OneSix. They listen to your query carefully and then are able to solve your issues within the correct time frame and reasonable price. Super knowledgeable team!

Ayush J.
SEP 28 2022

One of my favorite things about One Six is their willingness to work with us on whatever we need. Early on in the project, we determined we needed an additional tactical resource instead of an advisory one, and One Six happily switched out resources for us, ensuring we had what we needed to complete the project.

Pamela E.
NOV 8 2021

They dig in and help understand the problem, how to think about it, provide the best technical options of how to solve it, then execute as quickly as possible. This is by far the best way to help me make sure we're successful, and that I know what's being done and how to support it once they're finished.

Brandon H.
OCT 20 2020

Transform your data org

Schedule a free consultation with the team.