This project involves analyzing credit card transaction data using SQL and visualizing the insights using Power BI. The main objectives are to understand spending patterns, detect trends, and generate a comprehensive report on credit card usage.
SQL Scripts: Contains SQL scripts for data cleaning, transformation, and querying. Power BI Dashboard: Visual representation of the analysis.
The project uses two main tables:
credit_card.csv :- Credit Card Details customer.csv :- Credit Card Customer Details
The Power BI dashboard provides a visual representation of the data, showcasing various metrics and trends. Key components of the dashboard include:
Revenue Metrics: Overall revenue, total interest, income, and more. Customer Demographics: Breakdown by education level, age group, income category, marital status, and more. Geographical Insights: Top 5 states contributing to revenue. Credit Card Categories: Performance of different card categories (e.g., Blue, Silver, Gold, Platinum).