FraudScope is an interactive and visually rich Excel-based dashboard designed to analyze, monitor, and detect fraudulent transactions across different locations and merchants. Powered by SQL-processed data, the dashboard enables real-time insights into fraud patterns, helping analysts and stakeholders make data-driven decisions.
- 📍 Top & Bottom Fraud Locations
Instantly identify the highest and lowest fraud-prone areas. - 🚨 Fraud Detection Rate
Calculates overall detection efficiency based on flagged vs. confirmed frauds. - ✅ True Positives Analysis
Measure the performance of your rule engine by comparing flagged transactions with actual frauds. - 📊 Dynamic Pivot Filtering
Filter and drill down by Merchant, Location, or Fraud Rule for detailed insights. - 🎯 KPI Cards
Highlight key metrics like total transactions, fraud rates, and location-specific performance using conditional formatting and color coding.
| Tool | Purpose |
|---|---|
| Excel | Dashboard design, data modeling, and KPI visualizations |
| SQL | Data preprocessing and aggregation |
FraudScope-Dashboard/ ├── dashboard/ │ └── FraudScope_Dashboard.xlsx │ ├── scripts/ │ └── fraud_rules.sql │ └── README.md
This dashboard is ideal for:
- Financial Institutions monitoring fraud trends
- Analysts identifying fraud hotspots
- Auditors evaluating transaction-level risks
- Teams assessing rule engine performance
- Open
FraudScope_Dashboard.xlsx - Refresh the Pivot Tables if data is updated
- Use slicers and filters to explore trends by:
- Location
- Merchant
- Rules
- View KPIs for quick insights on fraud distribution
Contributions are welcome! If you'd like to enhance visuals, add automation, or include additional rule metrics, feel free to fork the repo and submit a pull request.
For queries or collaboration:
Adarsh Barnawal
📧 [adarshbarnawal841435@gmail.com]
🔗 [www.linkedin.com/in/adarshbarnawal16]
🚦 FraudScope helps you stop fraud before it spreads. Know the patterns. Know the risks. Act faster.