Description

Power BI Training for Facility Management Professionals (2 Days)

Transform your approach to facility management with our specialized Power BI training course. Tailored exclusively for facility management professionals, this 2-day course empowers you to leverage data for optimizing building operations, maintenance schedules, energy efficiency, and space utilization. Delivered online, this course allows you to join from anywhere in the UK or beyond, making it accessible and convenient for all.

COURSE OUTLINE

Understanding Facility Management Data

Key Data Sources in Facility Management

Building Information Modeling (BIM) Data

Data Attributes and Requirements

Data Accuracy and Completeness

Data Collection and Integration

Integrating Data from Disparate Systems

Connecting to CMMS, EMS, and AMS Systems

Data Cleaning and Preprocessing

Handling Missing Data

Data Integration Best Practices

Using Power Query for Data Transformation

Designing Facility Management Dashboards

Key Performance Indicators (KPIs) in Facility Management

Maintenance KPIs (Mean Time Between Failures, Work Order Completion Rates)

User-Centric Dashboard Design

Understanding Stakeholder Requirements

Visualizing Facility Management Data

Best Practices for Time Series Data Visualization

Advanced Data Modeling for Facility Management

Creating and Managing Relationships Between Data Tables

Modeling Relationships Between Assets, Work Orders, and Locations

Time Intelligence in Facility Management

Implementing Time Intelligence for Maintenance Scheduling

Calculating Metrics with DAX

DAX for Maintenance Metrics (MTBF, MTTR)

Energy Management and Sustainability

Energy Consumption Analysis

Analyzing and Visualizing Energy Usage Patterns

Sustainability Reporting and Compliance

Tracking Carbon Footprint and Emissions

Maintenance and Asset Management

Work Order and Maintenance Tracking

Monitoring Work Order Backlogs and Completion Times

Asset Lifecycle Management

Tracking Asset Performance Over Time

Space and Occupancy Management

Space Utilization Analysis

Monitoring Occupancy Trends and Patterns

Occupancy Forecasting and Planning

Forecasting Future Space Needs