Dataset: Wisabi Bank Dataset

About this Dataset

Wisabi Bank Dataset

This dataset provides a comprehensive view of transactions, ATM locations, cardholder details, transaction types, and temporal information for Wisabi Bank. It can be used to analyze transaction patterns, customer behavior, ATM usage, and explore correlations between various dimensions.

The dataset consists of transactional data captured in the Transactions Fact Table, which includes information such as transaction ID, start and end datetime, cardholder ID, location ID, transaction type ID, and transaction amount.
There are 5 transactional tables which can be unioned to provide a comprehensive view of the bank's ATM operations across all locations.
The unioned transaction table can then be joined to other dimension tables on common fields.

The Location Dimension Table provides details about ATM locations, including location ID, location name, number of ATMs, city, state, and country.
The Customers Dimension Table contains information about cardholders, such as cardholder ID, first name, last name, gender, ATM ID, age, occupation, account type, and whether they are customers of Wisabi Bank.
The Transaction Type Dimension Table defines different transaction types and their corresponding IDs and names.
The Hour Dimension Table captures hour-related details like the hour of the day, start and end times.
The Calendar Dimension Table contains date-related information, including date, quarter, month, month name, day, holiday status, day name, week of the year, year, and start of the month.

Check the Data Dictionary file for more information on this dataset.

Tables

Atm Location Lookup

@kaggle.obinnaiheanachor_wisabi_bank_dataset.atm_location_lookup

5.49 KB
50 rows
6 columns


CREATE TABLE atm_location_lookup (
  "locationid" VARCHAR,
  "location_name" VARCHAR,
  "no_of_atms" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR
);

Calendar Lookup

@kaggle.obinnaiheanachor_wisabi_bank_dataset.calendar_lookup

11.65 KB
365 rows
10 columns


CREATE TABLE calendar_lookup (
  "date" TIMESTAMP,
  "year" BIGINT,
  "month_name" VARCHAR,
  "month" BIGINT,
  "quarter" VARCHAR,
  "week_of_year" BIGINT,
  "end_of_week" TIMESTAMP,
  "day_of_week" BIGINT,
  "day_name" VARCHAR,
  "isholiday" BIGINT
);

Customers Lookup

@kaggle.obinnaiheanachor_wisabi_bank_dataset.customers_lookup

178.93 KB
8819 rows
9 columns


CREATE TABLE customers_lookup (
  "cardholderid" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "gender" VARCHAR,
  "atmid" VARCHAR,
  "birth_date" TIMESTAMP,
  "occupation" VARCHAR,
  "accounttype" VARCHAR,
  "iswisabi" BIGINT
);

Enugu Transactions

@kaggle.obinnaiheanachor_wisabi_bank_dataset.enugu_transactions

6.33 MB
350251 rows
7 columns


CREATE TABLE enugu_transactions (
  "transactionid" VARCHAR,
  "transactionstartdatetime" TIMESTAMP,
  "transactionenddatetime" TIMESTAMP,
  "cardholderid" VARCHAR,
  "locationid" VARCHAR,
  "transactiontypeid" BIGINT,
  "transactionamount" BIGINT
);

Fct Transactions

@kaggle.obinnaiheanachor_wisabi_bank_dataset.fct_transactions

3.45 MB
159652 rows
7 columns


CREATE TABLE fct_transactions (
  "transactionid" VARCHAR,
  "transactionstartdatetime" TIMESTAMP,
  "transactionenddatetime" TIMESTAMP,
  "cardholderid" VARCHAR,
  "locationid" VARCHAR,
  "transactiontypeid" BIGINT,
  "transactionamount" BIGINT
);

Hour Lookup

@kaggle.obinnaiheanachor_wisabi_bank_dataset.hour_lookup

3.13 KB
24 rows
3 columns


CREATE TABLE hour_lookup (
  "hour_key" BIGINT,
  "hour_start_time" VARCHAR,
  "hour_end_time" VARCHAR
);

Kano Transactions

@kaggle.obinnaiheanachor_wisabi_bank_dataset.kano_transactions

7.93 MB
458764 rows
7 columns


CREATE TABLE kano_transactions (
  "transactionid" VARCHAR,
  "transactionstartdatetime" TIMESTAMP,
  "transactionenddatetime" TIMESTAMP,
  "cardholderid" VARCHAR,
  "locationid" VARCHAR,
  "transactiontypeid" BIGINT,
  "transactionamount" BIGINT
);

Lagos Transactions

@kaggle.obinnaiheanachor_wisabi_bank_dataset.lagos_transactions

12.45 MB
755073 rows
7 columns


CREATE TABLE lagos_transactions (
  "transactionid" VARCHAR,
  "transactionstartdatetime" TIMESTAMP,
  "transactionenddatetime" TIMESTAMP,
  "cardholderid" VARCHAR,
  "locationid" VARCHAR,
  "transactiontypeid" BIGINT,
  "transactionamount" BIGINT
);

Rivers Transactions

@kaggle.obinnaiheanachor_wisabi_bank_dataset.rivers_transactions

7.38 MB
420098 rows
7 columns


CREATE TABLE rivers_transactions (
  "transactionid" VARCHAR,
  "transactionstartdatetime" TIMESTAMP,
  "transactionenddatetime" TIMESTAMP,
  "cardholderid" VARCHAR,
  "locationid" VARCHAR,
  "transactiontypeid" BIGINT,
  "transactionamount" BIGINT
);

Transaction Type Lookup

@kaggle.obinnaiheanachor_wisabi_bank_dataset.transaction_type_lookup

2.36 KB
4 rows
2 columns


CREATE TABLE transaction_type_lookup (
  "transactiontypeid" BIGINT,
  "transactiontypename" VARCHAR
);