About Project

The purpose of this project is to analyze the ATM transaction data for AYZ Bank to gain insights on customer behavior, ATM usage, and identify opportunities to improve the bank's services.

AYZ Bank wants to answer several business problem questions related to its ATM transactions data, which include:

1. What is the average transaction amount by location and transaction type?

2. Which ATM location has the highest number of transactions per day, and at what time of the day do the transactions occur most frequently?

3. Which age group has the highest number of transactions, and which transaction type do they usually perform?

4. What is the trend of transaction volume and transaction amount over time, and are there any seasonal trends or patterns?

5. What is the most common transaction type, and how does it vary by location and customer type (Wisabi customer vs. non-Wisabi customer)?

6. What is the average transaction amount and transaction frequency per customer by occupation and age group?

7. What is the percentage of transactions that are withdrawals, savings, balance enquiries, and transfers, and how does it vary by location and time of day?

8. What is the distribution of transaction amounts and transaction frequency, and are there any outliers?

9. Which ATM locations have the highest and lowest utilization rates, and what factors contribute to this utilization rate?

10. What is the average transaction time by location, transaction type, and time of day, and how does it vary by customer type and occupation?

Business Problem

PowerBI Interactive Dashboard

Data Visualization

Real-time Insights

User-friendly Interface

• Analyze the ATM transaction data and generate reports and visualizations that show the most popular ATM locations and transaction types by time of day, day of week, and month.

• Calculate the average transaction amount per customer and per ATM location.

• Analyze the number of transactions and transaction amounts by customer age group, gender, and occupation.

• Analyze the distribution of transaction types by customer type (Wisabi customers vs. customers of other banks).

• Analyze the impact of public holidays and weekends on ATM usage and transaction patterns.

• Analyze the frequency and amounts of transfers between accounts and between different banks.

• Evaluate the performance of each ATM location in terms of uptime, maintenance issues, and customer satisfaction.

• Identify outliers and anomalies in the transaction data.

Business Requirements

Deliverables

• A report containing insights on customer demographics, transaction patterns, and popular ATM services.

• A dashboard with visualizations that provide an overview of Wisabi Bank's ATM transactions and highlight key insights.

• Recommendations for improving the bank's operations based on the findings from the analysis.

Contact Me