Gym Members Activity Analysis

Tableau URL: https://public.tableau.com/app/profile/aneta.kowalik/viz/GymMembersActivityAnalysis/GymMembersActivityAnalysis#1

Context
Thos dataset contains longitudinal data of 2,600 gym members, tracking their demographics, membership types, and facility usage patterns. The goal of this project was to identify peak attendance hours and analyze member activity to optimize gym operations.

Content
The dataset consists of 11 files and 39 columns in total, covering various aspects of gym management:

• Raw Data: The primary source file containig check-in logs used to determne peak hours.
• Processed SQL Outputs: Cleaned and aggregated tables (e.g., attendance_rate.csv, average_age.csv, total_workouts_per_hour.csv, avg_calories.CSV, count_members_per_age_group.CSV, total_absence_per_workout.CSV) generated through SQL queries.
• Demographics: Information regarding member age groups (Teenager/Young Adult, Adult, Senior) and gender description.
• Membership Tiers: Segmentation of members into Monthly, Quarterly and Annual plans.

Key Metrics Analyzed:

• Attendance Rate: 48%.
• Average Workout Duration: 70.16 minutes.
• Peak Hours: Identified morning (08:00) and afternoon (16:30) spikes.
• Popular Workouts: Strength training, Cardio.
• Members per age: Most popular - Adults.