💰 Case Study #4 - Data Bank 💰
This repository contains solutions to the 4th challenge (Week 4) of the 8 Weeks SQL Challenge by Danny Ma. Click here to view the full challenge.
🧾 Table of Contents
- Business Case
- Entity Relationship Diagram
- Available Data
- Case Study Solutions
- Extra Resources
Business Case In the evolving financial industry, a new innovation known as Neo-Banks has emerged. These are digital-only banks without physical branches.
Danny envisioned a synergy between these modern banks, cryptocurrency, and the data sector, thus initiating a new venture - Data Bank!
Data Bank operates like any other digital bank but with a unique twist: it also serves as the world’s most secure distributed data storage platform. Customers are given cloud data storage limits directly tied to their account balances. This business model has some unique aspects, and the Data Bank team seeks your expertise!
The management team at Data Bank aims to expand their customer base while effectively tracking and predicting the data storage needs of their customers. This case study focuses on calculating metrics, understanding growth, and enabling the business to analyze their data intelligently to forecast and plan for future growth.
Entity Relationship Diagram [Include your Entity Relationship Diagram here]
Available Data All datasets are available in the database schema provided.
Case Study Solutions
- Part A - Customer Nodes Exploration
- Part B - Customer Transactions
- Part C - Data Allocation Challenge
Extra Resources
Feel free to customize further if there are specific details or sections you'd like to add or adjust!