CONSTRUCTION PROJECT MANAGEMENT
A Multi-Billion Dollar Project Requires Countless Decisions--Please Dashboard That!
PROBLEM:
-A multi-billion-dollar energy capital construction project is very complex
-Primavera P6 project software is for experts only
-Many stakeholders need information but can't quickly get it from Primavera P6
SOLUTION:
-Create intuitive Power BI dashboards to simplify access to pertinent info
-Leverage Primavera P6 data
-Publish broadly to 70+ stakeholders
BENEFITS:
-Reduction in manual/paperwork
-Single source of truth
-Data-driven decisions
-Drive accountability
DATA SOURCES:
-Primavera P6 Extracts *Direct access to tables was not possible in this case
-Internal Excel Spreadsheets
CONSTRUCTION Mechanical Completions (MC)
Ensure Careful Completion of Mechanical Completions
PROBLEM:
-Managing the MC phase of a large capital construction project is a detailed process
-Effective coordination was being impeded by data and organizational silos
-For the data that did exist, its level of quality was not fully understood
-New data would have to be created and aligned with the document management system
-The situation was anticipated to get worse as the completion activities increased
SOLUTION:
-Developed interactive and intuitive Microsoft Power BI dashboards that allowed easy access to data related to MC
-Created standard visuals like S-Curves, system skylines, and completion status breakdowns
-Developed features like Inspection and Test Report (ITR) Readiness and ITR Counts for quality assurance
-RASCI assignments for better role delineation
-Published the dashboards in a cloud environment accessible to all stakeholders
BENEFITS:
-Greater control over the MC phase of the project
-A single source of truth allowing for quick identification of potential delays and quality issues
-Better role clarity and accountability through RASCI assignments
-Increased stakeholder engagement and improved decision-making process
-Decrease in paperwork and manual tasks
DATA SOURCES:
-Internal Excel Spreadsheets
-SQL database
CONSTRUCTION Engineering Document Management (EDM)
Breathing Life into the Cycle of Engineering Document Management
PROBLEM:
- A large-scale construction project had to manage hundreds of thousands of engineering documents
- The documents had lifecycles with numerous steps that needed to be tracked
- With hundreds of reviewers, it was a large workflow and coordination effort
- Numerous large-scale spreadsheets were involved, along with specialized backend systems
- Risk was increasing that the client was not in management control
SOLUTION:
-Developed interactive and intuitive Microsoft Power BI dashboards that depicted document status
-Created custom visuals to show status according to categories such as disciplines, systems, block/units
-Created insight by depicting progress over time and forecasting the future
-Published the dashboards in a cloud environment accessible to all stakeholders
-Simplified access to complicated back-end systems
BENEFITS:
-Workflow help for engineers and document controllers by identifying their progress and outstanding work
-Trending analysis demonstrated where effort had to be focused
-Drove accountability into areas within the client but also with their EPC*
* Engineering Procurement & Construction (EPC) company
DATA SOURCES:
-Internal Excel Spreadsheets
-Smart Plant Foundations
-Assai
HEALTH & SAFETY INCIDENTS
There's No Harm in Playing it Safe With Safety Dashboards.
PROBLEM:
-HSSE monitoring and management is critical to energy companies
-Many tracking systems are involved
-Many manual spreadsheets
-Data prep is error-prone and PowerPoints time-consuming
SOLUTION:
-Consolidation of numerous sources and data error correction
-Provision of insightful and interesting visuals
-Published to key stakeholders
BENEFITS:
-Significant reduction in work and scaled to growth within the company
-Flexibly dealt with changes in the backend data sources
-Standardized insightful reports for all stakeholders
DATA SOURCES:
-Sphera Cloud-API
-FIM extracts
-Internal manual spreadsheets
-External contractor data extracts
COVID TREND ANALYSIS-Crisis Management Team
Please Bring Into Focus What is Going On With The Global Pandemic
PROBLEM:
-Emergence of a global pandemic threatening the health of employees and contractors
-Potential impact on the company's global supply chain
-Significant ambiguity both internally and externally
-Evolving situation with multiple and conflicting information sources
SOLUTION:
-Simplify the situation and bring focus to key jurisdictions
-Build standard KPIs, and devise unique KPIs, filtered by jurisdiction
-Find reliable sources of data on the internet
-Integrate data into a common data model
-Iteratively evolve the solution as the pandemic evolved
BENEFITS:
-Simplified the information and enabled focused insight into key jurisdictions
-Aided decision-making by a crisis management team.
DATA SOURCES:
-Johns Hopkins-API for core global trending
-~20 other web-based sources to complement the core data
-Manual spreadsheets to enable customization
LNG IN CANADA INDUSTRY OVERVIEW - Demo at LNG Conference
Canada Doesn't Seem to Have Much of an LNG Industry...But Can We See What is Going On?
PROBLEM:
-Canada's LNG industry is underdeveloped and not well understood
-Other regions in the world have developed their LNG sectors
-There is data from multiple sources but it is hard to derive insight
SOLUTION:
-Demonstrate how public data can be used to provide insight
-Gather numerous data sources and integrate them into intuitive data dashboards
-Show the information as Import and Export facilities and projects
BENEFITS:
-Demonstrate the art of the possible
-Stimulate informed conversations about the subject
DATA SOURCES:
-Canadian government sources for import/export data
-~20 other sources to enhance understanding to prep data
-Note: the data used in the demo is no longer current
WEATHER AUDIT ANALYSIS-Large Construction Site
We Need to Know Whether Weather Has Had Exceptional Events
PROBLEM:
-Construction sites are complex and hazardous
-During inclement weather, risks increase
-Tracking details of past weather events is challenging
-Multiple and complex data sources
-Contracts and procurement (CP) audit situations
SOLUTION:
-Download and interpret weather station data as a stream
-Automatic analysis in relation to contractual limits for rain, snow
-Design and deploy intuitive dashboards to stakeholders
BENEFITS:
-Brand new capability; avoided inefficiencies
-Useful in contract disputes about "stop work" orders
-Potential to analyze against HSSE incident data
DATA SOURCES:
-Environment Canada Weather Station data
*large volume of device data, specially formatted in XML
-Manually constructed spreadsheets
RESOURCE MANAGEMENT - Employee Base & Recruiting KPIs
PROBLEM:
- Inefficient and time-consuming process to report HR KPIs
- Multiple spreadsheets
- Data collection inefficient and error prone
- Static PowerPoints
SOLUTION:
-Brought multiple excel data sources and a cloud system together into a common data model
-Standardized KPIs using intuitive dashboards
-Published to stakeholders
BENEFITS:
-Significantly reduced inefficient spreadsheet and PowerPoint work
-Standardized reporting for HR stakeholders
-Enabled more accurate resource planning
DATA SOURCES:
-SAP Extracts
-External HR cloud API
-Internal Excel Spreadsheets
EXECUTIVE FINANCIAL DASHBOARD-Oil & Gas Company
PROBLEM:
-Oil & Gas companies face complex capital and commodity market data
-There are many sources of data, conversion factors, currencies, etc.
-The executive team needs to be aware on a daily basis
-The executive team needs to properly inform the board
PROBLEM:
-Oil & Gas companies face complex capital and commodity market data
-There are many sources of data, conversion factors, currencies, etc.
-The executive team needs to be aware on a daily basis
-The executive team needs to properly inform the board
SOLUTION:
-Design a dashboard solution to integrate relevant data sources
-The executive's way of narrating to the board influenced the visual design
-Use an automated subscription feature to broadcast a PDF version of the dashboard weekly
BENEFITS:
-Reduction in tedious work through automation and publishing
-Standardize the information and the narrative structure for consistency
-Allow personnel to focus on matters other than the compilation of info
DATA SOURCES:
-Google Finance, Yahoo Finance, US Energy Information Administration (EAI), Wall Street Journal, GLJ
-Small internal spreadsheets to enhance the data model
INNOVATION IDEA WORKFLOW - Managing Digital Innovation
PROBLEM:
- A need to improve digital capabilities in the organization
- Too many ideas from too many groups and individuals
- Difficult to know what to invest in and by how much
SOLUTION:
-Use a cloud platform to capture ideas from various internal sources
-Create a business workflow with SharePoint and Excell to manage projects
-Use both as sources of data to demonstrate the stage of workflow ideas
-Leverage data dashboards as a way to convey progress easily
BENEFITS:
-Bring order & discipline to a chaotic stream of new ideas
-Enable data-driven decisions by seeing progress and identifying interventions
-Assure the right ideas are being worked on
DATA SOURCES:
-Brightidea - Cloud Platform
-SharePoint Lists
-Internal Excel Spreadsheets
EMISSIONS INTENSITY-ALBERTA OIL SANDS - USING 2019 DATA
PROBLEM:
-Challenging to understand how to compare facilities on emissions intensity in Alberta
-The Alberta policy in place is called TIER, but it requires expertise to understand
SOLUTION:
-Demonstrate how to use publically available policy and data
-Show this as a presentation at the Carbon Tracking & Reporting conference in Calgary Nov 2022
BENEFITS:
-Demonstrate the art of the possible
-Stimulate discussions on the subject
-Convert policy rules into programming logic and then visuals
DATA SOURCES:
-Alberta government sources of policy