Develop a comprehensive credit card weekly dashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations effectively.
- Prepared CSV file
- Built a Database
- Created Tables in SQL
- Imported CSV file into SQL
- Imported Data into PowerBi from SQL Database
- Performed Data Cleaning Process
- Wrote Dax function for generating Kpis
- Developed Dashboard
WoW change:
- Revenue increased by 28.8%,
- Total Transaction Amt. & Count increased by 2.22% and 1.74% than the previous week
- Customer count increased by 1.80%
Overview YTD:
- Overall revenue is 56.5M
- Total interest is 8M
- Total transaction amount is 46M
- Male customers are contributing more in revenue
- Blue & Silver credit cards are contributeing 93% of the overall transaction
- TX, NY, CA are contributing 73%
- Overall Activation rate is 57.46%
- Overall Delinquent rate is 6.06%