Long-Range Transportation Planning Data Modernization
Client: Los Angeles County Metropolitan Transportation Authority
Engagement: Dynamic Transportation Planning Model & Data Integration Support
Role: Project Management, Requirements Analysis & Model Validation
E.K Associates supported LA Metro in advancing its long-term transportation planning capabilities through enhanced data modeling, governance, and analytical process design. Acting as project management and technical advisory leads, we helped refine the dynamic planning model used to forecast investment needs, evaluate scenarios, and align capital strategy with regional mobility priorities.
Through structured requirements gathering, data flow analysis, and validation support, we
improved the accuracy, usability, and maintainability of the planning model — strengthening LA Metro’s ability to make informed, data-driven long-range decisions.
The E.K Advantage
Project Leadership & Requirements Clarity
We facilitated stakeholder alignment, identified modeling needs, and established governance over data sourcing and workflow execution.
Operational Efficiency Through Data Architecture Insight
We analyzed how budget, finance, and operational inputs were consumed by the model and recommended ways to streamline updates and reduce friction.
Model Assurance & Confidence Building
We supported model validation to ensure external datasets were integrated correctly, enabling reliable forecasting and scenario analysis.
Key Features & Work Performed
1. Program & Project Management
• Led planning sessions, deliverable tracking, and cross-team coordination
• Defined scope, timelines, and priorities for analysis activities
2. Process Mapping & Data Flow Engineering
• Identified how budget, accounting, and agency inputs flowed into the model
• Recommended improvements for timeliness, efficiency, and accuracy
• Created narrative documentation and visual flow diagrams for stakeholder clarity
3. Model Validation & Quality Support
• Assisted in validating Excel-based long-range model logic
• Reviewed integration rules for external datasets to ensure proper alignment
Impact Delivered
✔ More efficient and transparent data intake processes
✔ Improved model integrity and decision-making confidence
✔ Faster update cycles enabling more responsive planning analysis
✔ Better cross-stakeholder understanding of how financial and operational datasets drive long-term transportation planning
