Case study · 05
ERP Implementation Support
A large enterprise implementing a major ERP system, with a project tracking base that had grown to over 150 tables and become nearly unusable. We redesigned the entire structure to support the implementation the way it should have been built from the start.
The objective
The team was tracking everything in Airtable: test cases, training, change management, stakeholder readiness, go-live tasks. But the base had been built reactively, one urgent need at a time. Every new phase got new tables. Every workstream built their own. The result: 150+ tables, data duplicated across dozens of places, and reporting that required someone to manually stitch together information from multiple sources just to answer basic questions.
The strategy
We redesigned the base around entities instead of phases. Instead of five separate test case tables for each testing round, one table with a phase field. Instead of scattered tables for risks, issues, and change requests, one unified register. The data didn't change, but now it lived in 25-30 connected tables instead of 150+ siloed ones. Views handled the filtering. Dashboards gave leadership real-time visibility. And the structure finally matched how the project actually worked, not how it had accumulated over time. The design also connects to an enterprise employee roster as a synced dataset: one source of truth for people, linked to tasks, responsibilities, training completion, and workstream assignments. Update the roster once, and it flows everywhere.
View or copy an example template
Reach out for access to automation logic, interface designs, and form configuration.
↳ Other projects
See more of our work.
Take a look at how we’ve helped other businesses consolidate tools, automate manual work, and build operations that scale.
Consulting Operations
A small consulting firm running on spreadsheets, email threads, and QuickBooks, where month-end close meant days of reconciliation and a lot of crossed fingers. We built the system that replaced all of it.
Author Digital Twin & Content Engine
Award-winning author and leadership consultant Colleen McFarland needed to be in more places than one person can be. We built her digital twin, an AI assistant trained on her books, frameworks, and voice, plus the tooling and operations around it.
AI Methodology Portal
A change-management consultancy with 30 years of methodology needed to deliver it faster without diluting it. We built a portal where an AI agent steeped in the firm's doctrine drafts client-ready deliverables in minutes, with consultants making the calls.
Investment Management
A real estate investment business tracking bookings, revenue, and taxes across multiple rental properties, all in spreadsheets. We built a system that automated the booking process and turned scattered financial data into a single source of truth.
Success that sticks
Let’s work together
Getting your operations right takes work, but you don’t have to figure it out alone. Let us know what you’re dealing with, and we’ll help you find the path forward.
Get in touch