Analyst
Analyst
Project
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