Building a data warehouse to drive strategic business decisions: Laka
6 FTE days/week saved
50% of all reporting requests available from self-serve.
> £70k per annum saved
in data engineering resource and management time.
Business stakeholders able to make informed decisions
Laka offers a customer-focused model of collective cover, based on flexible payments that rise and fall in line with claims volume in order to provide best value by only paying for the true cost of cover.
Industry: Retail Insurance
We would have had to have figured out another way to answer data questions because that’s what we would have had the capacity for. That means we lose understanding, which is vital for us to make good business decisions. It becomes an amount of work that is not really possible for us to do at all without a service like Kleene to get us across the line
With data siloed across multiple different systems, a claims management system running on PostgreSQL and multiple separate SaaS API data sources such as commercial billing on Xero, payments via Stripe, multi-currency exchange rates and marketing via Facebook, bringing all this data together without Kleene would have meant a multi-month engineering project and a lot of ongoing management.
With the Kleene platform in place, Laka were able to set up automated data pipelines to power both daily reporting and self-serve around products, policies and claims.
In Ben’s experience, people who are not data specialists will often gravitate towards the latest buzzwords in technology, which lately lean in the direction of high-availability, low-structure types of data resources (e.g. data mesh, datamart, data lake etc.). Ben feels that for organisations of a similar size to Laka, or even an order of magnitude larger, a consolidated, structured approach to data will net the best results – which is very much the data warehouse paradigm. He notes that the fact that it is well modelled makes it much easier for people who are less data-literate to interact with and that this is especially true around a single source of the truth. Without one, a simple metric can have an entirely different meaning across departments which are both technically correct, but do not align.
Ingesting data quickly and easily
Ben finds that one of the trickiest bits when handling data is pulling that data together from different sources. Kleene handles the connection, extraction and unpacking of data seamlessly, when it would be tedious and complicated to code manually. Laka use Xero for all of the invoicing for their commercial clients. Ben feels that while coding extracts for Xero to pull data in JSON format for each different use case is perfectly tractable, that it is not an efficient use of his time. It would probably take a month of full-time software development to build an initial connector which is time and cost prohibitive for them, and they end up having to find other ways to get the information they require.
Managing and maintaining connectors
Ben also notes that in previous work environments he has found that ongoing maintenance of connectors to data sources can be problematic. When version changes to the data source occur, they are often not coordinated with the consumers of that data source and that if you do not immediately make corresponding changes – that could add up to a lot of unplanned development effort – that your source of data stops outright.
When looking at transforming the data, Ben finds that being able to do it all in one place is helpful. Without Kleene, he would be performing a similar job, but a lot more manually and across several tools. Whiteboarding the transforms, writing the SQL and then importing that work into a DAG (Directed Acyclic Graph – used for managing dependencies) tool to verify it is all as needed.
Self-service reporting – saving time
One of the main goals for Laka’s data warehouse project was to reduce the volume of inbound report requests into the data team by enabling self-service reporting for their users. It has been running for just under a quarter now and early signs point to fantastic adoption by the wider business, freeing up time for the data team to focus on the more complex queries that will drive greater business value.
Operating at a higher level
Ben finds that there is a tremendous amount of utility in everyone being able to access reliable measures of business metrics and their change over time. These are some fairly simple calculations but were difficult to get an answer to prior to the project with Kleene. With this data available to users throughout the organisation, decisions can be made without having to wait for the data team to compile new reports. Having the Kleene platform in place saves time and allows the business to function at a higher level.
Running a lean data team
With the Kleene platform, all of the manual work around data extraction and building a data warehouse can be fully automated, freeing up time to drive a data strategy that can be transformative for the business.
Read Our Success Stories!
Home » Case Studies » HuelCase Study: Huel58 FTE days per month saved Reconciliation down from 3 staff x 2 weeks to under 2 days for a single user> £100k per annum saved In engineering resource, reconciliation effort and management time.Rapid data pipelines...
Home » Case Studies » Blue Light CardCase Study: Blue Light CardRenewals target increase from -14% to +7% of target.77 cross-function reports built across 12 themes.50% of the business now uses Tableau.About Providing a discount service to emergency service...
Home » Case Studies » XtracCase Study: XtracOver 40 dashboards and reports generated.10 days a month saved in administration time with automated financial, board and investor reporting.Optimized production on the factory floor, increasing output and in turn,...
Get started with Kleene today
Set up takes a few minutes and a world of insights awaits. Simply get started for free!