Style Sampler

Layout Style

Patterns for Boxed Mode

Backgrounds for Boxed Mode

Search News Posts

  • General Inquiries 1-888-555-5555

  • Support 1-888-555-5555

anaplatform Data Consultancy
Customer Segmentation

We are with you in your Digital Transformation Journey with our advanced customer analytics

Customer Segmentation

Demonstration for Customer Segmentation

Case Study 1 - Portfolio Return Calculation

This case requires to develop a customer segmentation to give recommendations like saving plans, loans, wealth management, etc. on target customer groups.

Data Description

The sample Dataset summarizes the usage behavior of about 9000 active credit card holders during the last 6 months. The file is at a customer level with 18 behavioral variables.

Data :

Following is the Data Dictionary for customer's credit card dataset :-

CUSTID : Identification of Credit Card holder (Categorical)
BALANCE : Balance amount left in their account to make purchases
BALANCEFREQUENCY : How frequently the Balance is updated, score between 0 and 1 (1 = frequently updated, 0 = not frequently updated)
PURCHASES : Amount of purchases made from account
ONEOFFPURCHASES : Maximum purchase amount done in one-go
INSTALLMENTSPURCHASES : Amount of purchase done in installment
CASHADVANCE : Cash in advance given by the user
PURCHASESFREQUENCY : How frequently the Purchases are being made, score between 0 and 1 (1 = frequently purchased, 0 = not frequently purchased)
ONEOFFPURCHASESFREQUENCY : How frequently Purchases are happening in one-go (1 = frequently purchased, 0 = not frequently purchased)
PURCHASESINSTALLMENTSFREQUENCY : How frequently purchases in installments are being done (1 = frequently done, 0 = not frequently done)
CASHADVANCEFREQUENCY : How frequently the cash in advance being paid
CASHADVANCETRX : Number of Transactions made with "Cash in Advanced"
PURCHASESTRX : Numbe of purchase transactions made
CREDITLIMIT : Limit of Credit Card for user
PAYMENTS : Amount of Payment done by user
MINIMUM_PAYMENTS : Minimum amount of payments made by user
PRCFULLPAYMENT : Percent of full payment paid by user
TENURE : Tenure of credit card service for user

DATE

CAC

DAX

DJI

SP

FTSE

NIKKEI

NASDAQ

VIX

04.01.2010

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29

05.01.2010

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29

06.01.2010

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29

07.01.2010

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29

08.01.2010

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29

...

...

...

...

...

...

...

...

...

08.01.2022

4013,96

6048,29

10583,95

4013,96

6048,29

10583,95

4013,96

6048,29


It shows the status of the S&P 500 stock index published by Standard & Poor's.


Click on Calculate Return button to see portfolio return results and maximum benefit.



Case Study 2 - Portfolio Return Calculation with Multiple Regression

In this case study, Prediction modeling was done with Multivariate regression.


Click on the calculate button to see the portfolio return result!





Result:


Case Study - Access to Financial Data

As an example, downloading financial data from Yahoo Finance and investing.com via Python for company A is shown.