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

@kaggle.charlottetu_customer_base_global_retail_bank.cube

1.73 MB
497664 rows
27 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
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	N	1. Promoter	1. Digitally active	2	18000	300	2	2	2
UK	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
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	N	3. Detractor	1. Digitally active	10	90000	1500	10	10	10
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	N	Y	1. Promoter	1. Digitally active	10	90000	1500	10	10	10		10
UK	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
UK	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
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	1. Promoter	1. Digitally active	10	90000	1500	10	10	10	10
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	2. Passive	1. Digitally active	10	90000	1500	10	10	10	10
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	N	3. Detractor	1. Digitally active	8	72000	1200	8	8	8	8
UK	3. Bronze	1. Primary	2. 1 - 3 years	2. 25 - 35	2. Domestic	N	N	Y	Y	Y	1. Promoter	1. Digitally active	10	90000	1500	10	10	10	10	10


CREATE TABLE cube (
  "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" DOUBLE,
  "trb" BIGINT,
  "revenue" DOUBLE,
  "primary_cust" DOUBLE,
  "digital_cust" BIGINT,
  "ca_holders" DOUBLE,
  "card_holders" DOUBLE,
  "ins_holders" DOUBLE,
  "inv_holders" DOUBLE,
  "mort_holders" DOUBLE,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "n_2" VARCHAR
);