Revenue Operations Strategy
Operating model, funnel definitions, forecasting cadence.
CRM & Sales Technology
Selection, implementation, routing, dialers.
Marketing Technology
Lifecycle automation, campaign and ad integration.
Data Analytics
Warehouse, pipelines, executive reporting.
Systems Integration
LOS, CRM, telephony, marketing and finance connected.
Software Development
BI platforms, routing engines and middleware built to fit.
.png)
May 1, 2022
Building an Analytics Infrastructure From Sctratch
KOBA Insurance is Australia's first car insurance company to introduce a pay-as-you-drive model to the Australian market. Based in Melbourne, the start-up has been data driven since day 1, primarily due to the heavy reliance on trip-tracking for the insurance product to work properly. Illumination labs has been with KOBA Insurance since the beginning, helping them plan and build a scalable analytics infrastructure.
KOBA Insurance
Project length
6 Months
Technologies used
AWS, Snowflake, dbt, Python
Roles we played
Software Developer, Data Analyst, Data Engineer, Business Analyst
Result
10 Data sources being processed, cleaned, and aggregated into a central DWH in DataBricks
01
Project overview
Being a start-up, KOBA Insurance had no technology setup and no infrastructure in place. This being a rare opportunity, Illumination Labs had the joy of being able to design an analytics infrastructure from scratch. And not only did we get to design it, but we also were able to implement it.
02
Our execution
Illumination Labs selected a few different tools for the infrastructure, the main ones being Databricks as the central data warehouse and Plotly for the BI & visualization. Illumination Labs went through the following phases to build this infrastructure from the ground up:
- Deployed DataBricks on AWS
- Setup Fivetran to begin dumping data from key business systems, including Stripe and Mailchimp
- Worked with developers to setup custom ETL processes to migrate data from core business systems, including MongoDB and DocumentDB
- Created over 20 workflows in DataBricks to process, prepare, and aggregate data coming from these different sources
- Automated data quality checks to catch bugs before they impact reporting
- Built a custom BI platform using open-source Plotly Dash
- Developed over 10 reports on the BI platform which monitor the companies most important metrics
03
Key results
15,000+
quotes processed daily
10
data sources in one warehouse
Also delivered
- 20+ automated workflows processing and preparing data every day
- Automated data quality checks that catch issues before they reach reporting
- 10+ reports tracking the company’s most important metrics
- App, driving, payment and email data in one place
Need help with a project like this?
We’d love to chat and learn more about what you’re hoping to accomplish. Fill out our form and we’ll get back to you as soon as we can.