Fuzeium
  • Home
  • About
  • Demo
  • Contact
  • More
    • Home
    • About
    • Demo
    • Contact
Fuzeium
  • Home
  • About
  • Demo
  • Contact

Case Studies for Data-Driven Decisions with Power BI Dashboards

All solutions are customized to client needs, and each one enables data-driven decisions with Power BI dashboards.

All solutions were developed with Fuzeium's agile methodology.

CONSTRUCTION PROJECT MANAGEMENT

advanced power bi KPI dashboard for primavera p6 project management to simplify access to plan data

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

Try Live Demo

CONSTRUCTION Mechanical Completions (MC)

Capital project construstion mechanical completions dashboard built with Power bi

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

Try Live Demo

CONSTRUCTION Engineering Document Management (EDM)

Engineering document management power bi dashboards for capital construction management

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

Try Live Demo

HEALTH & SAFETY INCIDENTS

advanced power bi KPI dashboard for Health and Safety stats risk injuries vibrant visuals

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

Try Live Demo

COVID TREND ANALYSIS-Crisis Management Team

advanced power bi KPI dashboard for tracking COVID pandemic deaths, infections, vaccinations

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

Try Live Demo

LNG IN CANADA INDUSTRY OVERVIEW - Demo at LNG Conference

advanced power bi KPI dashboard for the liquified natural gas LNG  in Canada capital project BC

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

Try Live Demo

WEATHER AUDIT ANALYSIS-Large Construction Site

advanced power bi KPI data dashboard for environment Canada weather station 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 

Try Live Demo

RESOURCE MANAGEMENT - Employee Base & Recruiting KPIs

advanced power bi KPI dashboard for human resources HR management and recruiting

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 

Try Live Demo

EXECUTIVE FINANCIAL DASHBOARD-Oil & Gas Company

advanced power bi KPI dashboard for a conventional oil and 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

Try Live Demo

INNOVATION IDEA WORKFLOW - Managing Digital Innovation

advanced power bi KPI dashboard for innovation ideas funnel workflow steps to maturity with status

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 

Try Live Demo

EMISSIONS INTENSITY-ALBERTA OIL SANDS - USING 2019 DATA

advanced power bi KPI dashboard for TIER emissions carbon pricing Alberta benchmarking oil sands

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 

Try Live Demo

Fuzeium's agile approach is enabled by

Microsoft 365 /  OneDrive / Excel 

SharePoint / Power Platform

Microsoft Power BI Desktop, Dataflows, Gateway

Microsoft Power BI Online as Premium EM3 Gen2

Microsoft Azure Active Directory Premium / Hosting

Specialty programming software & cloud platforms

Publically available websites

Find out more

Copyright © 2023 Fuzeium - All Rights Reserved.  Privacy Policy & Terms of Use