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.

Introduction to Data Science for PI System Professionals

NEW - engage in Data Science initiatives with your PI System data

rate limit

Code not recognized.

About this course

This lab is an introduction to Data Science concepts, for people who are familiar with using the basic PI tools. The scope of the lab is to introduce you to basic Data Science concepts and techniques, by going through the steps of a Data Science project example, from the formation of the Business Objective to Model Building and evaluation. The aim is to empower you in the process of engaging in Data Science initiatives. 

By the end of the course, you will be able to...

  • Publish PI datasets using PI Integrator for BA 
  • Explore data in Power BI, PI Vision, PI System Explorer 
  • Publish PI datasets to GCP end points and start analyzing/predicting the data using BigQuery ML 

Audience

This course is best suited for PI professionals familiar with basic PI tools that are trying to get started on data science projects. 

Level: Beginner

Study Time: 4 hours

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:

Prerequisites

  • Basic understanding of PI System and data flow (PI System Explorer, PI Vision) 
  • Basic directory navigation and management (Windows Explorer, creating and finding files) 
  • Basic Windows and Network security (why you log in, what is a domain, etc.) 
  • Familiarity with your real-time data sources (control systems, PLCs, OPC) 
  • A computer that can access our YouTube content, and pass our connection test
  • Browser with access to Google Cloud Platform (GCP) console (Chrome is highly recommended) 

Technical Prerequisites

  • Students will need to provide their own GCP account with at least free trial (billing) enabled. 
  • Students need to have the authorization to create a new project, or use an existing project in their GCP account. 
  • Have a GCP service account, or the ability to create a new one, with the following privilege at minimum (and create the JSON key).
  • BigQuery minimum permissions (this will be covered in the course): 
    • bigquery.datasets.create          
    • bigquery.datasets.get  
    • bigquery.datasets.update
    • bigquery.tables.create
    • bigquery.tables.list
    • bigquery.tables.delete
    • bigquery.tables.get       
    • bigquery.tables.update
  • BigQuery minimum roles:
    • roles/bigquery.dataEditor 

This Course Includes...

  • Videos, exercises and quizzes to help you learn the material
  • A Cloud Environment accessible for 30 days and configured to complete all the exercises in the course
  • 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 video lectures for instruction along with the course exercises to gain experience working with the key concepts presented.
  • There is a final quiz which you must pass to obtain a certificate of completion.
  • Once you register for a course, you will have access to the course materials 24/7 on this website.  

Further Information

  • This is a self-paced course. Any questions or assistance needed about the material can be asked in this course's space in the OSIsoft PI Square community
  • When you complete the examination at the end of the course, you will receive a certificate of completion which can be shared and directly posted on LinkedIn.
  • For more information about our Online Courses please visit our FAQ page

Course Material

Curriculum

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Offline Course Videos for Blocked YouTube Users
  • Course Workbook
  • Course Presentation
  • Training Cloud Environment
  • Launch Cloud Environment
  • Lesson 1 - Introduction
  • Introduction to Data Science, CRISM DM Methodology and the Business Objective [7:57]
  • Lesson 2 - Data Understanding
  • What data is available?
  • Data Understanding through PI Vision
  • Explore Generated Event Frames
  • Lesson 3 - Exploratory Data Analysis
  • Publish dataset using the PI Integrator for Business Analytics
  • Publishing to a CSV file [8:11]
  • Publishing to a GCP BigQuery [13:27]
  • Creating Reports for Data Exploration using Power BI (pt.1) [7:53]
  • Creating Reports for Data Exploration using Power BI (pt.2) [5:43]
  • Bivariate analysis in Power BI (pt.1)
  • Bivariate analysis in Power BI (pt.2) [4:33]
  • Lesson 4 - Modeling and Evaluation
  • Building a model in BigQuery ML
  • Loading the dataset [1:07]
  • [TEXT] Filtering, Feature Engineering and Feature selection
  • Filtering Feature Engineering and Feature Selection [6:57]
  • Introduction - How to choose the right model
  • How to choose the right model [5:16]
  • Introduction - Results Evaluation
  • Results Evaluation
  • Lesson 5 - Deployment
  • Bringing data back to PI
  • How did it go?
  • Course Evaluation
  • Final Exam
  • Final Exam

