Customer Base Global Retail Bank

A synthetic dataset that contains demographic, and financial KPIs

@kaggle.charlottetu_customer_base_global_retail_bank

Table List

2 tables(3.58 MB)

Cube V2

@kaggle.charlottetu_customer_base_global_retail_bank.cube_v2

1.85 MB
497664 rows
23 columns

market Market	proposition Proposition	primary Primary	tenure Tenure	age Age	international International	ca CA	card Card	insurance Insurance	investment Investment	mortgage Mortgage	nps NPS	digital Digital	numcust Numcust	trb TRB	revenue Revenue	primary_cust Primary Cust	digital_cust Digital Cust	ins_holders Ins Holders	inv_holders Inv Holders	mort_holders Mort Holders
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	N	1. Promoter	1. Digitally active	10	90000	1500	10	10	10
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	N	2. Passive	1. Digitally active	10	90000	1500	10	10	10
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	N	3. Detractor	1. Digitally active	8	72000	1200	8	8	8
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	Y	1. Promoter	1. Digitally active	8	72000	1200	8	8	8		8
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	Y	2. Passive	1. Digitally active	10	90000	1500	10	10	10		10
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	Y	3. Detractor	1. Digitally active	10	90000	1500	10	10	10		10
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	1. Promoter	1. Digitally active	8	72000	1200	8	8	8	8
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	2. Passive	1. Digitally active	8	72000	1200	8	8	8	8
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	3. Detractor	1. Digitally active	10	90000	1500	10	10	10	10
AUH	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	Y	1. Promoter	1. Digitally active	8	72000	1200	8	8	8	8	8


CREATE TABLE cube_v2 (
  "market" VARCHAR,
  "proposition" VARCHAR,
  "primary" VARCHAR,
  "tenure" VARCHAR,
  "age" VARCHAR,
  "international" VARCHAR,
  "ca" VARCHAR,
  "card" VARCHAR,
  "insurance" VARCHAR,
  "investment" VARCHAR,
  "mortgage" VARCHAR,
  "nps" VARCHAR,
  "digital" VARCHAR,
  "numcust" BIGINT,
  "trb" BIGINT,
  "revenue" BIGINT,
  "primary_cust" BIGINT,
  "digital_cust" BIGINT,
  "ca_holders" BIGINT,
  "card_holders" BIGINT,
  "ins_holders" BIGINT,
  "inv_holders" BIGINT,
  "mort_holders" BIGINT
);