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

Edit This Case Study Record

	Extending a Data Warehouse, Building a Relationship for the Future CloverDX

Extending a Data Warehouse, Building a Relationship for the Future

CloverDX

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	Improved performance of the data warehouse.
Impact #2	Continuous loads every fifteen minutes, keeping the data readily available to customers in near real-time.
Impact #3	Updated and enhanced fact and dimension tables in the newly designed data warehouse with many new validation rules.

Impact #1

Improved performance of the data warehouse.

Impact #2

Continuous loads every fifteen minutes, keeping the data readily available to customers in near real-time.

Impact #3

Updated and enhanced fact and dimension tables in the newly designed data warehouse with many new validation rules.

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

Benefit #1

The new data warehouse can handle ten times more data than their current database.

Benefit #2

The new process allows continuous loads every fifteen minutes, compared to the day-long delay of the previous system.

Download PDF Version

Overview

Extending a Data Warehouse, Building a Relationship for the Future

Operational Impact

Quantitative Benefit