To develop a comprehensive credit card dashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations effectively.
The project entails importing data from a CSV file into a MySQL database and then using Power BI to create dashboards that visualize key performance indicators (KPIs) and insights. The project contains two PowerBI dashboards-
- Credit Card Transaction Report: showing transactional data, providing insights on total revenue, interest, quaterly revenue trends and week-on-week growth
- Credit Card Customer Report: showing customer demographics, the dashboard allows you to explore customer data filtered by gender from age distribution to income analysis, it offers valuable insights into customer behavior
from Week 1 (1st Jan 2023) to Week 52 (24 Dec 2023)
- Overall Revenue is 55M
- Total Interest is 7.84M
- Total Tranasction Amount is 45M
- Male customers are contributing more in revenue 30M, female 25M
- Blue & Silver credit card are contributing to 93% of overall transactions
- TX, NY & CA is contributing to 68%
- Overall Activation rate is 57.5%
- Overall Delinquent rate is 6.06%