Customer Risk Rating: Weighted Factors with XLOOKUP and SUMPRODUCT
This lesson is part of the course
In this lesson
You score eight new customers of a fictional bank on five risk factors, combine the points into one weighted risk score with SUMPRODUCT and find the highest-risk customer.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Customer Risk Rating: Weighted Factors with XLOOKUP and SUMPRODUCT Locked
- Risk Tiers, Due-Diligence Levels & Periodic Review Dates Locked
- Large Cash Rule: Single-Transaction Flags and Daily Aggregation per Customer Locked
- Structuring: Deposits Just Below the Threshold in a Rolling 7-Day Window Locked
- Name Screening Basics: Normalising Names, Exact Matches and Partial Hits Locked
- Alert Disposition Metrics: False Positives, Escalations & Report Conversion Locked
- Rule Tuning: Alerts vs True Hits at Different Thresholds Locked
- Case Backlog: Ageing, SLA Breaches and Required Analysts Locked