Verified by DataSimHQ

Analyst

Ajibola Enifeni

Senior Analyst

Project

Add a Fraud page and time-intelligence measures

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