Executive Summary
This project aims to conduct a comprehensive analysis of ATM transaction data for Wisabi Bank, with the objective of deriving actionable insights into customer behavior, ATM utilization patterns, and strategic opportunities for service enhancement.
Stakeholders
- Wisabi Bank Executive Leadership: Responsible for strategic oversight and decision-making based on analytical insights.
- ATM Operations Manager: Accountable for the implementation of recommendations to enhance ATM performance metrics.
- Branch Managers: Utilize insights to augment customer experience and streamline branch-level operations.
- Data Analytics Team: Charged with data extraction, transformation, analysis, and the generation of detailed reports and visual dashboards.
- IT Department: Ensures secure data access, integrity, and compliance with data protection protocols.
Business Objectives
- Demographic Analysis: Profile Wisabi Bank’s customer base and analyze transaction patterns across multiple locations.
- Service Utilization Trends: Identify high-demand ATM services and assess usage trends over time.
- Growth Opportunities: Uncover potential avenues for service expansion and enhancement based on customer transaction data.
- Operational Efficiency: Pinpoint areas for operational optimization to enhance overall service delivery.
- Scope of Work:
- The project encompasses a detailed analysis of ATM transactions from January 1st, 2022, to December 31st, 2022, focusing on Wisabi Bank’s branches in Lagos, Kano, Rivers State, Enugu, Rivers, and FCT Abuja.
Business Requirements
- Transactional Insights: Generate comprehensive reports and visualizations illustrating ATM usage patterns by location, time of day, day of week, and month.
- Transaction Analysis: Compute average transaction amounts at the customer and ATM location levels.
- Customer Segmentation: Analyze transactions segmented by customer demographics (age, gender, occupation).
- Service Distribution: Evaluate transaction types across Wisabi customers versus customers from other banks.
- Temporal Impact Analysis: Assess the impact of public holidays and weekends on transaction volume and patterns.
- Interbank Transfers: Analyze the frequency and amounts of account transfers within Wisabi Bank and to other banks.
- ATM Performance Metrics: Evaluate ATM uptime, maintenance records, and customer satisfaction scores.
- Anomaly Detection: Identify and report outliers and anomalies in transaction data.
Deliverables
- Insight Report: Detailed report encompassing customer demographics, transaction patterns, and ATM service usage.
- Interactive Dashboard: A comprehensive dashboard providing visual analytics of ATM transactions with key insights highlighted.
- Strategic Recommendations: Proposals for operational enhancements derived from data analysis findings.
Assumptions
- Data integrity and completeness are assured.
- Data is stored in a secure relational database.
- Data is pre-processed and cleaned of inconsistencies.
- Secure data access protocols are in place.
- Project completion within a six-week timeframe.
Constraints
- Restricted data access to authorized personnel only.
- No modifications or alterations to the data.
- Adherence to data privacy regulations.
- Strict adherence to the project timeline and budget.
Project Timeline
- Week 1: Data acquisition and preprocessing.
- Weeks 2-3: Detailed data analysis and visualization.
- Week 4: Presentation of initial findings to Wisabi Bank stakeholders.
- Weeks 5-6: Development of the interactive dashboard, preparation of the final report, and presentation.