Baselight

Wisabi Bank Dataset

This dataset contains ATM transactions data for Wisabi Bank

@kaggle.obinnaiheanachor_wisabi_bank_dataset

Loading...
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Share link

Anyone who has the link will be able to view this.