Verified by DataSimHQ

Analyst

Project

Build the foundational measures library

Vitalcore Health Network · Power BI · beginner

The brief

Before we build any visuals, set up the foundational measures we will use across the whole dashboard. I need a dedicated measures table with these:

- Claim Count — total number of claims - Total Charged — sum of total_charge - Total Paid — sum of total_paid - Net Collection Rate — Total Paid divided by Total Charged - Average Days in AR — average of days_in_ar - Denial Rate — share of claims where current_status = "denied"

Format each appropriately: counts as whole numbers, dollars as currency, percentages and rates with one decimal.

Independent grading

95/100

Achieved 10 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