Task-3

SQL for Data Analysis Use SQL queries to extract and analyze data from a database.

🏦 Data Bank Case Study – SQL Analysis

This repository contains SQL scripts and analysis performed as part of Task 3 - Case Study of a Bank. The objective is to analyze customer transactions, nodes, and regional data to extract meaningful business insights using SQL.

---

📂 Files

• task 3 case study of bank.sql
  Contains all SQL queries used to explore and analyze the bank's customer and transaction data.

---

🧠 Case Study Objectives

The main goals of this case study include:

• Understanding customer transaction behaviors.
• Identifying regional patterns and customer distribution.
• Analyzing transaction types and customer engagement.
• Measuring node assignment and movement durations.

---

📊 Key Analyses

Some of the business questions answered using SQL:

1. How many nodes exist in each region?
2. How are customers distributed across regions?
3. What is the total transaction amount per region?
4. What is the average time a customer stays at a node?
5. How many customers make more than one deposit and at least one purchase or withdrawal in a month?
6. What is the average number and size of deposits per customer?
7. What is the unique count and total value for each transaction type?

---

🛠️ Tech Stack

• SQL: Core language for data querying and analysis

• Database Schema:

  • customer_transactions
  • customer_nodes
  • regions

  📌 Credits This project is part of a learning initiative/task to improve SQL analytics skills using real-world banking datasets.

📧 Contact If you have any questions, feel free to reach out:

GitHub: Abhijeet107

Email: abhijeet.kuanr@gmail.com

---

📝 How to Use

1. Clone the repository:

   git clone https://github.com/your-username/databank-sql-case-study.git