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.

(PM)-CONSTRUCTION PROJECT MANAGEMENT-Global Energy Co.

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

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

(HSSE)-HEALTH & SAFETY INCIDENTS-Global Energy Co.

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

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

(HSSE) COVID TREND ANALYSIS-Crisis Management Team

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

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

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

(Finance)-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

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

(CP)-WEATHER AUDIT ANALYSIS-Large Construction Site

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

Try Live Demo

(HR) 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

(RD) 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