Kennedy-Nkoana/credit-card-performance-dashboard

End-to-end credit card analytics project using PostgreSQL and Tableau with South African regional analysis # credit-card-performance-dashboard End-to-end credit card analytics project using PostgreSQL and Tableau with South African regional analysis # Credit Card Performance Dashboard ## Overview This project analyses credit card performance using South African transactional data. It covers revenue, profitability, customer activity, regional performance, and card product analysis. ## Tools Used - PostgreSQL: data modelling, transformations, and views - Tableau: interactive dashboards and visual analytics - GitHub: version control and documentation ## Data Model The project is built on five PostgreSQL views: - KPI View - Monthly Performance View - Province Performance View - Card Type Performance View - Base Transaction View ## Key Insights - Provincial revenue and profit distribution across South Africa - Monthly revenue and profit trends - Performance comparison by card type - Transaction amount distribution and customer behaviour - Interactive filtering driven by province selection ## Dashboard Features - Province map acts as a global filter - KPIs dynamically update based on selected region - Time series and segmentation visuals respond to user interaction ## How to Run 1. Load CSV files into PostgreSQL 2. Execute SQL scripts in the sql folder 3. Open the Tableau workbook in the tableau folder ## Author Kennedy Nkoana