Download PDF

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

RCI Bank and Services' Transformation in Data Management with 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

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

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

Operational Impact

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.

Quantitative Benefit