(PM)-CONSTRUCTION PROJECT MANAGEMENT-Global Energy Co.
PROBLEM:
-A multi-billion-dollar capital project is very complex
-Primavera P6 project software is for experts only
-Many stakeholders need information but can't easily get it from Primavera P6
SOLUTION:
-Create intuitive 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
(HSSE)-HEALTH & SAFETY INCIDENTS-Global Energy Co.
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
(HSSE) COVID TREND ANALYSIS-Crisis Management Team
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
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
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
DATA SOURCES:
-Alberta government sources of policy
(CP)-WEATHER AUDIT ANALYSIS-Large Construction Site
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
(HR) 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