Data analytics project leveraging SQL to analyze operational efficiency for a Pilates studio. This project explores attendance trends, class popularity, seasonal patterns, and booking optimization using synthetic data, with actionable recommendations to enhance studio performance.
Project Highlights
Data Source: Synthetic data created to simulate the operations of a local Pilates studio.
Focus Areas:
- Identifying the most popular class times, days, and types.
- Examining attendance patterns across seasons.
- Analyzing class fill rates and waitlist dynamics.
- Highlighting under- and over-booked classes.
Insights & Recommendations: The analysis offers strategies for enhancing studio performance, such as introducing new class levels, optimizing class schedules, and addressing overbooking issues.