Learn how Power BI makes reporting much easier
Power BI makes reporting much easier
Client Overview
Client is an employee-owned, multi-disciplined engineering, planning, architectural, and environmental services firm in the United States. With nearly 700 employees spread between more than 30 offices in 12 states, they offer a wide range of services with a focus on aviation, construction, facilities design, federal, power, transportation, survey, and water. They sit in the top 150 of the Engineering News-Record's prestigious Top 500 Design Firms list, while Zweig Group has recognized client as a best firm to work for in the multi-discipline category for six consecutive years.
Challenges
-
Compiling historical data for reporting was difficult and time consuming
-
Reports were being created from many different sources, including Primavera P6 and Excel worksheets
Results
-
EP-datawarehouse was deployed and snapshots are taken regularly to record historical information
-
New reports are easier to create with the snapshotted data readily available in Power BI
-
Previously created reports in Power BI were able to be utilized and improved with additional data provided by EP-datawarehouse
Transportation Case Studies
EP-datawarehouse Case Studies
on Tuesday, 14 March 2023.
Posted in Case Studies
Learn how P6-Scrubber can edit P6 XERs, XMLs and MSP XMLs
P6-Scrubber used to edit and remove unwanted data prior to import
Client Overview
This State Department of Transportation is a governmental agency that constructs, maintains, and regulates the use of transportation infrastructure. It is responsible for more than 20,000 lane-miles of roadway, nearly 3,000 vehicular bridges and 524 other structures. This infrastructure includes rail lines, state highways, state ferries (considered part of the highway system) and state airports.
Challenges
-
Users were in need of a faster, easier way to remove or remap data from contractor XERs and XMLs prior to importing to P6.
-
Users required a fast way to prefix or remove roles in their XERs and XMLs.
-
Microsoft Project XMLs are provided by contractors. They wanted to also have the ability to edit these files prior to importing them into their P6 database.
Results
-
Deployed P6-Scrubber to facilitate the editing of XER and XML files.
-
Quick role prefixing or removing roles was needed, so Emerald added that option to the Simple Scrub module in P6-Scrubber.
-
MSP XML file scrubbing was added to the P6-Scrubber tool to facilitate the editing of these files.
Transportation Case Studies
P6-Scrubber News Articles
on Monday, 08 August 2022.
Posted in Case Studies
Custom checks created in P6-QA helped client
Helping Client Users Self-Monitor Schedule Quality
Written by Sue Hopkins
Client Overview
Client is an employee-owned, multi-disciplined engineering, planning, architectural, and environmental services firm in the United States. With nearly 700 employees spread between more than 30 offices in 12 states, they offer a wide range of services with a focus on aviation, construction, facilities design, federal, power, transportation, survey, and water. They sit in the top 150 of the Engineering News-Record's prestigious Top 500 Design Firms list, while Zweig Group has recognized the client as a best firm to work for in the multi-discipline category for six consecutive years.
Challenges
-
Needed a solution to coach their client users on scheduling best practices
-
Users required a way to monitor the quality of their schedules while creating schedules, as well as when they were in-flight
-
A specific set of quality checks were needed based on contract requirements and general quality guidelines
Results
-
Emerald Associates built additional checks and a custom report focusing on what was of importance to their team
-
P6-QA deployed on all databases to monitor project quality using out-of-the-box functions and customized checks
-
The DOT users are able to self-monitor their schedules without constant assistance from the firm saving countless hours of consulting time
Transportation Case Studies
on Monday, 11 July 2022.
Posted in Case Studies
Learn how a large engineering firm moved to the Emerald Cloud.
Emerald Cloud, Tools and Services - A Winning Combo
Written by Sue Hopkins
Client Overview
Client is an employee-owned multi-disciplined engineering, planning, architectural, and environmental services firm in the United States. With nearly 700 employees spread between more than 30 offices in 12 states, they offer a wide range of services with a focus on aviation, construction, facilities design, federal, power, transportation, survey, and water. They sit in the top 150 of the Engineering News-Record's prestigious Top 500 Design Firms list, while Zweig Group has recognized client as a best firm to work for in the multi-discipline category for six consecutive years.
Challenges
-
Client was looking for an alternative to the Oracle Cloud for them and the Department of Transportation (DOT) they were working with.
-
The Program Controls manager wanted faster response time on support tickets for four databases.
-
Needed a reliable environment for 80+ DOT users to fulfill their contract commitments.
Results
-
Moved hosting of four databases to the Emerald Cloud.
-
Decreased supported response time from days to hours
-
Able to bring their DOT client online with their environment in less than two months, including upgrade of P6 and rollout of new business processes.
-
Added a second DOT client to Emerald's hosting environment two years later.
Transportation Case Studies
EP-datawarehouse Case Studies
P6-Calculator Case Studies
P6-Scrubber News Articles
P6-Reporter News Articles
on Thursday, 17 June 2021.
Posted in Case Studies
Large Australian rail company uses the P6-Loader to integrate SAP to Primavera P6.
Monthly cost loading made easy for hundreds of projects.
Written by Nicole Jardin
Client Overview
Large railway projects need a tremendous amount of coordination and strong scheduling. Managing monthly costs and updates from several regional contractors so that shareholders can be informed of status can be a challenge.
Results
-
Streamlined the efforts of updating down from 4 person weeks to 2 person days. Data Imports by over 30%.
-
Errors and mismatches were reduced significantly
-
Several macros made this extract and upload much more reliable than manual inputs
-
Reloading every day during the update window was smooth
From Our Customer
SAP to P6 updates were easy to perform so that forecasting was much more accurate.
Integrations Case Studies
Transportation Case Studies
Primavera P6 Case Studies
on Sunday, 21 March 2021.
Posted in Case Studies
Transportation company uses P6-QA to ensure projects are managed consistently to meet tight timelines.
Critical Path and Contractor Deliveries
Written by Nicole Jardin
Client Overview
Providing ferry transport to thousands of people daily is no easy task. Ensuring customers have a good experience required overhauling customer service programs. This large IT program had many moving parts and the team needed a way to ensure all the projects within the programs were being managed consistently to meet very tight timelines.
Challenges
-
P6 was new and the users were running projects
-
No reliable critical path across the program
-
Forecasting was not coming together reliably
Results
-
P6-QA critiqued 20 projects during development
-
P6-QA highlighted open ends - allowed critical path schedule
-
P6-QA helped team see gaps in resourcing
-
Schedule review workshops to fix deficiencies
-
Better schedule development
Transportation Case Studies
on Wednesday, 16 December 2020.
Posted in Case Studies
Integration enables the management of work orders, tasks, relationships, resources, and resource assignments; providing synchronized scheduling and resource updates.
Emerald Associates created Work Orders from SAP Hana Cloud into P6 Azure Cloud for detailed task and resource management in P6 using Mulesoft and
the EAI P6 Cloud API. We created SAP Operations and supporting resources and resource limits as new resources are introduced in SAP.
- WBS - create/update SAP Operations into P6
- Tasks - create/update tasks from SAP operations
- Relationships - create/update relationships from SAP and allow P6 schedulers to change and update them back from P6
- Resources - create/update for new crews in SAP and set limits
- Resource Assignments - create/update resource assignments from SAP operations and sub-operations for detailed resource management
- P6 → SAP - return operation and sub-operation lists and relationships to update SAP with P6 schedule information
- Return task lists generated in P6
on Thursday, 15 June 2023.
Posted in Case Studies