Data + Analytics
Data + Analytics
Usay Compare is a market-leading comparison service for health insurance, life insurance and income protection. With access to the leading insurers and an outstanding team of friendly, expert advisors, they make cost-effective private medical care straightforward and accessible. With Datatonic’s support, Usay Compare wanted to optimise its Google Cloud usage by implementing BigQuery and using Dataform to move previously siloed data into one easily accessible data warehouse.
Usay Compare’s goal was to improve how its data was organised to make it reliable and easily accessible. To achieve this, it wanted to develop a future-proof data stack on Google Cloud and data management processes to enable digital efficiency at scale. This would reduce the effort that goes into manual data reporting, eliminate siloed data, and enable better data visualisation.
Usay Compare needed a data transformation solution that is straightforward to implement and use, without the complications or costs of third-party software. The Usay Compare data landscape required a data warehouse that is capable, but also simple and cost-effective to deploy and use.
After careful consideration, Dataform was highlighted as the best solution for Usay Compare data management needs. However, additional challenges remained:
* Dataform has since gone GA, which organically alleviates any further concerns
“Our previous database environment restricted the data team to read-only access, limiting our ability to create bespoke tables within our database, and we were unable to create a data gateway to our reporting platform. This meant we had a reliance on virtual machines running various Excel reports to create our bespoke tables, which were prone to crashing” – Mike Squires, Head of Business Intelligence at Usay Compare
Datatonic worked with Usay Compare to develop a best-practice Enterprise Data Warehouse on BigQuery, and used Dataform to deliver a deeply-integrated and easy-to-use data model and management solution. This included:
“The project team at Datatonic delivered exactly what was promised, providing a data model which we continue to build on since they completed the integration. The training they provided was comprehensive and accessible.” – Mike Squires, Head of Business Intelligence at Usay Compare
With this new solution, Usay Compare has high-quality, accessible and reliable data in its BigQuery data warehouse. Dataform implemented with best practices ensures that data is tested, to make sure it is reliable. This enables the Usay Compare team to increase their efficiency when working with their data to drive valuable business insights.
Dataform enables users to develop and operationalise scalable data transformation pipelines in BigQuery using SQL. It allows businesses to simplify their data processing architecture, collaborate using software development practices, and build production-grade SQL pipelines. Dataform is simple to set up and often requires fewer steps and less manual effort than with other tooling. Read more here, and contact us to find out more.