Dance Studio Quarterly Business Review Prep: VA Standard Operating Procedure

Dance studio quarterly business review prep requires a virtual assistant to synthesize three months of operational data into a presentation the owner can act on. Unlike weekly reports that track short-term movement, a QBR reveals patterns - seasonal enrollment shifts, revenue trajectory, instructor effectiveness, and whether the studio is growing or quietly contracting.

This SOP walks you through every step of preparing a quarterly business review for a dance studio owner. You will pull data, build visuals, write analysis, and deliver a document that makes the next quarter's decisions obvious.

What a Dance Studio QBR Should Cover

A quarterly business review for a dance studio is not a corporate boardroom exercise. It is a focused review of six core areas:

1. Enrollment trends by season - How did student counts move across the quarter? Which classes grew? Which shrank?
2. Revenue by program - Where is money coming from? Tuition, privates, camps, merchandise, event fees?
3. Retention rates - How many students from last quarter are still active? Where did drop-offs happen?
4. Instructor performance - Which instructors have the highest attendance, retention, and parent satisfaction?
5. Competition results - If the studio competes, how did teams place? What does that mean for reputation and enrollment?
6. Facility utilization - Are studio rooms booked efficiently? Are there dead hours that could generate revenue?

Your job as a VA is to gather this data, organize it clearly, and provide a written summary the owner can reference during planning conversations. Pair QBR prep with your KPI dashboard setup and weekly reporting cadence to keep analysis consistent across all timeframes.

Enrollment Trends: How to Pull and Present the Data

Start by exporting enrollment data for the full quarter. You need:

• Total active students at the start of the quarter
• Total active students at the end of the quarter
• Net change (gains minus losses)
• Breakdown by age group (preschool, elementary, teen, adult)
• Breakdown by style (ballet, jazz, hip-hop, contemporary, lyrical, tap, acro)
• New enrollments by month
• Cancellations by month

Present this as a simple table with a trend line. Owners want to see direction, not just numbers. A chart showing monthly enrollment over the past four quarters gives context.

Flag these situations:

• Any style losing more than 15% of enrollment quarter over quarter
• Any age group with zero new enrollments for a full month
• Significant spikes that may be tied to a marketing campaign or event

Revenue Analysis by Program

Pull revenue data and categorize it:

• Core tuition: Monthly class fees from enrolled students
• Private lessons: One-on-one or small group sessions
• Drop-in fees: Single class purchases from non-enrolled visitors
• Camps and workshops: Summer intensives, holiday camps, master classes
• Competition fees: Entry fees, coaching fees, travel-related charges passed to families
• Merchandise and costumes: Leotards, shoes, studio branded items, recital costumes
• Event revenue: Recital ticket sales, showcase admissions, rental income from the space

For each category, show:

• Total revenue for the quarter
• Percentage of total revenue
• Comparison to same quarter last year
• Comparison to previous quarter

Highlight the top revenue driver and any category that declined by more than 10%. If a camp generated strong revenue last quarter, note that it should be repeated or expanded.

Retention Rate Calculations

Retention is the metric most studio owners undervalue. Acquiring a new student costs five to seven times more than keeping an existing one. Calculate retention this way:

Quarterly retention rate = (Students active at end of quarter who were also active at start) / (Students active at start of quarter) x 100

Break retention down by:

• Age group
• Class style
• Instructor
• Day of week

If Tuesday evening ballet has 40% quarterly retention while Thursday evening ballet has 85%, something specific is happening on Tuesdays. Surface this in the QBR so the owner can investigate.

Also track:

• Average student tenure (how long students stay enrolled before leaving)
• Common drop-off points (after first month, after recital, after summer break)
• Win-back attempts and their success rate

Instructor Performance Metrics

This section requires sensitivity. Present data objectively without personal commentary. Metrics to include:

• Average class attendance rate per instructor
• Retention rate of students in their classes
• Number of private lesson bookings (if applicable)
• Parent feedback scores (if surveys are conducted)
• Competition placements for their students (if applicable)

