💳 Credit Card Transaction & Customer Weekly Report 📊
Project's Objective: To develop a comprehensive credit card weekly dashboard which provides real-time insights to key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations more effectively.
Steps Followed:
- Data Collection: Collected credit card data to serve as the foundation for a thorough analysis.
- Data Cleaning: Ensured the data's accuracy and reliability by carefully cleaning and validating it using Excel and MySQL.
- Data Modeling: Created a strong data model to establish effective relationships between different data sets.
- Power Query: Used Power Query in Power BI to transform raw data into meaningful insights.
- DAX (Data Analysis Expressions): Utilized DAX to perform calculations and derive valuable insights from the data.
- Measures: Developed customized measures and calculations to uncover trends and patterns.
- Charts: Created visually engaging charts that clearly represent complex store data.
- Filters: Applied filters and slicers to allow users to explore data based on specific criteria.
Useful Insights:
- Overall revenue is 55.3M
- Total intrest is 8M
- Total transaction amount is 44.5M
- Male customers are contributing more in revenue 30M than females 25M
- Businessman's contribution to revenue is high 18M
- Blue and silver credit cards are contributing to 93% of overall transactions
-> Next Steps/Recommendation: After analyzing the data, it is observed that businessmen and self-employed individuals are more likely to be delinquent. It's important to investigate the underlying reasons for this trend.
Github Project: https://github.com/ramandk23/Credit_Card_Financial_Analysis/tree/main