Fitness Studio BI & IT-Hub Dashboard: Sovereign Cloud, Data Workers & Cold-Spare
In established multi-branch studios, valuable data is often trapped in isolated silos. For this fitness studio chain, we operate the on-premise infrastructure as a fully managed Sovereign Cloud (backed by Proxmox Backup Server and cold-spare failover hardware in our data center) and weave every data source via background workers into a blazing-fast Astro BI & IT-Hub dashboard.
Six Interlocking Modules in Production (3x2 Architecture)
This is the literal meaning of our name, New Digital Yarn: Instead of forcing companies to rip out working industry software, our background workers weave legacy databases, front-desk terminals, and resilient Sovereign Cloud infrastructure into one unified system.
Passwordless CenterCom Guest Check-in & Omni-API
Frictionless guest and trial workout registration at the front desk with resilient FastAPI fallback queuing (Omni-API), ensuring zero lost leads even if local third-party software pauses.
Hourly MSSQL ➔ PostgreSQL ETL Sync
Automated background data pipeline between the studio's legacy MSSQL database and the analytics PostgreSQL cluster — including cryptographic SHA-256 hashing of all personally identifiable information (PII).
Astro BI Analytics — 'Churn Radar' & Check-in Heatmaps
Interactive business intelligence dashboard featuring GitHub-style attendance heatmaps, workout frequency analytics, and early detection of member cancellation risks.
ndy-wp-engine Performance Stack
Custom-engineered PHP/Redis optimization module for dynamic class schedules, automated asset minification, and instant page loads during regional marketing campaigns.
Managed Sovereign Cloud (On-Premise & Data Center)
The on-site studio servers are fully managed and monitored by our team as a Sovereign Cloud — keeping data on-premise while we handle 100% of systems administration.
Proxmox Backup Server (PBS) & Cold-Spare Recovery
Encrypted backups replicate automatically to our Proxmox Backup Server. Thanks to pre-provisioned cold-spare hardware at our facility, the entire environment can be restored and online within minutes.
Data Flow Architecture: How Our Workers Weave Disparate Sources Together
flowchart LR A["CenterCom Check-in & Omni-API"] --> W["ndy Python ETL Worker (Hourly Sync & SHA-256 Hashing)"] B["Local Studio DB (MSSQL)"] --> W C["ndy-wp-engine (Schedules & Web)"] --> W W --> P["Analytics DB (PostgreSQL)"] P --> D["Fitnessstudio Astro BI (Heatmaps & Churn Radar)"] P --> S["Sovereign Cloud Backup (PBS & Cold-Spare at ndy DC)"]