While the ability to integrate future data from planning models as tables in PI-AF and do PvA analytics and visualization, the functionality and capability has been problematic. With the forthcoming release of future data storage in the PI Data Archive, coupled with advances in the PI System data access capabilities and Microsoft BI tools, the ability to perform model integration and plan vs. actual (PvA) analytics and visualization is improved significantly.
This short presentation will discuss ideas and concepts of advanced PvA analytics, visualization, and BI using future data, PI-PSA, and Microsoft BI tools such as Power View and Power Pivot. Fundamental to doing this is using the underlying PI-AF to help organize, contextualize, and abstract the future data from an external model (Plan) and actual data.
Curt Hertler is a Partner Solutions Architect at OSIsoft. Prior to this position, he was Business Development Manager for the Oil and Gas industry. Earlier in his OSIsoft career, he established and managed OSIsoft’s Developers Network. Hertler has 19 years in the petroleum refining industry working for Marathon Oil and British Petroleum. While at BP, he served five years on the National Petroleum Refiners Association Computer Applications Committee. He graduated with a BS and MS in Chemical Engineering from the University of Michigan.