IndustryModernizing Public Works: Moving Beyond Spreadsheets to PMIS

(Interviewer): Michael, your career has spanned diverse public sector projects-from healthcare to DoD and even prison projects-and you've managed projects with everything from Excel to a Project Management Information System, or PMIS. Can you tell us about the fundamental difference you've observed?

(Michael): Absolutely. The difference is night and day. A lack of a Project Management Information System (PMIS) often leads to disconnected processes and isolated data scattered across countless spreadsheets.

(Interviewer): Jesse, for those unfamiliar, how would you define a PMIS?

(Jesse): Simply put, a PMIS is a purpose-built construction technology system designed for project management. It's about organizing, digitizing, and standardizing every aspect of capital project delivery, moving away from manual, disconnected processes.

(Interviewer): Michael, you've alluded to those "disconnected" processes. Could you elaborate on the challenges with traditional methods like spreadsheets and how a PMIS addresses them?

(Michael): I can certainly attest to the "disconnected" part! I remember the days of having multiple spreadsheets open at once, constantly copy-pasting information between an RFI log and a separate change order log. It required a lot of time, just searching for data and doing repetitive double entry. With a PMIS like Procore, everything resides in a centralized data repository, connecting processes and even allowing me to pull up live portfolio and project data in meetings.

(Interviewer): That centralized data sounds like it enables real-time access from anywhere. Michael, do you have an experience that highlights this benefit?

(Michael): Definitely. I once managed work at an active state prison in the California desert, where cell service was completely blocked inside the perimeter my team was working in. Getting inside the perimeter could take over 30 minutes with security! With a PMIS, I could access all drawings and project documents and even make markups on my tablet without worrying about lugging stacks of paper or needing cell service, because some PMIS solutions like Procore even work offline. This allowed for better-informed decisions, right when they were needed.

(Interviewer): Jesse, beyond access, what role does a PMIS play in standardizing project delivery?

(Jesse): That's a crucial point. While Michael can speak to the practical implications, a PMIS helps establish consistent processes.

(Michael): This is crucial. Before a PMIS, we often saw human error in spreadsheets, broken formulas, and different project managers using completely different processes. Without structure, important steps could easily be skipped. A PMIS, however, enforces a standard, intuitive process with auto-enforced approval workflows. No more "putting the cart before the horse" and realizing you forgot a critical approval.

(Interviewer): And with that standardization comes improved accountability and automatic notifications, correct? Michael, what kind of impact does this have on team dynamics and project progress?

(Michael): Imagine if a project manager or director suddenly won the lottery and left that day. How would anyone get up to speed on what was in their court? Without a PMIS, critical action items can fall through the cracks, leading to costly delays . A PMIS ensures team members are held accountable and responsibilities can be easily handed off, making us proactive instead of reactive.

(Interviewer): Finally, Michael, how does a PMIS enhance collaboration with external vendors?

(Michael): This was a huge pain point. I used to create two separate spreadsheets for everything: one with sensitive internal information and another redacted version for external partners . It was incredibly inefficient. A PMIS provides a collaborative platform for both internal and external users, offering real-time insight to everyone invited, with granular permissions to control who sees what. Most importantly, it means you own your data-it's your platform, your data.

(Interviewer): Jesse, to wrap up, what are the overarching benefits for public works teams embracing a PMIS?

(Jesse): By embracing a PMIS, public works teams can significantly reduce project delays and cost overruns, improve project quality, and gain real-time visibility into their entire portfolio. It's about modernizing, reducing risk, and allowing your team to focus on higher-value activities.

(Interviewer): Thank you both for these insightful perspectives on transforming public works with a PMIS.

Learn more about Procore for Public Agencies