- Getting Started
-
How to Navigate This Course
-
Discussion Forum
-
Offline Course Videos for Blocked YouTube Users
-
Course Workbook
- Training Cloud Environments
-
Launch Cloud Environment
- Lesson 1 - Welcome to the course!
-
Sample AF Databases
-
Goals
- Lesson 2 - Calculation Options in AF
-
Overview of Calculation Options
-
Formula Data Reference and Value Retrieval Modes
-
Introduction to Asset Analytics and the Analysis Service
- Lesson 3 - Creating Calculations with Formula Data References
-
Creating Formula Data References (6:26)
-
Knowledge Check: Create a simple calculation using a Formula Data Reference
-
Solution: Create a simple calculation using a Formula Data Reference
-
Referencing Attributes from other Levels of the Hierarchy
-
Splitting Calculations in Multiple Lines
-
Dealing with Missing Inputs and Results out of Range
- Lesson 4 - Working with Value Retrieval Modes
-
On Demand PI tag Summary Calcs using Value Retrieval Methods (9:53)
-
Knowledge Check: Creating Attributes using Value Retrieval Modes
-
Solution: Creating Attributes using Value Retrieval Modes
- Lesson 5 - Expression Syntax
-
Explore Analysis Syntax and Create an Expression Analysis (7:52)
-
Tips for Working with Expressions
-
Knowledge Check: Expression Analyses Syntax
-
Solution: Expression Analyses Syntax
-
Use Different Functions for Analyses (6:08)
-
Knowledge Check: Exploring Expression Analysis Functions
-
Solution: Exploring Expression Analysis Functions
- Lesson 6 - Creating Expression Analyses
-
Map Outputs of Analyses to Attributes (2:52)
-
Knowledge Check: Create Analyses to Calculate OEE Metrics
-
Solution: Create Analyses to Calculate OEE Metrics
-
Review Analysis Statuses, Scheduling, and Future Outputs (5:05)
-
Knowledge Check: Configure OEE Calculation Schedule
-
Solution: Configure OEE Calculation Schedule
-
Templatize Analyses (5:08)
-
Knowledge Check: Apply the OEE Calculation to Multiple Assets
-
Solution: Apply the OEE Calculation to Multiple Assets
- Optional - Using Expression Functions for Advanced Applications
-
Analyzing Asset Performance using a Correlation of Parameters
-
Implementing Condition Based Maintenance
-
Dynamically Reference Attributes through Analyses
- Lesson 7 - Configure Rollup Analyses
-
Create Rollup Analyses on Templates (9:36)
-
Knowledge Check: Identify the Total Production Rate for Each Site
-
Solution: Identify the Total Production Rate for Each Site
-
Explore Selection Options with Rollup Analyses
- Lesson 8 - Analysis Management
-
Manage Analyses in Bulk, and Backfill or Recalculate your Data (5:35)
-
Knowledge Check: Backfilling OEE Metrics
-
Solution: Backfilling OEE Metrics
-
Analysis Organization and Consolidation
- Lesson 9 - Best Practices for Using the PI Analysis Service
-
Best Practices
-
Optimizing Input Data Retrieval
-
Client vs. Server Calculations
-
Dependency Chain Overview (4:01)
-
Making Analyses easier to Read and Manage
-
Using UOMs in Equations
-
Data Density, Data Pattern and Scheduling
-
Handling Issues with Bad Data
-
Knowledge Check: Build Error Checking into an Analytic
-
Solution: Build Error Checking into an Analytic
-
Knowledge Check: Use Exit() Function to Optimize Conditional Calculations
-
Solution: Use Exit() Function to Optimize Conditional Calculations
-
Addressing Analyses in Error
- Lesson 10 - Troubleshoot Asset Analytics
-
Troubleshooting Analysis When Outputting Calc Failed (AF 2018) (11:46)
- Final Exam
-
Final Exam
- Course Evaluation
-
How did it go?
- Next Steps
-
Additional Resources
-
End of the course
Calculations and Asset Analytics
Learn how to create different types of calculations and analyses to gain more insight into your operational data.
In this course, you will learn how to create different types of asset analytics to gain more insight into your data. Using Asset Framework (AF), we will explore a range of calculation methods including formula and value retrieval modes for simple calculations, expressions with multi-line calculations, roll-ups for aggregate attributes.
By the end of the course, you will be able to...
- Use analysis syntax to create simple analyses
- Create different types of analyses: expressions and rollups
- Set up analyses using templates in AF
- Manage, backfill and recalculate analyses
Audience
This course is best suited for PI System users who are already familiar with the basics of Asset Framework and who are interested in creating asset based analytics.
Level: Intermediate
Study Time: 14 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
This course is for intermediate to advanced users of Asset Framework (AF) who are already familiar with the basics of AF such as:
- working with PI System Explorer (PSE)
- building and managing asset hierarchies in AF using templates
- working with different data reference types: table lookup, formula, PI Point, etc.
Students without prior knowledge of AF should take the Asset Framework: Basics online course first.
Software Requirements
Students are encouraged to use their own software and data structures. This allows each student to leave the course with something valuable to their enterprise. The software requirements for completing the exercises and are as follows:
- Access to Asset Framework 2018 or later (PI AF Server and PI AF Client) with Analysis Service set up (port 5463 needs to be open).
- Access to new AF databases with read/write permissions (i.e. permissions to modify and create templates, attributes and analyses).
- Access to the Data Archive with read/write permissions to create tags. Because analyses output tags are created in this course, access to a development or sandbox Data Archive server is encouraged.
* 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.
For this course you will also need a computer that can access our YouTube content, and pass our connection test
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
- A sharable certificate of completion
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
You can audit the full video lecture content right now on the OSIsoft Learning YouTube Channel