Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

No-show rate by clinic — top 15 worst

Vitalcore Health Network · SQL · beginner

The brief

Priya Patel here.

Marcus has the financial picture. I need the operational one. Let's start with no-shows because that is what providers complain about most.

Pull the no-show rate for every clinic for 2024. Show me clinic name, state, total appointments, no-show count, and no-show rate as a percentage. Order by no-show rate descending. Limit to top 15.

I want to know where to focus. Tell me which clinics are bleeding the most.

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