This is a complete end-to-end data analytics project using SQL + Power BI to analyze credit card customer data. It simulates a real-world business use case with financial KPIs, customer segmentation, and actionable insights.
- Connected SQL output to Power BI Desktop
- Created interactive dashboards using slicers, visuals, KPIs, and custom DAX measures
- Generated insights into customer behavior, revenue trends, and delinquency
- 📈 Revenue growth in Week 53: +28.8%
- ✅ Activation rate: 57.5%
⚠️ Delinquency rate: 6.06%- 🏦 Total Revenue: 57M | Total Interest: 8M | Transactions: 46M
- 💳 93% revenue from Blue & Silver cardholders
- 👔 Top job segment: Businessmen (18M)
- 🎓 Highest revenue by education: Graduates (23M)
- 🏙️ TX, NY, CA contributed 68% of total revenue
- 🔥 Top spending categories: Bills, Entertainment, Fuel
| Area | Tools / Concepts |
|---|---|
| Data Extraction | SQL (joins, filtering, select statements) |
| Data Modeling | Power BI Relationships, Star Schema |
| Visualization | Power BI (Bar, Line, Matrix, Cards, Filters) |
| Calculations | DAX (KPIs, custom measures) |
| Business Analysis | Customer segmentation, financial trends |