Create a comparison table but avoid ranking instructors publicly in the document. Instead, highlight:

• Instructors with consistently high attendance (above 85%)
• Instructors whose classes are growing in enrollment
• Any instructor whose attendance has dropped significantly

The owner will decide how to use this information. Your role is to present it cleanly.

Competition Results and Reputation Impact

If the studio has a competitive team, summarize:

• Competitions attended during the quarter
• Number of routines entered
• Placement breakdown (gold, high gold, platinum, first place, etc.)
• Overall studio ranking at each event
• Notable individual awards
• Social media engagement from competition posts

Connect competition success to enrollment where possible. Did a viral competition video lead to new inquiries? Did a strong showing at regionals generate referral traffic?

Facility Utilization Analysis

Pull the studio schedule and calculate:

• Total available studio hours per week (rooms x operating hours)
• Total booked hours per week
• Utilization percentage
• Peak hours (highest demand)
• Dead hours (empty rooms)

A healthy utilization rate for a dance studio is 65-80% during peak evening hours and 40-55% overall including daytime. If utilization is below these benchmarks, recommend strategies:

• Adding daytime adult classes
• Renting space to outside instructors
• Offering birthday party packages during weekend gaps
• Adding homeschool programs during weekday mornings

Building the QBR Document

Structure the final deliverable as follows:

1. Executive Summary (one page) - Top five findings and recommended actions
2. Enrollment Dashboard - Tables and charts
3. Revenue Breakdown - Categorized with comparisons
4. Retention Analysis - Rates by segment
5. Instructor Metrics - Performance data
6. Competition Recap - Results and impact
7. Facility Utilization - Schedule analysis
8. Recommended Actions - Prioritized list for next quarter

Deliver the QBR document five business days before the scheduled review meeting. This gives the owner time to read it, form questions, and come prepared for a productive discussion.

Use Google Slides or a well-formatted PDF. Avoid walls of text. Lead with visuals and use bullet points for commentary.

QBR preparation sits at the strategic end of the VA spectrum - high value, high trust. BLS data projects fitness-related jobs to grow 14% through 2032, making analytical VA skills increasingly valuable for studios planning long-term.

Timeline for QBR Preparation

Weeks 1-2 of the new quarter: Pull all raw data from the previous quarter. Export from studio management software, payment processors, survey tools, and competition records.

Week 2: Build charts, tables, and visualizations. Calculate retention rates and utilization percentages.

Week 3: Write the executive summary and recommendations. Review the full document for clarity and accuracy.

Week 4: Deliver to the owner. Schedule the review meeting. Prepare talking points for any sections that may prompt questions.

Frequently Asked Questions

How far back should the QBR compare data?

Compare the current quarter to the same quarter last year and to the immediately preceding quarter. Year-over-year comparisons reveal seasonal patterns, while quarter-over-quarter shows recent momentum. If the studio has been operating for less than two years, use whatever historical data is available and note the limitation.

What if the studio does not have clean data for all six areas?

Start with what exists. If the studio has strong attendance data but no formal instructor feedback surveys, report on attendance and note the gap. Recommend implementing a simple parent survey for next quarter. Build the QBR muscle with available data and expand scope over time.

Should the VA present the QBR or just prepare it?

This depends on the owner's preference. Some owners want the VA to walk them through the document on a video call. Others prefer to read it independently and then discuss. Ask during onboarding which format they prefer. Either way, prepare speaker notes for each section so you are ready if asked to present.

How do I calculate retention if students take summers off?

Seasonal studios often see planned breaks. Distinguish between students who formally cancel and those who pause for summer with a confirmed return date. Only count formal cancellations as lost students. Track summer pauses separately and report what percentage actually returned in the fall.

What tools work best for building QBR presentations?

Google Slides works well for visual presentations. Google Sheets handles data analysis and chart creation. Canva is useful for polished one-page summaries. If the owner prefers raw data access, a shared Google Sheet with multiple tabs and a summary dashboard tab is effective.