📊 Introduction
Data Bank is a pioneering digital-only Neo-Bank at the intersection of banking, cryptocurrency, and data storage. Unlike traditional banks, Data Bank operates online, offering customers a seamless, modern experience. Its unique model sets Data Bank apart: customers receive cloud data storage directly tied to their account balance. This innovative approach provides financial management and integrates the world's most secure distributed data storage platform, making Data Bank a leader in the evolving financial industry.
🎯 Objective
The main objective of this case study is to empower Data Bank's management team with actionable insights that will help them:
- Increase Customer Base: Develop strategies and identify key metrics to attract more customers to Data Bank’s innovative platform, ensuring sustained growth in a competitive market.
- Forecast Data Storage Needs: Accurately predict the future data storage requirements of customers based on their account balances and usage patterns, ensuring that Data Bank can efficiently manage its storage resources.
- Analyze Customer Behavior: Understand customer interactions with the platform, identifying trends and opportunities that can be leveraged to enhance customer satisfaction and retention.
- Optimize Business Model: Evaluate and refine the unique model of linking account balances to data storage limits, ensuring it remains both attractive to customers and profitable for Data Bank.
Overview of Database
In this project, we're exploring a unique dataset that encapsulates the operational activities of a new-age digital bank. Our data is segmented into three key tables, each providing a different perspective on the bank's operations:
- regions: This table categorizes geographical areas where customers are located. Each region has a unique identifier (
region_id) and a corresponding name (region_name).
- customer_nodes: This table tracks customer accounts or nodes within specific regions. It connects customers to regions and records the active duration of each node with
start_date and end_date.
- customer_transactions: This table logs individual transactions made by customers, including the date of the transaction (
txn_date), the type of transaction (txn_type), and the transaction amount (txn_amount).
A detailed preview of our Database
Case Study
🧩 Customer Nodes Exploration 🧩