(PM)-CONSTRUCTION PROJECT MANAGEMENT-Global Energy Co.
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
(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
(Finance)-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
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
(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
(RD) 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