Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

High-no-show specialty by clinic

Vitalcore Health Network · SQL · beginner

The brief

Priya:

Tighten the focus. Across 2024, find the combinations of clinic and specialty where the no-show rate is above 18%. Show me clinic name, specialty, total appointments, no-show count, and rate.

Filter out tiny samples — only include combinations with at least 100 appointments.

Order by rate descending. This is where I will start the operational deep-dive next week.

Independent grading

92/100

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