ABOUT THE PROJECT

This project focused on developing an interactive Power BI dashboard to segment customers based on risk tier, utilization ratio and payment history. The analysis identified high-risk segments, early-warning indicators of default, and opportunities for targeted retention. Delivered actionable recommendations for reducing credit losses while maximizing value from moderate-risk customers

PROJECT TOOLS, SKILLS AND ACTIVITIES

- Analyzed and prepared customer dataset. - Segmented customers to identify risk groups. - Created calculated metrics such Customer Risk Tier for effective segmentation. - Designed clear visualizations; heatmaps, clustered columns, risk matrices, and KPI cards to highlight important details and high-risk segments. - Integrated customer lifetime value (CLV) to identify high-risk yet high-value customers. - Communicated findings effectively to support decision-making and executive understanding. - Developed actionable business insights and recommendations for risk mitigation and credit management. - Used Power BI for interactive reporting with filters.

PROJECT LINKS