Analyst
Senior Analyst
Project
Nexus Financial Services · Power BI · intermediate
The brief
Dana:
Build a combo chart on the Fraud page — columns for fraud case count by month, line for total fraud loss in dollars on a secondary axis.
X-axis: month. Use 2023 and 2024 data. The H2 2024 spike should be unmistakable from across the room.
Add a constant reference line at the 2023 monthly average so we can visualise how far above baseline 2024 has run.
Title: "Fraud Cases and Loss — Monthly Trajectory"
Independent grading
88/100
Achieved 3 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