Excel dashboards that detect anomalies, highlight high-risk transactions, and enable faster decision-making.

Tools: Excel · Pivot Tables · Financial Fraud Analytics · Data Visualization · VBA

Link to Project

https://drive.google.com/file/d/1eCfplHwC5olwhazhOs0K1GARt8w4zVnG/view?usp=sharing

Project Facts

• Tool: Excel (Power Query, Pivot, VBA)
• Dataset: Financial Transactions (~200K rows)
• Use Case: Fraud Detection / Risk Monitoring
• Deliverables: Dashboard + Automated Report

Outcomes

• Identified 80%+ fraud concentration in key transaction types
• Built real-time risk indicator
• Reduced manual analysis effort by ~50% (simulated)

Problem Statement

Financial teams struggle to quickly identify fraudulent transactions within large volumes of data. Static reports fail to surface high-risk activity in time, increasing exposure and response delays.

Solution Overview

I developed an interactive Excel-based fraud monitoring dashboard that surfaces key risk indicators and enables quick investigation.

Key Features:

• Dynamic KPI cards (Fraud %, Fraud Value, Volume)
• Fraud Risk Indicator (LOW / MEDIUM / HIGH)