About this course

This lab is an introduction to Data Science concepts, for people who are familiar with using the basic PI tools. The scope of the lab is to introduce you to basic Data Science concepts and techniques, by going through the steps of a Data Science project example, from the formation of the Business Objective to Model Building and evaluation. The aim is to empower you in the process of engaging in Data Science initiatives. 

By the end of the course, you will be able to...

  • Publish PI datasets using PI Integrator for BA 
  • Explore data in Power BI, PI Vision, PI System Explorer 
  • Publish PI datasets to GCP end points and start analyzing/predicting the data using BigQuery ML 

Audience

This course is best suited for PI professionals familiar with basic PI tools that are trying to get started on data science projects. 

Level: Beginner

Study Time: 4 hours

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:

Prerequisites

  • Basic understanding of PI System and data flow (PI System Explorer, PI Vision) 
  • Basic directory navigation and management (Windows Explorer, creating and finding files) 
  • Basic Windows and Network security (why you log in, what is a domain, etc.) 
  • Familiarity with your real-time data sources (control systems, PLCs, OPC) 
  • A computer that can access our YouTube content, and pass our connection test
  • Browser with access to Google Cloud Platform (GCP) console (Chrome is highly recommended) 

Technical Prerequisites

  • Students will need to provide their own GCP account with at least free trial (billing) enabled. 
  • Students need to have the authorization to create a new project, or use an existing project in their GCP account. 
  • Have a GCP service account, or the ability to create a new one, with the following privilege at minimum (and create the JSON key).
  • BigQuery minimum permissions (this will be covered in the course): 
    • bigquery.datasets.create          
    • bigquery.datasets.get  
    • bigquery.datasets.update
    • bigquery.tables.create
    • bigquery.tables.list
    • bigquery.tables.delete
    • bigquery.tables.get       
    • bigquery.tables.update
  • BigQuery minimum roles:
    • roles/bigquery.dataEditor 

This Course Includes...

  • Videos, exercises and quizzes to help you learn the material
  • A Cloud Environment accessible for 30 days and configured to complete all the exercises in the course
  • 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 video lectures for instruction along with the course exercises to gain experience working with the key concepts presented.
  • There is a final quiz which you must pass to obtain a certificate of completion.
  • Once you register for a course, you will have access to the course materials 24/7 on this website.  

Further Information

  • This is a self-paced course. Any questions or assistance needed about the material can be asked in this course's space in the OSIsoft PI Square community
  • When you complete the examination at the end of the course, you will receive a certificate of completion which can be shared and directly posted on LinkedIn.
  • For more information about our Online Courses please visit our FAQ page

Course Material

Curriculum

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Offline Course Videos for Blocked YouTube Users
  • Course Workbook
  • Course Presentation
  • Training Cloud Environment
  • Launch Cloud Environment
  • Lesson 1 - Introduction
  • Introduction to Data Science, CRISM DM Methodology and the Business Objective [7:57]
  • Lesson 2 - Data Understanding
  • What data is available?
  • Data Understanding through PI Vision
  • Explore Generated Event Frames
  • Lesson 3 - Exploratory Data Analysis
  • Publish dataset using the PI Integrator for Business Analytics
  • Publishing to a CSV file [8:11]
  • Publishing to a GCP BigQuery [13:27]
  • Creating Reports for Data Exploration using Power BI (pt.1) [7:53]
  • Creating Reports for Data Exploration using Power BI (pt.2) [5:43]
  • Bivariate analysis in Power BI (pt.1)
  • Bivariate analysis in Power BI (pt.2) [4:33]
  • Lesson 4 - Modeling and Evaluation
  • Building a model in BigQuery ML
  • Loading the dataset [1:07]
  • [TEXT] Filtering, Feature Engineering and Feature selection
  • Filtering Feature Engineering and Feature Selection [6:57]
  • Introduction - How to choose the right model
  • How to choose the right model [5:16]
  • Introduction - Results Evaluation
  • Results Evaluation
  • Lesson 5 - Deployment
  • Bringing data back to PI
  • How did it go?
  • Course Evaluation
  • Final Exam
  • Final Exam