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.

[Archive] PI DataLink: Basics

Learn how to use PI DataLInk (MS Excel add-in) to access your process data, create meaningful reports, and use them to make key decisions about your plant performance.

Not currently available

rate limit

Code not recognized.

About this course

In this course, you will learn how to use this tool to access your process data, create meaningful reports, and use them to make key decisions about your plant performance. PI DataLink is our add-in that allows users to access and deliver data to and from Microsoft Excel and create easy-to-read reports.

This course was previously titled: Creating Basic Reports with PI DataLink

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

  • Understand the PI System Basics
  • Search for PI Tags and AF Attributes in PI DataLink
  • Identify which PI DataLink function to use for your report
  • Get current and historical PI data in PI DataLink
  • Build reports with key KPIs
  • Interpolate data with custom intervals
  • Use calculated data
  • Build reusable daily report

Audience

This course is for beginning users of PI System data and is open to anyone who wishes to learn more about PI DataLink. if you're a process engineer or a plant operator and are interested in learning about the key features of PI DataLink, how to process data, and create meaningful reports that your end users could use - then this course will be useful for you.

Level: Introductory

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

  • Familiarity with MS Excel is helpful. No specific knowledge of the PI System software is required.
  • A computer that can access our YouTube content, and pass our connection test

Software Requirements

Learners are encouraged to use their own software and data structures whenever possible. This allows each learner to immediately leave the course with something valuable to their enterprise. In order to complete the exercises and the final project, you need to have the following software installed: 

  • PI DataLink 2013 or later (connected to PI Data Archive and Asset Framework)

* 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 at the end of the course to learn more about it and deploy your cloud environments.

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 hands-on experience working with key concepts
  • There are 4 hands-on knowledge checks tailored to apply the knowledge you've learned in the video lectures
  • There is also a 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 Materials

Course Outline

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Offline Course Videos for Blocked YouTube Users
  • Course Workbook
  • (Optional) Importing Generic AF Databases (5:59)
  • Training Cloud Environments
  • Launch Cloud Environment
  • Lesson 1 - PI System Basics
  • Map of the PI System (6:47)
  • Time in PI System (11:44)
  • What are PI Assets, Attributes and Tags? (13:45)
  • Connect to and Search a PI System (22:15)
  • Knowledge Check: Draw Your PI System
  • Lesson 2 - PI DataLink Basics
  • What is PI DataLink? (2:38)
  • Mind Map of PI DataLink (5:42)
  • Search for PI Tags and PI AF Attributes in PI DataLink (3:20)
  • Get Instantaneous PI Data with PI Current Value Function (4:44)
  • Get Historical PI Data with PI Archive Value Function (3:21)
  • Use Root Path References for Stronger Spreadsheet (5:30)
  • Build KPI Reports in PI DataLink (9:51)
  • Knowledge Check: Build a KPI Report
  • Lesson 3 - Compressed Data, Sampled Data and Calculated Data
  • Get Raw PI Data with PI Compressed Data Function (3:49)
  • Get Custom Interval PI Data with PI Sampled Data Function (4:45)
  • Functions Returning Data
  • Single Value Queries
  • Multiple Value Queries
  • Table of PI Data Item (Columns) Against Time (Row) (3:22)
  • Interpolation and Retrieval Modes in PI DataLink (4:42)
  • Get Time-Summary Calculations with PI Calculated Data Function (6:25)
  • Knowledge Check: Build a Daily Report
  • Totalize and Integrate with the PI Calculated Data Function (7:01)
  • Build a Report with Data Queries (10:24)
  • Build a Reusable Daily Report (14:08)
  • Knowledge Check: Build a Report with Calculations for your Assets
  • Final Exam
  • Final Exam
  • Course Evaluation
  • How did it go?
  • Next Steps
  • Additional Learning Resources
  • End of the course

About this course

In this course, you will learn how to use this tool to access your process data, create meaningful reports, and use them to make key decisions about your plant performance. PI DataLink is our add-in that allows users to access and deliver data to and from Microsoft Excel and create easy-to-read reports.

This course was previously titled: Creating Basic Reports with PI DataLink

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

  • Understand the PI System Basics
  • Search for PI Tags and AF Attributes in PI DataLink
  • Identify which PI DataLink function to use for your report
  • Get current and historical PI data in PI DataLink
  • Build reports with key KPIs
  • Interpolate data with custom intervals
  • Use calculated data
  • Build reusable daily report

Audience

This course is for beginning users of PI System data and is open to anyone who wishes to learn more about PI DataLink. if you're a process engineer or a plant operator and are interested in learning about the key features of PI DataLink, how to process data, and create meaningful reports that your end users could use - then this course will be useful for you.

Level: Introductory

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

  • Familiarity with MS Excel is helpful. No specific knowledge of the PI System software is required.
  • A computer that can access our YouTube content, and pass our connection test

Software Requirements

Learners are encouraged to use their own software and data structures whenever possible. This allows each learner to immediately leave the course with something valuable to their enterprise. In order to complete the exercises and the final project, you need to have the following software installed: 

  • PI DataLink 2013 or later (connected to PI Data Archive and Asset Framework)

* 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 at the end of the course to learn more about it and deploy your cloud environments.

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 hands-on experience working with key concepts
  • There are 4 hands-on knowledge checks tailored to apply the knowledge you've learned in the video lectures
  • There is also a 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 Materials

Course Outline

  • Getting Started
  • How to Navigate This Course
  • Discussion Forum
  • Offline Course Videos for Blocked YouTube Users
  • Course Workbook
  • (Optional) Importing Generic AF Databases (5:59)
  • Training Cloud Environments
  • Launch Cloud Environment
  • Lesson 1 - PI System Basics
  • Map of the PI System (6:47)
  • Time in PI System (11:44)
  • What are PI Assets, Attributes and Tags? (13:45)
  • Connect to and Search a PI System (22:15)
  • Knowledge Check: Draw Your PI System
  • Lesson 2 - PI DataLink Basics
  • What is PI DataLink? (2:38)
  • Mind Map of PI DataLink (5:42)
  • Search for PI Tags and PI AF Attributes in PI DataLink (3:20)
  • Get Instantaneous PI Data with PI Current Value Function (4:44)
  • Get Historical PI Data with PI Archive Value Function (3:21)
  • Use Root Path References for Stronger Spreadsheet (5:30)
  • Build KPI Reports in PI DataLink (9:51)
  • Knowledge Check: Build a KPI Report
  • Lesson 3 - Compressed Data, Sampled Data and Calculated Data
  • Get Raw PI Data with PI Compressed Data Function (3:49)
  • Get Custom Interval PI Data with PI Sampled Data Function (4:45)
  • Functions Returning Data
  • Single Value Queries
  • Multiple Value Queries
  • Table of PI Data Item (Columns) Against Time (Row) (3:22)
  • Interpolation and Retrieval Modes in PI DataLink (4:42)
  • Get Time-Summary Calculations with PI Calculated Data Function (6:25)
  • Knowledge Check: Build a Daily Report
  • Totalize and Integrate with the PI Calculated Data Function (7:01)
  • Build a Report with Data Queries (10:24)
  • Build a Reusable Daily Report (14:08)
  • Knowledge Check: Build a Report with Calculations for your Assets
  • Final Exam
  • Final Exam
  • Course Evaluation
  • How did it go?
  • Next Steps
  • Additional Learning Resources
  • End of the course