tiered pricing model launched using embedded Sigma BI and direct Snowflake data sharing for clients
two existing reporting platforms sunset, reducing licensing overhead and consolidating the reporting stack
clients can now connect directly to Snowflake shares and integrate data into their own workflows
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.
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.
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.
More to explore
Through a three-phase approach, including a comprehensive assessment, tailored recommendations, and a clear roadmap, OneSix helped the bank set the foundation for improved operational efficiency, enhanced customer experiences, and future-ready data strategies.
OneSix helped a luxury spa franchise optimize its marketing investments using data-driven analytics, leading to a 15% increase in prospect sales. By implementing a marketing data warehouse, marketing mix modeling (MMM), and automated budget optimization, the client gained real-time visibility into performance.
OneSix implemented a centralized data lake and data warehouse solution for a healthcare technology firm, enabling streamlined data management, on-demand analytics, and enhanced decision-making across the enterprise.