To develop an interactive and comprehensive, weekly Credit Card dashboard designed to deliver real-time insights into key performance metrics and trends, thereby enabling stakeholders to monitor and analyze credit card operations effectively.
- Week-on-Week Revenue Change: Revenue increased by 28.8%
- Overall Revenue generated: 57M
- Total Interest earned: 8M
- Total Transaction amount: 46M
- Male customers make a greater contribution to the revenue (31M) than female customers(25M)
- Blue and Silver Credit Card holders are contributing to 93% of the overall transactions.
- TX, NY & CA states have contributed around 68% to the overall revenue.
- Overall delinquency rate is 6.06%
Click here to view the SQL queries
Click here to view the Credit Card Customer Dashboard
Click here to view the Credit Card Transactions Dashboard