Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

No-show rate by appointment type

Vitalcore Health Network · SQL · beginner

The brief

Priya:

Are no-shows concentrated in specific types of appointments? I suspect new patient visits no-show at higher rates than established but I want to confirm.

For 2024 appointments, group by appointment_type. Show me total appointments, no-show count, and no-show rate as a percentage. Order by rate descending.

Independent grading

97/100

Achieved 27 Oct 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