Customer Analysis and Risk Assessment

Summary

Report submitted for Onyx Data DataDNA ZoomCharts Mini Challenge, December 2024. The report is based on the Aurora Bank dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.

Author's description:

This report delivers comprehensive insights into customer demographics, including gender, age group, merchant details, merchant cities, and card brands utilized in transactions. It evaluates patterns in the most commonly used card brands and types, pin change behaviors, card expiry trends, and the distribution of cards issued to clients over the years. Additionally, the report explores transaction behaviors, identifies common errors, and analyzes the average transaction amounts across different merchant categories. Further analysis highlights customers' financial profiles, focusing on debt levels, credit limits, annual income, and error ratings to uncover critical trends and opportunities.