Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Success Stories

Learn how Alteryx customers transform their organizations using data and analytics.
STORIES WANTED

Showcase your achievements in the Maveryx Community by submitting a Success Story now!

SUBMISSION INSTRUCTIONS

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