About this Dataset

Market Segmentation In Insurance Unsupervised

WHAT IS MARKET SEGMENTATION?

In marketing, market segmentation is the process of dividing a broad consumer or business market, normally consisting of existing and potential customers, into subgroups of consumers based on some type of shared characteristics.

Objective :

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

Dataset

The sample Dataset summarizes the usage behavior of about 9000 active credit cardholders during the last 6 months. The file is at a customer level with 18 behavioral variables.
Variables of Dataset
Balance
Balance Frequency
Purchases
One-off Purchases
Installment Purchases
Cash Advance
Purchases Frequency
One-off Purchases Frequency
Purchases Installments Frequency
Cash Advance Frequency
Cash Advance TRX
Purchases TRX
Credit Limit
Payments
Minimum Payments
PRC Full payment
Tenure
Cluster

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

Tables

Customer Data

@kaggle.jillanisofttech_market_segmentation_in_insurance_unsupervised.customer_data

541.93 KB
8950 rows
18 columns


CREATE TABLE customer_data (
  "cust_id" VARCHAR,
  "balance" DOUBLE,
  "balance_frequency" DOUBLE,
  "purchases" DOUBLE,
  "oneoff_purchases" DOUBLE,
  "installments_purchases" DOUBLE,
  "cash_advance" DOUBLE,
  "purchases_frequency" DOUBLE,
  "oneoff_purchases_frequency" DOUBLE,
  "purchases_installments_frequency" DOUBLE,
  "cash_advance_frequency" DOUBLE,
  "cash_advance_trx" BIGINT,
  "purchases_trx" BIGINT,
  "credit_limit" DOUBLE,
  "payments" DOUBLE,
  "minimum_payments" DOUBLE,
  "prc_full_payment" DOUBLE,
  "tenure" BIGINT
);