To 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.
- Prepare CSV file
- Create tables in SQL
- Import CSV file into SQL
- Revenue increased by 28.8%
- Overall Revenue is 57M
- Total Interest is 8M
- Total Transaction amount is 46M
- Male Customers are contributing more to revenue with 31M, while female customer contibute 26M
- 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%