Live Web App https://gymdatabase-data-analytics.streamlit.app/
A full-stack gym admin dashboard built with Python, SQLite, and Streamlit – designed to help admins manage members, trainers, events, and visualize growth analytics 🚀.
🔥 SQL-Driven Automation using TRIGGERS
📈 Live Charts with Streamlit
🧠 Smart Schema Design & Relational Modeling
✅ 100% Streamlit Cloud Deployable
- View all members with their join/expiration dates
- Register new members (auto-calculates expiration)
- Track upcoming events and trainer schedules
- View expiring memberships by month
- Monthly membership trends
- Daily signup tracking (last 30 days)
- Plan-wise member distribution
- Peak signup month + summary metrics
- See which trainer conducted the most events
- Reward top trainers based on real data
| Layer | Tool |
|---|---|
| Frontend | Streamlit |
| Database | SQLite (.db file) |
| Language | Python 3.x |
| Hosting | Streamlit Cloud |
| Faker Data | faker Python lib |