About the Project
The Eglinton Crosstown West Extension will bring even more rapid transit to Etobicoke and Mississauga, making it easier for people to get where they need to be each day.
The extension of the Eglinton Crosstown LRT will run 9.2 kilometres from the future Mount Dennis LRT station to Renforth Drive and will operate mainly underground. Once complete, it will create a continuous rapid transit line that stretches from Scarborough, through midtown Toronto, and into Mississauga.
Project Highlights
Number of stations: Up to 10
Connections to other transit options: 5
Route length: Up to 13.9 km
PM ERA’s Assignment
Client: Metrolinx
Assignment:
Analyze, design, implement and handover dashboards for
Permit management
Property acquisition
Submittal management
Agreements
Tools used: Primavera P6, Excel, Power BI
The dashboards designed and built by PM ERA were all tailor-made to suit different levels, from operators to executives.
These dashboards collected data from various sources and integrated data of this project with other projects at the subways program level. The data were then transformed and analyzed in the dashboards to visualize the Key Performance Indicators (KPIs) that were developed in conjunction with the subject matter experts in Metrolinx. The KPIs facilitated smooth project delivery and pinpointed the bottlenecks and the areas for improvement.
Dashboard users could easily get to the info using a safe link sent to their work Microsoft account. They could access the dashboard from any device using a web browser, viewing data based on their individual access levelThe dashboards had slicers that allowed users to drill down to the specific information they wanted with just a few clicks.
Metrolinx benefited from the dashboards by saving on resources required for the manual generation of regular reports.
Permit Dashboard
PM ERA studied the PLA process through various techniques such as interviews, document reviews, research, etc. and introduced a harmonized tracking system that was implemented throughout the agreements with different parties, from the technical advisors to subcontractors. Regular data updates collected from approximately 28 parties through the so-called tracking system were then analyzed, consolidated and integrated with other project-related data into the Permit Dashboard.
The provision of the Building Transit Faster Act (BTFA) was foreseen in the permit dashboard – in case an escalation was needed for the issuance of any permit.
By analyzing the previous records of various permit types, the dashboard provided a basis for future agreements with the authorities having jurisdiction.
Property Dashboard
PM ERA has supportedthe enhancement of Metrolnix’s property acquisition management databases and integration of the data from the pre-acquisition and acquisition phases. The Property dashboard collected, integrated, and analyzed the data from huge databases that recorded every revision of different acquisition types throughout the entire process’s life cycle.
Submittal Management Dashboard
The submittals dashboard allowed users to effectively track the status of document submissions to various parties.
Agreement Dashboard
The agreement dashboard provided a visual representation of the status of Metrolinx agreements with external organizations. This allowed users to readily identify agreements that carried higher risks for Metrolinx projects due to potential delays occurring at any stage, spanning from negotiations through execution to completion.
Added Value
– Saving resources and time in generating regular reports
– Integrated data from different data sources into a user-friendly dashboard
– Enhanced accessibility to information
– Enhanced security of information (secured online report vs pdf files/paper reports)
– Red flags and highlighted bottlenecks
we used has benefited as Metrolinx uses the dashboards even after our contract [RS1]
