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.
Analytics & Technology Consulting, BI & Reporting, Data Science & Machine Learning, Data Engineering
DataBricks, AWS, Plotly, MongoDB, DocumentDB
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.
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
Results
- KOBA is processing over 15,000 quotes a day, due to our help of implementing their insurance rating model and storing data properly
- Over 800 Australians have joined the car insurance revolution in just 1 year of being in business
- More than a dozen dashboards have been built in a completely custom BI platform, allowing KOBA to save money and have complete control over their BI and analytics.
Need Help with a project?
We'd love to chat and learn more about what you're hoping to accomplish.
Still Investigating?
Check out our about us page to learn more about what we bring to the table.
About Us