BI Reporting with PI Integrator for Business Analytics

BI Reporting with PI Integrator for Business Analytics explores PI System data with Power BI and PI Integrator for Business Analytics.

About this course

Introduction

The BI Reporting with PI Integrator for Business Analytics online course is focused on analyzing PI System data using Power BI and PI Integrator for Business Analytics. If you feel like writing business reports is too difficult, this may be the course for you. We will build upon your existing application knowledge with hands-on activities to help you transform data into information.

Audience

This course is intended for power users and administrators who already have some experience working with PI AF. The course assumes an intermediate level of experience with PI System Explorer, PI AF Server, and PI Analysis Service.

The course is devoted to analyzing your business data. Related data is everywhere throughout the various systems we employ to monitor our business and can require convoluted steps to combine the data into a single report. The goal of this course is to work with the tools available from Microsoft and OSIsoft to bring disparate data together in one report.

  • Understand how leverage the power of AF Templates to provide dimensions for slicing and dicing process data
  • Combine Production Data with External Data using Business Intelligence tools

Course Materials

Downloadable Workbook link

Course Outline

  • Getting Started
  • Key Course Information
  • Course Grading Scheme
  • How to Navigate This Course
  • Workbook to Download
  • Training Cloud Environments
  • Cloud Environments Introduction
  • Cloud Environments Instructions (Update the PISquare link)
  • Launch Cloud Environment
  • Lesson 1: Business Intelligence
  • Business Intelligence and PI Asset Framework
  • Activity: Introduction to Power BI
  • Lesson 2: Power BI Reports using PI Integrator for BA
  • Data Set Review
  • Lesson 3: PI Integrator for Business Analytics
  • Architecture and Navigation
  • Activity: Create the Transformer Loading View
  • Lesson 4: Building the Distribution Network Reports
  • Importing Data into Power BI
  • Building the Report Visuals
  • Lesson 5: Building the Fleet Generation Report
  • The Online Fleet Generation Database
  • Preparing and Importing the Tables
  • Activity: Publish Unit Specification (static data) Table
  • Activity: Publish Unit Performance (dynamic data) Table
  • Activity: Import the Unit Specifications and Unit Performance Tables
  • Activity: Create Table Relationships
  • Augmenting the Data using DAX
  • Calculate the Generation Cost
  • Add Column for Day of the Week and Sort
  • Activity: Build the Report
  • Solution: Build the Report
  • Final Challenge: Fleet Generation Report with Event Frames
  • Event Frames with PI Integrator for Business Analytics
  • Activity: Create an Event View with PI Integrator for BA
  • Activity: Build the Report
  • Final Exam
  • Final Exam - QUIZ
  • Course Evaluation
  • How did it go?
  • Next Steps
  • Additional Resources

About this course

Introduction

The BI Reporting with PI Integrator for Business Analytics online course is focused on analyzing PI System data using Power BI and PI Integrator for Business Analytics. If you feel like writing business reports is too difficult, this may be the course for you. We will build upon your existing application knowledge with hands-on activities to help you transform data into information.

Audience

This course is intended for power users and administrators who already have some experience working with PI AF. The course assumes an intermediate level of experience with PI System Explorer, PI AF Server, and PI Analysis Service.

The course is devoted to analyzing your business data. Related data is everywhere throughout the various systems we employ to monitor our business and can require convoluted steps to combine the data into a single report. The goal of this course is to work with the tools available from Microsoft and OSIsoft to bring disparate data together in one report.

  • Understand how leverage the power of AF Templates to provide dimensions for slicing and dicing process data
  • Combine Production Data with External Data using Business Intelligence tools

Course Materials

Downloadable Workbook link

Course Outline

  • Getting Started
  • Key Course Information
  • Course Grading Scheme
  • How to Navigate This Course
  • Workbook to Download
  • Training Cloud Environments
  • Cloud Environments Introduction
  • Cloud Environments Instructions (Update the PISquare link)
  • Launch Cloud Environment
  • Lesson 1: Business Intelligence
  • Business Intelligence and PI Asset Framework
  • Activity: Introduction to Power BI
  • Lesson 2: Power BI Reports using PI Integrator for BA
  • Data Set Review
  • Lesson 3: PI Integrator for Business Analytics
  • Architecture and Navigation
  • Activity: Create the Transformer Loading View
  • Lesson 4: Building the Distribution Network Reports
  • Importing Data into Power BI
  • Building the Report Visuals
  • Lesson 5: Building the Fleet Generation Report
  • The Online Fleet Generation Database
  • Preparing and Importing the Tables
  • Activity: Publish Unit Specification (static data) Table
  • Activity: Publish Unit Performance (dynamic data) Table
  • Activity: Import the Unit Specifications and Unit Performance Tables
  • Activity: Create Table Relationships
  • Augmenting the Data using DAX
  • Calculate the Generation Cost
  • Add Column for Day of the Week and Sort
  • Activity: Build the Report
  • Solution: Build the Report
  • Final Challenge: Fleet Generation Report with Event Frames
  • Event Frames with PI Integrator for Business Analytics
  • Activity: Create an Event View with PI Integrator for BA
  • Activity: Build the Report
  • Final Exam
  • Final Exam - QUIZ
  • Course Evaluation
  • How did it go?
  • Next Steps
  • Additional Resources