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 a client's P6 experience was improved with training, implementation, and EAI tools.
Emerald tools added enhanced functionality and efficiency
Client Overview
Client provides marine-related services to the Pacific Northwest. Within the group are three shipyards, an intermodal ferry and car float business, and also a tug and barge transportation company that serves both domestic and international markets.
Challenges
-
With the implementation of an integrated PMO System, they requested assistance as to best practices in the usage of P6.
-
Needed a better scheduling and project management reporting process.
-
Needed to upgrade their Primavera P6 to a new version and clean up their database.
Results
-
Emerald created additional databases in the hosted environment to add an archive and sandbox environment.
-
Emerald assisted with creation of a security structure to ease user access management.
-
Emerald worked with their team to address taking advantage of P6 coding, UDFs, and WBS structures for best reporting and EV results.
-
Emerald upgraded P6 and presented P6 training.
-
P6-Loader, P6-Auditor & EP-datawarehouse (now P6-Reporter) were added to the tools available to P6 users for enhanced functionality and efficiency.
Primavera P6 Case Studies
EP-datawarehouse Case Studies
P6-Reporter News Articles
on Monday, 30 January 2023.
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
Learn how this refinery used P6-Loader and TAPS to improve accuracy and speed when working with data in their P6 schedules and how they used EP-datawarehouse and custom dashboards to help with cost control and management visibility for their turnarounds.
Cost controls more effective and schedule updating more streamlined
Written by Sue Hopkins
Client Overview
Client is one of North America's largest integrated energy companies. Their Lima refinery was looking for a way to improve their turnarounds and create custom dashboards for better visibility for management.
Results
-
Emerald's Turnaround Productivity Package - TAPS, P6-Loader, EP-dashboard, and EP-datawarehouse was implemented
-
Schedule updates are now completed in less than a quarter of the time. Updating takes a matter of minutes using TAPS, rather than several hours
-
P6-Loader streamlined the addition of found work to both the working schedule and the baseline schedule
-
EP-datawarehouse is used to store snapshotted data for multiple uses for EV and Trending
-
EP-dashboards utilize the snapshot data to create custom dashboards for management including Green-Ups, Inspections and S-Curves
From Our Customer
"Coming in at 6am instead of 4am each day made a big difference to our team; not only on a daily basis but by not being exhausted at the end of the turnaround. TAPS saved 600 grueling hours.”
EP-datawarehouse Case Studies
P6-Reporter News Articles
on Wednesday, 24 March 2021.
Posted in Case Studies
EP-datawarehouse is a standalone reporting database created by Emerald Associates that gives Primavera P6 users the ability to securely take snapshots of projects in Primavera P6 and more. EP-datawarehouse provides superior reporting capabilities compared to Oracle's Primavera P6 Analytics and specifically the Primavera P6 Reporting Database.
EP-datawarehouse Case Studies
on Friday, 16 August 2013.