Alteryx Case Studies RCI Bank and Services' Transformation in Data Management with Alteryx

Edit This Case Study Record

	RCI Bank and Services' Transformation in Data Management with Alteryx Alteryx

RCI Bank and Services' Transformation in Data Management with Alteryx

Alteryx

Technology Category	Analytics & Modeling - Data-as-a-Service Analytics & Modeling - Predictive Analytics
Applicable Industries	Automotive Finance & Insurance
Applicable Functions	Quality Assurance Sales & Marketing
Use Cases	Fraud Detection Inventory Management
Services	Data Science Services
Challenge	RCI Bank and Services, the financial services brand of the Renault Group, was facing challenges in data management and digitization. The company was using Microsoft Excel for pricing, risk calculation, sales forecasts, results forecasting, and debt recovery. This limited their capacity for innovation and the implementation of new projects. They also had multiple solutions in place, including an SAS-trained credit scoring tool, an Oracle data warehouse, an ad hoc ERP, Business Objects for operational BI reporting, and SalesForce as a CRM tool, plus SAP for accounting. The company also had some in-house applications for ETL and web analytics. However, the data from all these tools was dispersed, preventing the RCI team from working consistently. Read More
About Customer	RCI Bank and Services is the financial services brand of the Renault Group. This French multinational operates in the automotive industry and is a result of the Renault-Nissan Alliance, which includes several other brands including Renault, Dacia, Nissan, and Infiniti. With over 50 years in the automotive-specific financial products and services sector, RCI supports dealers in sales processes where company brands need financing. RCI has developed a strategy of diversifying its offering, adapting to the actual requirements of its customers, guaranteeing the highest quality standards and after-sales satisfaction. They offer their services to individuals and companies that want to take advantage of the credit facilities and financing available. Read More
Solution	RCI Bank and Services decided to implement Alteryx, a data management tool, after seeing its capabilities in a use case from the Management Control Department. Alteryx simplified workflow management and the creation of new workflow tasks, reducing the generation of long lines of code by simply clicking and dragging a box. The main users of Alteryx technology are the Data Team and the Risk Department, as well as people who work on the most complex projects. The implementation of Alteryx democratized ETL tools and Data Science in general, which was previously inaccessible for many people. The technology unified data and made it easily accessible to all departments in the organization. As a result, the company became 10 times more agile and adopted a flexible working methodology that increased productivity. RCI went from using 5 data applications to managing more than 30 in parallel. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Analytics & Modeling - Predictive Analytics

Applicable Industries

Automotive

Finance & Insurance

Applicable Functions

Quality Assurance

Sales & Marketing

Use Cases

Fraud Detection

Inventory Management

Services

Data Science Services

Challenge

RCI Bank and Services, the financial services brand of the Renault Group, was facing challenges in data management and digitization. The company was using Microsoft Excel for pricing, risk calculation, sales forecasts, results forecasting, and debt recovery. This limited their capacity for innovation and the implementation of new projects. They also had multiple solutions in place, including an SAS-trained credit scoring tool, an Oracle data warehouse, an ad hoc ERP, Business Objects for operational BI reporting, and SalesForce as a CRM tool, plus SAP for accounting. The company also had some in-house applications for ETL and web analytics. However, the data from all these tools was dispersed, preventing the RCI team from working consistently.

About Customer

RCI Bank and Services is the financial services brand of the Renault Group. This French multinational operates in the automotive industry and is a result of the Renault-Nissan Alliance, which includes several other brands including Renault, Dacia, Nissan, and Infiniti. With over 50 years in the automotive-specific financial products and services sector, RCI supports dealers in sales processes where company brands need financing. RCI has developed a strategy of diversifying its offering, adapting to the actual requirements of its customers, guaranteeing the highest quality standards and after-sales satisfaction. They offer their services to individuals and companies that want to take advantage of the credit facilities and financing available.

Solution

RCI Bank and Services decided to implement Alteryx, a data management tool, after seeing its capabilities in a use case from the Management Control Department. Alteryx simplified workflow management and the creation of new workflow tasks, reducing the generation of long lines of code by simply clicking and dragging a box. The main users of Alteryx technology are the Data Team and the Risk Department, as well as people who work on the most complex projects. The implementation of Alteryx democratized ETL tools and Data Science in general, which was previously inaccessible for many people. The technology unified data and made it easily accessible to all departments in the organization. As a result, the company became 10 times more agile and adopted a flexible working methodology that increased productivity. RCI went from using 5 data applications to managing more than 30 in parallel.

Impact #1	The implementation of Alteryx technology has led to a qualitative leap for RCI in terms of data management, complex predictive modeling, and staff resource optimization. For example, RCI receives around 200,000 emails every year. With Alteryx, a connection with SFDC was established and using certain keywords, a predictive model was created. The company is now able to classify the emails into 40 categories with a 90% success rate. The company also increased automatic credit acceptance by applying Alteryx-trained predictive logistic regression models. This has had a significant impact on the company’s efficiency and on its budget. Finally, the company has reduced manual checks in a big way, thanks to the fraud detection model. With these time savings, agents have reduced fraud by 40%. This also has a major impact on the cost of risk, which has now decreased by approximately 30%, saving several million Euros per year and significantly increasing net revenue.

Impact #1

The implementation of Alteryx technology has led to a qualitative leap for RCI in terms of data management, complex predictive modeling, and staff resource optimization. For example, RCI receives around 200,000 emails every year. With Alteryx, a connection with SFDC was established and using certain keywords, a predictive model was created. The company is now able to classify the emails into 40 categories with a 90% success rate. The company also increased automatic credit acceptance by applying Alteryx-trained predictive logistic regression models. This has had a significant impact on the company’s efficiency and on its budget. Finally, the company has reduced manual checks in a big way, thanks to the fraud detection model. With these time savings, agents have reduced fraud by 40%. This also has a major impact on the cost of risk, which has now decreased by approximately 30%, saving several million Euros per year and significantly increasing net revenue.

Benefit #1	+30% credit automatically accepted
Benefit #2	200,000 emails automatically managed with a 90% hit rate
Benefit #3	-50% reduction in fraud

Benefit #1

+30% credit automatically accepted

Benefit #2

200,000 emails automatically managed with a 90% hit rate

Benefit #3

-50% reduction in fraud

Download PDF Version

Overview

RCI Bank and Services' Transformation in Data Management with Alteryx

Operational Impact

Quantitative Benefit