Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Use Cases

Read Alteryx customer stories to learn how they transform their organizations into becoming a data-driven business.

Creating Customer Value Score for Credit Card Business

Rami
5 - Atom
ncb logo.png
Overview of Use Case

The National Commercial Bank (NCB) is a prominent Saudi Arabian bank and the leading financial institution in the region. The bank is considered the largest and the first to officially be licensed and to operate in Saudi Arabia. In the Credit Card department we want to optimize our high volume data, cluster customers, deliver better products and campaigns. Alteryx impacts analytics in the organization and helps deliver new profitability model outcomes for the credit card business.

 
Describe the business challenge or problem you needed to solve

A wide range of analytical outputs are required in order to manage and drive the decision making process in the credit cards business. Data prep and dataset building are considered cornerstones for the analytics team. The starting point is to flag certain behavioral transactions (e.g. Merchant industry + Local/international). Blending/combining the data is the second part. We link different datasets based on one/multiple common variables producing the desired output.

 

We want to understand our customer’s behavior to provide better campaigns that fit their needs, so we decided to optimize our data. Initially, blending and optimizating several data sources and formats, in a clear and fast model, was a challenge. On the other hand, the market demands are changing as customer’s behavior is changing due to COVID-19. So this model will help us prepare the campaign faster. By knowing the target customer based on behavior, we are trying to increase the credit card transactions to generate more profit.

 

In the banking industry the alignment must be done between many stakeholders due to the catastrophic effect a wrong decision may have since we’re subject to SAMA regulations, Banking industry best practices, Anti-money laundry law, local and applicable international laws. Therefore, the stakeholders include, Risk, compliance, Customer Care, Marketing, Portfolio team, Finance, IT, MIS etc.

 
Describe your working solution

Initially, the Portfolio team and I built a Scoring matrix that gives each customer a score and we can know the valuable customers. Also in a high level, we have seven customer categories. 

 

Based on the matrix, I used two datasets, customer and transactions, both files are CSV format. I started to work in Alteryx Designer cleansing the data and building the model. 

 

  1. Forecasting potential impacts of a decision under different variables or different scenarios.
  2. Building Customer Value Scoring model allowing the business to assess the feasibility of utilizing a business opportunity.
  3. Cost optimization analysis and comparing it against customer fire back complaints.

Bands.png

 

WorkFlow.png

 

 

 
Describe the benefits you have achieved

Alteryx increases productivity and delivers accuracy. There are some main benefits from using the platform:

  • Saving money: Building such a model usually costs a lot of money, by outsourcing such activity. 
  • Saving Time: Because it's code-free it saved our time. I built this model within three days.
  • Quality: Alteryx makes the modelling process very easy and clear, seeing each steps in the analysis process makes data modelling quality accurate.
  • Return-on-investment: By running and extracting the data in a short period of time we can go live with a segmented campaign and that will impact our revenue positively.
 
Related Resources
 
Attachments
No ratings
Comments
KarenHays
Alteryx Alumni (Retired)

Thank you for sharing this great use case @Rami -- it highlights what so many bank organizations are looking to do in an effort to better understand their customer base.