Data has played a pivotal role in carwow’s business model from day one, but as the company grew, it found its original data systems were struggling to cope with the extra demand being placed on them. Not only were important system syncs taking longer to perform but increasing fragmentation of data sources and a lack of standardised analytics/reporting tools was causing confusion amongst employees and making it hard to identify important business insights quickly.
“We needed to simplify operations, switch off unnecessary tools and implement a central data platform that could easily scale alongside the company as it continues to grow,” says Tim Hesse, Director of Data at carwow.
This began with the migration of all company data to Snowflake and Fivetran, simplifying data management and greatly improving processing speed.
“Snowflake’s flexibility and our ability to dedicate warehouses to ETL and reporting tasks vastly improved our BI processes. This was a significant early factor in accelerating our speed to insight,” says Tim.
Next, Tim trialled several analytics platforms to complete the stack, quickly identifying Tableau as the ideal solution for the company’s needs.
“Tableau’s visualisation capabilities are what made it really stand out from the competition,” says Tim. “Not only could we create fast, accurate reports right from the start, but the highly visual approach added a new, exciting dimension to data analysis that simply didn’t exist before.”
With the new data stack in place, all 220 employees are now working from a single source of truth for the first time, eliminating data silos and cutting time to insight by an average of 30 percent. Governance is controlled via Tableau permissions, giving everyone fast, convenient access to the information they need whilst ensuring sensitive data remains secure.
“With Tableau, everything is done inside the platform and governed through a central certified & published data source,” says Tim. “As a result, data analytics and reporting have become fast, convenient and more secure. Furthermore, everyone can be confident they are looking at the same information now, rather than having five different versions of a report or spreadsheet flying around on email and causing confusion.”