How I Built a Performance Dashboard for a Multi-Office Chiropractic Practice

When a chiropractic practice owner came to me via Upwork, they had a clear request: "I don't want to rebuild anything. I just want to see what's happening." They were already tracking everything — visits, collections, new patients — across Google Sheets. What they lacked was a way to see it all together, in one place, without digging through individual tabs for each doctor or office. This is a problem I see constantly with small and mid-size healthcare practices: the data exists, but the visibility doesn't. Here's exactly what I built, and how I did it. The Starting Point: Understanding the Data Before touching a single chart or dashboard, I reviewed the existing data structure. The practice had records across two offices — Office A and Office B — and four associate doctors: Dr. Sarah Mitchell, Dr. James Patel, Dr. Emily Tran, and Dr. Marcus Lee. Each row of data captured: The date of the visit Which office it occurred at Which doctor performed it The type of visit (Adjustment, Consult