Unfortunately, we are experiencing an issue with our multiple-user registration functionality.

At this time, we suggest you register individuals one at a time for a class.

If you're experiencing recurring issues, we're here to help at: AVEVATraining@aveva.com

Our IT team is currently working on this issue. We will update you once the problem has been resolved.

Please accept our apologies for the inconvenience caused.

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.

rate limit

Code not recognized.

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.

Study time: 12 hours

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

Prerequisites

  • This class is intended for power users, application developers, and administrators who already have experience working with PI AF.
  • You will have a difficult time with this class if you come into it with zero PI System Experience as it assumes an intermediate level of experience with PI System Explorer, PI AF Server, and PI Analysis Service.

Software Requirements

The course will walk through a particular use case and will use a few files stored on a Training Cloud Environment. However, learners are encouraged to adapt the exercises and use their own software and data structures as they see fit. This allows each learner to immediately leave the course with something valuable to their enterprise. In order to replicate the exercises, you will need the following software:

Software

Version

PI DataLink

2019 SP1

Microsoft Office

2016

PI ODBC Driver

2016 R2

PI SQL Client

2018 R2

PI Integrator for Business Analytics Advanced Edition

2018 R2 SP1

PI OLEDB Enterprise

2019

Microsoft SQL Server

2016

PI Data Archive

2018 SP3

PI Asset Framework

2018 SP3

PI Vision

2019

* If you do not have access to a PI System you can use the included Training Cloud Environment. Go to the Training Cloud Environment section to learn more about it and deploy your cloud environments.

Course Includes...

  • This course is self-paced for your convenience. Thus, there are no live components to the course, nor are there required login hours.
  • Please use the course activities and exercises to gain hands-on experience working with key concepts.

Course Access: Unlimited access to all content except the Training Cloud Environment (TCE). You have 30 days access to the TCE starting on the day you access module section "Launch Cloud Environment". 

After those 30 days you can purchase additional access with one of the two options below:

Course Materials

Course Outline

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Course Workbook
  • Training Cloud Environments
  • 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.

Study time: 12 hours

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

Prerequisites

  • This class is intended for power users, application developers, and administrators who already have experience working with PI AF.
  • You will have a difficult time with this class if you come into it with zero PI System Experience as it assumes an intermediate level of experience with PI System Explorer, PI AF Server, and PI Analysis Service.

Software Requirements

The course will walk through a particular use case and will use a few files stored on a Training Cloud Environment. However, learners are encouraged to adapt the exercises and use their own software and data structures as they see fit. This allows each learner to immediately leave the course with something valuable to their enterprise. In order to replicate the exercises, you will need the following software:

Software

Version

PI DataLink

2019 SP1

Microsoft Office

2016

PI ODBC Driver

2016 R2

PI SQL Client

2018 R2

PI Integrator for Business Analytics Advanced Edition

2018 R2 SP1

PI OLEDB Enterprise

2019

Microsoft SQL Server

2016

PI Data Archive

2018 SP3

PI Asset Framework

2018 SP3

PI Vision

2019

* If you do not have access to a PI System you can use the included Training Cloud Environment. Go to the Training Cloud Environment section to learn more about it and deploy your cloud environments.

Course Includes...

  • This course is self-paced for your convenience. Thus, there are no live components to the course, nor are there required login hours.
  • Please use the course activities and exercises to gain hands-on experience working with key concepts.

Course Access: Unlimited access to all content except the Training Cloud Environment (TCE). You have 30 days access to the TCE starting on the day you access module section "Launch Cloud Environment". 

After those 30 days you can purchase additional access with one of the two options below:

Course Materials

Course Outline

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Course Workbook
  • Training Cloud Environments
  • 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