Skip to content

An operations dashboard for a growing team

A web app that replaces a set of shared spreadsheets, with roles, approvals and live numbers for managers.

Category
Web apps

The situation

A team of twenty runs its operations on shared spreadsheets. Versions drift, anyone can overwrite anything, and managers wait for someone to compile the weekly numbers by hand.

How we approach it

  1. 01Shadow the team for a few days and list every spreadsheet, who edits it and why.
  2. 02Prototype the three most-used workflows and test them with the people who do the work.
  3. 03Build the web app with accounts, roles and an approval step where mistakes are costly.
  4. 04Import the existing data, run both systems side by side for two weeks, then switch over.

What you get

  • Web app with roles and permissions
  • Approval workflows
  • Live dashboard for managers
  • Data migration from spreadsheets