The Analyzing PI System Data course is focused on analyzing PI System data through Business Intelligence (BI) and reporting tools. The class will cover aspects of the following tools: The new RTQP Engine (PI SQL Client), PI Integrator for Business Analytics, PI OLEDB Enterprise, Microsoft Excel, Microsoft Power BI, and SQL Server Reporting Services (SSRS) Report Builder. 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.
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.
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.
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 Course Content