Harikrishnan-Nair/PowerBI-ATM-Transaction-Analysis-Project

PowerBI project about building an interactive dashboard to understand, analyse and gain insights from the transactional data of bank ATMs of four states in Africa # PowerBI-ATM-Transaction-Analysis-Project This project is about building an interactive dashboard to understand, analyse and gain insights from the transactional data of ATMs of bank situated at different locations. The insights so obtained will help to improve bank's service delivery to the customer and also help to identify areas of scope for improvement The dataset can be accessed through link:drive.google.com It consists of data related to transactions(of 5 states in Africa), customers, ATM location, calender, transaction type, hour data. All the these data were loaded to the PowerBI and few new columns were calculated folowing which the models were loaded and visuals were created. The visuals so created will garner to the bank managements queries raised and also help them to perform better decisions based on the data. Some of the key insights and recommendations are as below Key Insights: 1. Utilization rate of ATMs is the highest in Kano (18.55%) and lowest in Federal Capital territory (8.46%) 2. Withdrawal (56%) and Transfer (22%) constitute the major proportion of ATM transactions 3. March 2022 witnessed the highest volume of transaction and the transaction amount peaked during this month. This might be due any special occasion, festival, holiday, or any other public event where this is chance of spike in spending 4. The transaction count plotted against the hour axis show an uptick in transaction count from 6.00am onwards which rises and remains almost the same until 2pm. Following 2 o clock there is sudden surge in the transaction which sustains until 6.00pm and further that the count tanks down 5. Some trend is observed in the pattern of transaction count vs month over the period of entire year. Starting from January the count starts on higher value and tanks in February, again the count increase in March and tanks in April. This might be since some customers are preferring to withdraw money co …