Overview

Before this project, project status lived in each manager's inbox, whiteboard, or memory. There was no consolidated view of what was active, what was at risk, or where crew capacity was being consumed. Leadership relied on anecdotal updates and last-minute escalations to make scheduling and staffing decisions.

I designed and implemented a centralized master schedule that consolidated all active and upcoming jobs into a single trusted source of truth. The result was the company's first real capacity planning system, enabling proactive staffing conversations, early risk identification, and a data foundation ready for Power BI.

Challenge

A field service contractor managing multiple concurrent jobs across regions. Crews mobilizing to different sites on overlapping timelines. No single view of what was happening or what was coming.
 

The specific issues:

• Work updates scattered across emails, spreadsheets, and verbal reports

• No unified view of project status → reactive decision-making

• Progress measured by gut feeling, not data

• Delays and blockers invisible until they became critical
   

My Role:
I led the design and rollout end-to-end: current-state mapping, system design, governance, and adoption. I reported to the VP of Operations and worked directly with project managers and field crews to make sure the schedule actually reflected how work moved through the business.
 

What I DID

Mapped the Chaos
I identified every tracking method in use across teams, spreadsheets, whiteboards, email threads, even sticky notes. I captured the full picture before designing anything.

​

Designed the System
I created a standardized master schedule with clear status logic, milestone tracking, and ownership fields. The key design decisions were:

• Standardizing job attributes across all entries: status, key dates, labor hours, crew size, mobilization dates, and duration

• Introducing an 85%+ completion filter to exclude near-complete work from capacity calculations, preventing finished jobs from inflating available labour figures

• Collaborating directly with field leadership to validate data accuracy
   

Centralized Everything
I consolidated all active projects into a single, living document, eliminating duplicate tracking and manual follow-ups.

​

Built for the Future
I structured the data to be automation- and visualization-ready for Power BI. Solved today's problem while building for tomorrow's scale.

​

Established Governance
I defined update cadences, ownership roles, and review cycles to keep the system accurate and trusted over time.
 

Outcomes

The numbers:

• 100% of active jobs consolidated into a single source of truth

• 5+ hours per week saved per manager on status chasing and meeting prep

• First-ever portfolio-level risk reporting and delivery forecasting enabled

• Analytics-ready data model built and validated for Power BI
   

The bigger wins:

• Leadership gained a reliable view of workload distribution, staffing needs, and delivery risk

• Capacity conversations shifted from reactive to proactive—identifying shortfalls weeks ahead

• Reduced reliance on anecdotal updates and last-minute escalations
   

What I Learned

Centralizing data is not enough. Structuring it for decision-making is what creates real business value. A spreadsheet no one trusts or updates is worse than no spreadsheet at all.

​

I also learned that clean data structure upfront enables endless downstream value. Every hour spent getting the model right saves ten hours of rework when it is time to connect to BI tools or reporting dashboards.

​

Finally: build with the end user in mind. Prove value fast. Then expand.

​

Book a free 30-minute consultation to discuss your operational challenges and identify opportunities to improve efficiency, visibility, and execution.