← All articles

operationsarchitecturesupabase

Your Business Doesn't Need Another Dashboard

The business didn’t need another dashboard. It needed to stop having two versions of reality.

Bookings lived in WhatsApp chats. Packages lived in spreadsheets — one per location, each slightly different. Staff and clients constantly disagreed about something basic: how many lessons were left. Nobody was careless. The information simply had no home.

This is the most common failure mode I see in small operations, and it has nothing to do with missing features.

The problem is never “we need software”

When a team says “we need software,” what they usually mean is “we are tired of arguing about reality.” Every manual handoff — a message here, a cell updated there — is a chance for two truths to diverge. And once they diverge, people stop trusting the system entirely and fall back to asking each other directly, which is how you end up managing a business over chat at 11pm.

Another dashboard on top of the mess doesn’t fix this. It adds a third version of reality.

One source of truth, in practice

A single source of truth is not a slogan. Concretely, it means three things:

One database, not one screen. The app, the portal, and the back office must read and write the same rows. If the client books from their phone, the staff sees it instantly — not after someone retypes it.

Rules live on the server, not in people’s heads. “Can this booking be moved? Does this package still have credit?” If the answer depends on who you ask, the rule belongs in the database: constraints, server-side functions, permissions per role and location.

Permissions mirror the org chart. A trainer sees their location. A manager sees all of them. The client sees only their own data. Row-level security sounds like enterprise jargon, but for a small team it simply means nobody can accidentally break someone else’s view.

How to get there without a big-bang rewrite

You don’t replace everything on day one. The pattern that works:

  1. Map the flow first. Follow one booking, one package, one payment from start to finish. Write down every place it gets copied by hand. That list is your roadmap.
  2. Fix one flow end to end. Pick the most painful one — usually bookings — and make it fully consistent across every surface before touching anything else.
  3. Don’t automate noise. Some steps exist only because the old tools forced them. If a step wouldn’t survive in a sane system, delete it instead of coding it.

I wrote about one such rebuild — a multi-location fitness operation that went from chat plus spreadsheets to a unified dashboard, app, and portal — in this case study. The technology mattered less than the discipline: one model, one set of rules, every surface aligned.

The takeaway

Before buying or building anything, ask one question: how many versions of the truth does this business currently have? If the answer is more than one, that — not a feature list — is the project.