We partnered with Massport, the port authority for the Commonwealth of Massachusetts, to tackle a significant challenge: transforming a massive, complex data landscape into a powerful asset for decision-making. With a portfolio of over 200 buildings, three airports, and numerous maritime locations, Massport's data was disconnected and difficult to access.
Our mission was to help them gain a clear, comprehensive view of their infrastructure, which was critical for strategic planning, capital improvements, and sustainability initiatives. This project showcases how we leveraged a strategic, phased approach to data management, from gathering raw information to building a centralized, user-friendly platform, to empower Massport with the tools it needed to make data-informed decisions and drive impactful change.
What We Accomplished
+/- $100M: FY25-29 Funds planned into the CIP to begin addressing findings
171: Building Assessments’ data collected
100+: People trained and ready to use the Keyrus-developed dashboards
Background
Our client, MassPort, is the port authority for the Commonwealth of Massachusetts. Massport covers over 200 buildings and utilities, has 3 aviation facilities, and numerous maritime locations. They generate $22 billion in economic activity and provide direct jobs. Due to the numerous locations and people associated with Massport, they have an incredibly large and complex data landscape.
Challenge
Massport needed a more effective and efficient way to access information about the agency's infrastructure assets - more than 200 buildings and utilities across three airports and multiple marine facilities. Massport was looking to understand its data better to address infrastructure needs, such as terminals and lighting. At Massport, there were three major challenges to overcome: 1. Undefined processes for infrastructure data collection, management, and dissemination 2. Disconnected data sources and limited accessibility hindered decision-making and Capital Improvement Planning 3. Limited baseline knowledge of existing infrastructure conditions
Approach
Keyrus worked with leadership and key stakeholders to identify the challenges the agency faced in accessing and analyzing infrastructure data. Keyrus then created a roadmap and data strategy to gather, analyze, and utilize the data to drive decisions and achieve business objectives. We developed a centralized platform named MICA to integrate the various tools and technologies to make data accessible to business teams. Keyrus also provided change management expertise to ensure user adoption and to integrate new data processes and tools into business operations. Our approach had 3 main phases: 1. Data Sources: Gather data from sources including Trust Agreement, Building Condition Assessments, Utilities Condition Assessments, Capital Investment Plan Projects, Keywords, LEED, MASA, and Resiliency. 2. Storage, Processing, and Modeling: Use a Landing Zone with AWS Cloud and Amazon S3. Build a Data Warehouse with Snowflake and use Data Modeling for the raw data. 3. Consumption: Create accessible and reliable dashboards with Tableau and Snowflake, as well as custom solutions for data to be consumed by everyone, including Directors, Program Managers, Airport/Maritime Operations Managers
Client Testimony
"The dashboards contain helpful graphical summaries to get specific data points that help provide a complete picture of building-related sustainability conditions and performance."
Massport Employee, End User, Massport (Massachusetts Port Authority)
Key Results
Provided business users and decision-makers with access to infrastructure data, starting with the condition baseline, making decisions data-informed and more efficient.
2750+ recommendations provided from MICA for infrastructure, sustainability, and energy improvements
19 active Capital Projects are now underway to execute the improvements identified from the MICA program
Benefits
Through the maximum utilization of technologies, our work delivered a comprehensive assessment of Massport infrastructure to inform strategic business decisions. Massport now has a centralized repository for Infrastructure data to enable leaders to better use and manage infrastructure. This multiple award-winning platform, which has been included in a worldwide news record, has enabled Massport to proactively address infrastructure, sustainability, and energy needs as well as secure appropriate funding, backed by data.