Building a Custom Reporting Platform
KOBA Insurance is Australia's first car insurance company to introduce a pay-as-you-drive model to the Australian market. Being a start-up, KOBA had the need for an analytics platform that could scale with the company, but also not break the bank. Illumination Labs was tasked with building and deploying a completely custom business intelligence/reporting platform to cut long-term costs as much as possible.
Analytics & Technology, BI/Reporting, DevOps & Deployment
Plotly Dash, Docker, DataBricks, Python, AWS EC2, AWS Lambda, AWS S3, Google SSO
Project Overview
Illumination Labs had the challenging task of building an advanced reporting platform while keeping costs low. Utilizing an open source framework called Plotly Dash allowed the team to accomplish goal by building a completely custom reporting framework. Dashboards were created in Python using Plotly, packaged in a container using Docker, and deployed on a server using AWS EC2.
Execution
Illumination Labs built 15 dashboards using the Plotly Dash open-source framework. This required the following milestones:
- Cleaned and modeled data in DataBricks to prepare data for reporting
- Build web-components within Plotly Dash to enable for scaling
- Defined business requirements and executed by building reports for each department and business need
- Implemented user authentication using Google SSO
- Packaged the deployment in a Docker container and enabled automatic deployments through GitHub
- Deployed the container to an EC2 instance and mapped to a sub-domain to allow for internal access
Results
- Over 15 dashboards/reports being consumed by the business on a daily/weekly/monthly cadence
- Automatic alerts being sent to slack reporting on business performance
- Security ensured through only allowing access with company emails
- Long-terms costs are kept to a minimum, only spending roughly $100 for the maintenance of the server and reports
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