- Technology
Creating a new revenue stream with embedded BI for a B2B SaaS platform
Overview
Transforming reporting capabilities for a streamlined client experience
Our client wanted to revamp their existing reporting and create a new advanced reporting revenue stream by embedding a BI solution into their web application.
Their previous platform was developed in-house and difficult to support. Additional requests for data and reports had to be supported with another tool and consumed much of the customer support team’s time. Our client wanted to retire both reporting tools and provide clients with better insights into their data by allowing direct database access to incorporate into existing workflows and reporting solutions.
Our Solution
Building a modern data stack with embedded BI
OneSix built new custom data pipelines to efficiently move the large volume of their production data into the cloud, in order to create a modern data stack that could be levered with their new technologies.
Sigma was seamlessly embedded within the existing web app, and existing reports were sunset to use the new reporting capabilities. New data sets were also created to increase accountability and decrease development time for new custom reporting requests in the future.
Data sharing within Snowflake was implemented to give clients direct access to their data without the need for reports to the ServiceCore team and the use of another tool. This enables their clients the full flexibility to use and manipulate the data as they see fit.
Technologies Implemented
- Snowflake was chosen as the data warehouse due to its favorable data storage, extremely fast performance, low query calculation costs and its industry leading scalability.
- AWS, Snowflake and Terraform were used to create an in-house ETL process to limit costs and provide a workflow that could fit into existing Dev/Ops procedures.
- Sigma was leveraged for data visualization, seamlessly embedding a fully white-labeled product into the client’s existing platform
Results
New revenue stream, reduced tool overhead, and simplified reporting
With the customer’s new modern data platform, they were able to generate a new tiered revenue stream that fits the needs and market size of their clients with a handful of clients already using the direct database access.
The customer was able to retire existing tools and licensing fees and the reporting stack was simplified. The data stack created will continue to be further leveraged in the future for more internal business reporting needs.
Ready to unlock the full potential of data and AI?
Book a free consultation to learn how OneSix can help drive meaningful business outcomes.
