Global Tech Firm Unblocks 2,500 Critical Construction Projects with Custom Tool
Summary:
A fragmented, spreadsheet-based project planning system left a global technology company unable to prioritize initiatives, forecast project start dates, or effectively manage 2,500 active construction projects. Quandary implemented a custom Quickbase project portfolio management application that delivered real-time visibility, centralized control, and scalable reporting for more than 800 enterprise users.
Results Snapshot
Workflow Automation Reduced 9–12 Month Ticket Delays to Real-Time Resolution
Zero Project Escalations Through Standardized Portfolio Governance
Construction Project Planning Updates Turned Around in Less Than 24 Hours
Enterprise Access Governance for 800+ Project Portfolio Users
Unified Project Management System Tracking 2,500+ Data Center Projects
The Challenge: Managing 2,500+ Data Center Projects in Spreadsheets
A global technology company overseeing thousands of data center construction projects was approaching a critical operational breaking point.
Its project planning and portfolio management process relied heavily on spreadsheets and fragmented internal tools that could no longer scale with the size, complexity, and urgency of the organization’s capital initiatives.
With more than 2,500 active projects and over 800 stakeholders, the company lacked:
- A centralized project portfolio management system
- Real-time visibility into project readiness and prioritization
- Role-based controls over edits, approvals, and data governance
- Reliable forecasting for projects scheduled to launch in the upcoming fiscal year
Without structured governance or portfolio-level visibility, resource allocation became misaligned. Capital budgets were committed to lower-priority construction initiatives while high-impact data center projects stalled due to lack of clarity and coordination.
Operational Consequences
Internally, frustration mounted as planning inefficiencies compounded:
- No real-time reporting across the enterprise construction portfolio
- No access controls or approval workflows to safeguard critical project data
- No standardized prioritization framework to guide investment decisions
- Limited ability to forecast capacity, readiness, or execution timelines
Disconnected spreadsheets introduced version control issues, inconsistent reporting, and reactive decision-making. Leadership lacked the tools required for proactive portfolio governance.
The planning organization recognized that continuing to scale data center development using spreadsheet-based processes would create increasing operational risk. A centralized, scalable enterprise construction planning platform was required to enforce standards, enable prioritization, and restore confidence in portfolio-level decision-making.
Our Solution: Custom Quickbase Planning App
The client needed a better way to manage thousands of overlapping projects without losing control over who could update, approve, or prioritize critical planning data.
We built a custom application in Quickbase that aligned with their internal planning standards and supported the complexity of global construction projects.
The tool allowed the team to:
- Configure access rules to control who could edit and approve projects
- Standardize project evaluation using five internal planning criteria
- Integrate with their intake system while still functioning independently
By anchoring the system in the client’s own decision-making framework, we ensured it could scale across regions and teams without introducing bottlenecks or workarounds.
Specifically, it guides the team to address these questions:
- Configure access rules to control who could edit and approve projects
- Can we select it?
- Can we support it?
- Can we complete it within the timeframe?
- Is it within budget for our objectives?
- Is it within budget for our region?
Key Capabilities
Each feature was designed to help the client prioritize projects more effectively, enforce planning discipline, and reduce misalignment across global teams.
- Prioritization by Readiness and Budget Fit: Teams can now rank projects based on internal readiness tiers (R1–R5), strategic priority (P0–P4), and available cash flow—enabling faster, clearer decision-making.
- Structured Approval Paths: Only authorized users can submit or approve projects, with clear role-based access that locks once planning deadlines pass. This reduces conflicting edits and last-minute changes.
- Global Planning Filters: Teams can evaluate projects by objective, region, or owner, ensuring that local efforts align with global goals.
- Connected, Flexible Architecture: The tool can also run independently of the intake system, preserving autonomy without sacrificing cross-system visibility.
Our Process: Rapid Development with Daily Feedback Loops
To address the client’s enterprise-scale planning challenges, we began with a focused discovery sprint designed to untangle existing project portfolio workflows, spreadsheet data structures, and system constraints.
Our objective was clear: build a scalable construction planning and portfolio management platform capable of supporting global operations—without introducing rigid workflows that would slow teams down.
From discovery to deployment, we prioritized speed, adaptability, and close collaboration.
Key Implementation Steps
- Audited the spreadsheet-based planning system
We conducted a detailed review of the client’s manual processes, identifying workflow bottlenecks, data integrity risks, version control issues, and temporary workarounds that had evolved over time. - Translated planning standards into structured digital workflows
Internal portfolio governance standards were mapped into a structured Quickbase workflow. This included defined roles, approval paths, readiness criteria, and prioritization controls to ensure consistent project evaluation. - Built a scalable Quickbase project planning application
The solution was developed in Quickbase, with dual capability:- Integrated with the company’s existing project intake system
- Fully capable of operating independently if needed
- This architecture ensured flexibility while preserving interoperability across enterprise systems.
- Delivered iterative builds with daily review cycles
Using an agile development model, we released incremental updates for daily stakeholder review. Real-time feedback allowed us to refine workflows, improve usability, and adjust logic without delaying progress. - Implemented role-based access and approval controls
We aligned permissions and approval logic to reduce risk, prevent conflicting edits, and strengthen data governance across 800+ users. Structured controls ensured that only authorized stakeholders could modify critical project information.
By combining rapid development with tight feedback loops, we delivered a scalable enterprise construction portfolio management system that enforced standards, improved visibility, and enabled strategic prioritization—without disrupting ongoing planning operations.
The Roadblocks: Agile Was a Culture Shock
Delivering this tool meant navigating both technical and cultural friction.
The client’s teams were used to waterfall-style development and long approval cycles. Shifting to our agile approach, which relied on rapid iteration and daily feedback, was unfamiliar at first. But once they saw how quickly their input shaped the product, the pace became a strength.
The complexity of the planning environment meant no two teams used the system the same way. Regular feedback loops helped ensure the tool fit the real-world behaviors of every stakeholder group before full deployment.
Internally, every stakeholder group had its own workflow and expectations for how planning should work. Some teams prioritized speed. Others prioritized budget. Some focused on global strategy, while others handled local execution. Aligning these competing needs required constant recalibration and compromise.
Finally, adoption required a mindset shift. Teams had to rethink how they submitted, approved, and prioritized work. What was once flexible and informal now followed clear rules. That structure created early resistance, but it also made the wins visible.
The Toolstack
The Platform: Built on Quickbase for Flexibility and Scale
The client’s new enterprise project planning tool was built entirely in Quickbase, selected for its flexibility, low-code architecture, and ability to support complex portfolio management workflows without heavy infrastructure overhead.
Quickbase enabled us to design a scalable solution tailored to global construction operations while maintaining the agility required for fast iteration.
Quickbase Allowed Us To:
- Configure role-based access controls tied to planning deadlines
We implemented structured permission management and deadline-driven governance, ensuring that edits and approvals aligned with portfolio planning milestones. - Map internal approval logic without rigid hardcoding
Using Quickbase’s relational data model and workflow capabilities, we translated internal planning standards into dynamic approval workflows—preserving flexibility while enforcing consistency. - Rapidly deploy updates based on daily stakeholder feedback
The low-code framework allowed for real-time iteration, enabling continuous refinement of forms, dashboards, reporting logic, and prioritization rules. - Integrate seamlessly with existing intake and enterprise systems
The platform was architected to connect with upstream project intake processes while retaining the ability to operate independently, ensuring long-term scalability and system resilience.heir intake system while keeping the tool modular
By leveraging Quickbase as the foundation, the client gained a flexible, scalable construction portfolio management system capable of enforcing governance standards, controlling data access, and adapting quickly to evolving global planning needs.
The Results: From 12-Month Delays to Real-Time Updates
The planning team now has full visibility into 2,500+ active and upcoming construction projects and can make real-time decisions about what to prioritize, delay, or decline.
Previously, it took up to 12 months to make changes to their planning tools. With the new Quickbase system, teams can deploy updates in days (or minutes) based on changing priorities.
For the first time in the company’s history, the annual planning cycle went forward without a single escalation. Teams had what they needed, and leadership had confidence in the process.
What used to be a fragmented, spreadsheet-based system is now a single source of truth. Every team can see what matters, what is approved, and where the budget is going.
Key Results:
- System update cycle reduced from 9-12 months to days
- Eliminated escalations during global portfolio planning
- Enabled real-time project visibility across 2,500+ initiatives
- Gave 800+ users access to a single, controlled planning system
- Prioritized high-impact construction with clear readiness and budget filters
What’s Next: Strengthening Budget Governance and Capital Allocation
With the new enterprise project portfolio management system in place, the planning team is now focused on enhancing the platform’s budget control and capital allocation capabilities.
The next phase centers on improving how funding is distributed across the global data center construction portfolio, ensuring that capital is directed toward high-priority, shovel-ready projects while minimizing delays and reducing wasted spend.
Key Focus Areas
- Strengthening budget forecasting and financial visibility across 2,500+ projects
- Aligning capital allocation with standardized readiness and prioritization criteria
- Improving scenario modeling to evaluate tradeoffs between competing initiatives
- Enhancing reporting to support data-driven investment decisions
With real-time portfolio visibility and structured governance already established, the organization is now equipped to refine annual planning cycles, optimize capital deployment, and scale construction initiatives more strategically year over year.
The foundation is in place for smarter growth—supported by disciplined portfolio governance, financial controls, and scalable enterprise planning infrastructure.
Client Overview:
A U.S.-based global technology company with operations spanning search, cloud infrastructure, enterprise systems, and large-scale data center engineering. The client’s project planning team manages large-scale construction programs for global data centers. Our work focused on their intake and portfolio management overhaul.
Speak with Our Innovation Team
Use the form below to drop us an e-mail. We'll be in touch shortly.
Fields marked with an asterisk (*) are required.
Resources
© 2026 Quandary Consulting Group. All Rights Reserved.
Privacy Policy