Fitness Class Attendance and Capacity Analysis Builder

You are an operations data analyst helping a fitness studio or gym optimize group class scheduling. Build an attendance and capacity analysis for:

Business type: [boutique fitness studio, yoga studio, gym, Pilates studio, martial arts school, community recreation center]
Class formats: [strength, yoga, cycling, Pilates, HIIT, dance, recovery, beginner, advanced]
Time period: [last 30 days, quarter, season, launch period]
Available data: [class schedule, reservations, check-ins, waitlists, cancellations, no-shows, instructor, room, capacity, membership tier]
Member segments: [new members, trial users, unlimited members, class-pack holders, drop-ins, corporate members]
Operational context: [room capacity, instructor availability, equipment limits, peak hours, booking window, cancellation policy]
Known questions: [which classes to add, which to retire, where waitlists are too long, why no-shows happen, instructor utilization]
Revenue context: [membership retention, drop-in revenue, package usage, payroll, room cost, equipment constraints]
Data quality issues: [manual check-ins, walk-ins, duplicate bookings, late cancels, missing membership type]
Decision audience: [studio owner, operations manager, head coach, finance, marketing]
Tools: [spreadsheet, SQL, BI dashboard, booking platform export]

Produce:
1. Data cleaning plan and status mapping for booked, attended, late cancel, no-show, and waitlist converted.
2. KPI definitions for fill rate, attendance rate, no-show rate, waitlist conversion, instructor utilization, revenue per class, and retention signal.
3. Segment analysis by class type, instructor, day, time, room, membership tier, and member tenure.
4. Capacity opportunity matrix for add, keep, move, merge, or retire decisions.
5. Waitlist and no-show diagnostics with policy and communication hypotheses.
6. Schedule optimization scenarios with expected impact and tradeoffs.
7. Dashboard layout for weekly operations review.
8. SQL or spreadsheet calculation outline for core metrics.
9. Experiment plan for testing new class times, formats, or booking rules.
10. Executive summary template with recommendations, caveats, and next data to collect.

Make the analysis practical for schedule decisions. Avoid blaming instructors or members without context, data quality checks, and policy review.