CloverDX > Case Studies > Extending a Data Warehouse, Building a Relationship for the Future

Extending a Data Warehouse, Building a Relationship for the Future

Company Size

11-200

Region

Europe

Country

United Kingdom

Product

autoVHC
CloverETL

Tech Stack

Data Warehouse
ETL tool
SQL
Visual Basic

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Customer Satisfaction
Productivity Improvements

Technology Category

Application Infrastructure & Middleware - Database Management & Storage
Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Automotive

Applicable Functions

Discrete Manufacturing
Quality Assurance

Use Cases

Fleet Management
Predictive Maintenance

Services

Cloud Planning, Design & Implementation Services
Data Science Services

About The Customer

BTC Solutions is a UK-based company that offers a fully-computerized Vehicle Health Check system, autoVHC. This system provides a solution to one of the biggest performance shortfall areas in the current aftersales market. autoVHC automates the follow-up process, closing the gap in dealer profits. BTC works with more than 800 dealers across the UK and Europe, with plans to expand into China and Russia. The company was looking for a provider with the right expertise to build a lasting relationship and chose CloverETL due to its pure data integration approach.

The Challenge

BTC Solutions, a UK-based company, was facing a demand for increased performance of their autoVHC platform due to growing amounts of data and rising customer expectations for a quicker turnaround. Dealers were having difficulties accessing fresh data, leading BTC to search for an ETL tool that could handle fast-changing data. BTC had three main requirements for the data warehouse solution: Data History, Robustness, and Flexibility. The new data warehouse needed to keep track of changes and record all modifications done to the database. It also needed to be able to handle ten times more data than their current database. Lastly, the solution needed to be user-friendly, so that BTC could define and modify the transformation procedures.

The Solution

BTC worked closely with a team of consultants from CloverETL. The team assessed BTC’s current solution and discussed their plans to expand, namely into China. A completely revitalized solution was developed that will bring BTC Solutions where they want to be – a leader in the global market. The new incremental loading introduced by the consulting team improved performance immensely. Moving from the day-long delay of the previous system, the new process allows continuous loads every fifteen minutes, keeping the data readily available to customers in near real-time. Fact and dimension tables in the newly designed data warehouse have been updated and enhanced with many new validation rules, which also provide change history tracking. The automated ETL processes generate technical reports as well as log errors found during the loading process according to specification.

Operational Impact

Improved performance of the data warehouse.
Continuous loads every fifteen minutes, keeping the data readily available to customers in near real-time.
Updated and enhanced fact and dimension tables in the newly designed data warehouse with many new validation rules.
Automated ETL processes generate technical reports as well as log errors found during the loading process according to specification.

Quantitative Benefit

The new data warehouse can handle ten times more data than their current database.
The new process allows continuous loads every fifteen minutes, compared to the day-long delay of the previous system.