Name: Customer Base Global Retail Bank
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Customer Base Global Retail Bank

Context

Working in a global bank, we need to be able to quickly get our hands on the number of customers across each of our key markets, for specific dimensions. Whilst of course we can't share the real data, I built a fully synthetic dataset as the base for a Dash application.

Content

The data is aggregated, i.e. there are multiple customers per row. Dimensions tend to be earlier columns, measures to the right.

Tables

Cube

@kaggle.charlottetu_customer_base_global_retail_bank.cube

1.82 MB
497,664 rows
27 columns

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: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "n_2" VARCHAR  -- 2
);

Cube V2

@kaggle.charlottetu_customer_base_global_retail_bank.cube_v2

1.94 MB
497,664 rows
23 columns

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
);