willbmw/firstbank-ghana-analytics-dashboard

End-to-end banking analytics project using Python, Power BI and machine learning for customer risk scoring and business insights. # FirstBank Ghana Analytics Dashboard End-to-end banking analytics project using Python, Power BI and machine learning for customer risk scoring and business insights. ## Project Overview This project was developed as part of an IT Business Data Analyst internship context. The objective was to build a complete analytics workflow covering dataset generation, feature engineering, business intelligence dashboards, and predictive modeling. The project uses a synthetic but realistic banking dataset representing: - 50,000 clients - 750,000 transactions - Client accounts, cards, loans, incidents, advisors and branches - Customer segmentation, risk indicators and predictive scoring ## Main Deliverables - Synthetic banking dataset generation with Python - Enriched client-level, branch-level and monthly feature tables - Power BI dashboard with 4 analytical pages - Predictive risk scoring using machine learning - Model comparison between Logistic Regression, Random Forest and LightGBM - Final report with business insights and recommendations - Documented notebooks for dataset generation and predictive modeling ## Dashboard Structure ### Page 1 — Executive Overview Provides a high-level overview of the banking portfolio, including total clients, total balance, total transactions, average CLV, high-risk clients, low-activity clients, transaction trends, top customers by CLV and CLV distribution by segment. ### Page 2 — Risk & Inactivity Analysis Focuses on customer risk and inactivity using high overdraft usage, low-activity clients by city and branch type, customer segmentation and a risk customer watchlist. ### Page 3 — Advisor & Operations Performance Analyzes advisor portfolios, high-value client distribution, incidents by branch type and operational performance using slicers by segment, account type, branch type and year. ### Page 4 — Predictive Risk Scoring Integrates machine learning results into Power BI, including predicted risk segmentation, top predict …