Tech
Transformation

Data Modeling & Long-Range Transportation Planning Support

Los Angeles County Metropolitan Transportation Authority (LA Metro)

Client:
Los Angeles County Metropolitan Transportation Authority (LA Metro)
Role:
Project Management • Requirements Gathering • Excel Model Validation

Overview

E.K. Associates supported the Los Angeles County Metropolitan Transportation Authority in the development and validation of a dynamic, long-range transportation planning model. The engagement focused on strengthening how budgetary, accounting, and external data sources were incorporated into a complex Excel-based model used to support long-term planning and financial forecasting.

‍

Serving as project managers and data analysis specialists, E.K. Associates helped define data flows, improve update efficiency, and validate model integrity—ensuring the planning model accurately reflected financial inputs and supported informed decision-making.

‍

E.K. Advantage

Applied Structured Project Management & Planning Discipline

Provided end-to-end project coordination to keep modeling activities aligned with scope, schedule, and stakeholder expectations.

Improved Data Flow Transparency & Update Efficiency

Analyzed how financial and operational data entered the model and identified opportunities to streamline updates and reduce manual effort.

Strengthened Model Accuracy Through Validation Support

Validated Excel model behavior related to external data integration, improving confidence in planning outputs.

Key Features & Work Performed

Contact Us
Contact Us
Arrow
Arrow
Managed Project Coordination & Stakeholder Alignment
  • Oversaw project activities, timelines, and deliverables
  • Coordinated inputs from finance, accounting, and planning stakeholders
Identified and Documented Data Flow Processes
  • Analyzed data flows incorporating budget, accounting, and external information into the Excel model
  • Recommended process improvements to enhance timeliness and efficiency of data updates
  • Prepared detailed flowcharts and narrative descriptions documenting data movement and dependencies
Validated Excel Model Integration & Accuracy
  • Assisted with validation of the Excel model as it related to external data incorporation
  • Reviewed calculations, assumptions, and data linkages to ensure alignment with planning requirements

Impact Delivered

‍

Improved transparency and documentation of long-term planning data flows

‍

More efficient incorporation of budgetary and accounting data into the planning model

‍

Increased confidence in Excel model accuracy and reliability

‍

Stronger foundation for data-driven transportation planning and forecasting

We don’t just work together. We grow together.

We create a shared vision, and together, we evolve to new heights. Let's connect!

Get Started
Get Started
Arrow
Arrow