Shopping CartCart (Empty)
click cart to proceed to checkout
st-widget-{image: PI Developers Club Free Trial.png}

st-widget-{image: Learning_Paths_292x150_03.jpg}

Did you know we have over 1,000 videos for you FREE on YouTube to teach you everything from a simple trend to complex calculations? Click the link below to check it out.

PI Square PI Square

YouTube See us on YouTube

Facebook Like us on Facebook


Analyzing PI System Data


The Analyzing PI System Data course is data oriented concentrating on viewing the PI System data, combining PI System data with other data, and creating reports allowing the analysis of the data through Business Intelligence (BI) tools. This class will teach you about different clients and tools to view your PI Data. Learn how to import PI System Data through the PI Integrator for Business Analytics and PI OLEDB Enterprise, and merge it with external data to create easy-to-read reports, reduce reports associated with related data, and publishing reports allowing easy sharing and ensuring one version of the truth being the focal point. The class will cover aspects of the following tools; PI Integrator for Business Analytics, PI OLEDB Enterprise, Microsoft Excel, and Microsoft Power BI. 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 slice and dice your business data.

The class is 3 days long. Class will begin promptly at 8:30am (9am outside North America) and is scheduled to end at 4:30pm with a one-hour lunch break. When making travel arrangement for the class, please plan to remain on site to the completion of the final exercise. This should be no later than 4:30 on the last day of the class.

Note: OSIsoft Learning Group is preparing documentation to obtain IACET accreditation to offer Continuing Education Units (CEUs). Upon successful completion of IACET assessment, the course description will be updated with CEUs instead of classroom instruction hours.


The class is geared for the experienced PI System tools user. The expected audience should have work experience and knowledge of PI System Data, PI DataLink, AF templates and data references, and PI Performance Equations. Potential students include engineers, production managers, project team members, information system analysts, and computer support personnel.


We will not be teaching the basics on any of the products or tools used in this course. Suggested prerequisite skills include a working knowledge of PI AF, PI DataLink, Microsoft Excel, and business reporting knowledge. An understanding of the current business requirements of your company is also an asset.

Class Outline

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 help build a BI Cube
  • Review Event Frames and how to query them for the PI Integrator for Business Analytics and PI OLEDB Enterprise
  • Combining Production Data with External Data using Business Intelligence tools
  • Slicing and Dicing Data for Understanding

Download the workbook for preview or self-study in the following languages :