Analyst
Senior Analyst
Project
Nexus Financial Services · Power BI · intermediate
The brief
Dana Park here, Head of Risk.
I need a Fraud page on the Nexus dashboard. Add it after the Churn page.
While you are at it, build the time-intelligence measures we will use throughout this episode: - Fraud Cases — count of rows in fraud_cases - Confirmed Fraud Cases — count where case_status = "confirmed_fraud" - Total Fraud Loss — sum of loss_amount for confirmed cases - Fraud Cases YoY Change — current period minus same period last year - Fraud Loss YoY Change — same pattern, in dollars
Page title: "Fraud Pattern Analysis" Subtitle: "Cases, concentration, and dollar exposure"
Independent grading
92/100
Achieved 2 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more