WIXLIB

Analytics and Big Datawith the PI System Visual AnalyticsPresented by John Baier – Director of Integration Technologies, OSIsoftDon Morrison – Real Time Data Integration, Devon Energy Copyright 2015 OSIsoft, LLC

Plant EnterpriseOperationsDistributed AssetMonitoringInternet of Things andM2M Small # Assets Diverse / Complicated Optimization Mostly On-premise Medium # Assets Similar / Dispersed Remote Monitoring Enterprise / Cloud Massive # Assets Relatively Simple Analytics / Big Data Mostly CloudHybrid / Cloud Environment – OSIsoft Focus Copyright 2015 OSIsoft, LLC3

Evolving Data GoalsReal-timevisibilityHMIMonitoringReal-timeand historicalview acrossall assetsPI Coresight,PI DataLink,PI ProcessBookProcess ionandPreventionBusiness IntelligenceBig Data AnalyticsBenchmarkingSystem Optimization Copyright 2015 OSIsoft, LLC4

Big Expectations64% of large enterprises plan toimplement a big data project. 85%will be unsuccessful.Data cleansing and preparation tasks cantake 50-80% of the development timeand ge/ Copyright 2015 OSIsoft, LLC5

Why has this visionbeen elusive?What we hear our customers saying Copyright 2015 OSIsoft, LLC6

What we hear our customers saying“We’re looking toget the data intotools like Spotfire.”“Our company hasstandardized on Teradataand Tableau for ourbusiness intelligencevisualization.”“We want to mix the datafrom the PI System andother systems in Hadoop.”1.Access thedata in toolsfamiliar tothe endusers“Accessing the data in arelational databaseopens up the data to newusers.” Copyright 2015 OSIsoft, LLC7

What we hear our customers saying“It took us 40 days toget the data out of thePI System”“Writing code andsupporting it is just notan option.”2. It has toScale(withoutcode)“We tried using OLEDBEnterprise but it timedout.” Copyright 2015 OSIsoft, LLC8

What we hear our customers saying“My job is to provide one version ofthe truth to the whole organization soI have to be able to trust the data andhave a repeatable process.”“It’s great that I can look atdata across similar anddifferent assets together.”“Seeing the data interms of wells andpumps makes it mucheasier for my endusers.”3. Flexibilityand trust“Zeroing in on just thenecessary data by usingevents for my applicationkeeps things simple.” Copyright 2015 OSIsoft, LLC9

Modern Information Architecture10 Copyright 2015 OSIsoft, LLC10

Real-time Data isn’t perfectThe Truth about Real-time Data Naturally incomplete (delays, shutdowns) Not evenly spaced Doesn’t look and behave like SQL (RDBMS) Subject to errors in measurement Varies in fidelity Needs Context (Assets, Events) Hard to Collect effectively Copyright 2015 OSIsoft, LLC11

Decision-Ready DataConditioned, Trustworthy,Targeted Other Model ModelOther Other Data 3ABData2Data 1SingleSource Raw Data Copyright 2015 OSIsoft, LLC12

Integration with AnalyticsSystem of RecordNeedsAnalytics PackagesVisual AnalyticsStatistical Analytics Guaranteed Delivery & StorageFull Fidelity of SensorOptimized for Real-TimeBackup/RestoreHASecurity Designed to Analyze Large SetsExpects that the Data ExistsProblem Defines Data ShapeTypically Evenly Spaced in Time Copyright 2015 OSIsoft, LLC13

PI IntegratorsPI Integrators reduce the complexity of analyzingreal world industrial dataAll PI System data delivered on your terms, in your language, tothe tools you use, and to the people that can make a difference. Copyright 2015 OSIsoft, LLC14

PI Integrator for Business IntelligenceVisual Analytics – BI ToolsConnect via Internet or PI InterfaceDATABusiness UserPI IntegratorDATAPI DataArchivePI System: System of Record / Real-time AnalyticsOperational User Copyright 2015 OSIsoft, LLC15

New Persona: Information Architect Works in an IT or OPs IT role Responsible for integrating many datasystems to achieve business goals Data Lifecycle Management Access Policies & Distribution Logical and Physical Architecture Creation and Receipt (Trust) Maintenance & Disposition PI System is just 1 system Business Expert / Business Enabler / Notsubject matter expert (engineer) Copyright 2015 OSIsoft, LLC16

BusinessIntelligence atDevon EnergyPresented by Don Morrison Copyright 2015 OSIsoft, LLC17

About One of North America’s leading independent producers of natural gas and oil Engaged in exploration and production Corporate headquarters in Oklahoma City More than 5,500 employees Member of the S&P 500 On Fortune magazine’s 100 Best Companies to Work For list each year since 2008 New to PI in 2013 and Enjoying the Benefits of EA Copyright 2015 OSIsoft, LLC18

A Leading North American E&PHeavy Oil Focused and balanced asset portfolio— Proved reserves: 2.8 billion BOE— Net production: 664 MBOED— Upstream revenue: 60% oilRockies Oil Deep inventory of opportunities————Prolific Eagle Ford assetsHigh-quality Permian Basin positionWorld-class heavy oil projectsTop-tier liquids-rich gas plays Positioned to deliver visible, low-risk production growthAnadarko BasinBarnett ShalePermian BasinEagle FordOil AssetsLiquids-Rich Gas AssetsNote: All figures represent Devon’s retained asset portfolio. Copyright 2015 OSIsoft, LLC19

What we hear our business saying“I want the data inSpotfire.”“We use Datameer toreport out of Hadoop.”“Can I just get the datain MS Access orMS Excel”“That query you wrotekeeps timing out”(PIOLEDB Enterprise) Copyright 2015 OSIsoft, LLC20

How we deliver data to the businessData ViewAnalytics\VisualizationPI DataLinkPI OLEDBEnterprisePULLExcellent for “small” datasets Hours, days, 1-2 monthsDoes not scale to “large” datasets 6 months, 3 yrs Copyright 2015 OSIsoft, LLC21

PI Integrator for Business IntelligenceHARMONY Copyright 2015 OSIsoft, LLC22

What do we gain? BI tools become more responsive (Spotfire)Users can build queries ad hoc (SQL)Scheduled and ad-hoc reporting (SSRS)Historical data available to existing BI toolsReal-time data in HadoopAlign data for BI within a common time schemeEnable unique uses for real-time data Copyright 2015 OSIsoft, LLC23

Use Case: Management Summary Automated Daily Reports Management Overview KPI / Metrics Rollup to Bus. Unit Copyright 2015 OSIsoft, LLC24

Use Case: Daily Reports Automated Daily Reports Technical Overview KPI / Metrics Well by Well Copyright 2015 OSIsoft, LLC25

Use Case: SharePoint / Pivot TablesAutomated, Scheduled, and Daily Update Copyright 2015 OSIsoft, LLC26

Use Case: Reservoir AnalysisFaster and Better Decisions Copyright 2015 OSIsoft, LLC27

The Power of the Shape Find nested elementsFind “buried” attributesRequire specific structureFilter on CategoriesFilter on Event FramesTranslate to new relations“Google for AF” Copyright 2015 OSIsoft, LLC28

We’re leveraging more dataEnables us to make fasterand better decisionsregarding assetperformance, which shouldlead to better productionand lower costs!““ spending less time copyingand pasting and more timeanalyzing the data.““Our managers and engineersare able to get a better ideaof how the asset isperforming.““ Copyright 2015 OSIsoft, LLC29

PI Integrator for Business Intelligence Beta Q2 2015, Release Q3 2015– Data Designer UI– Data Extraction, Shaping, Cleansing– PI Views stored in AF– Pull Data from PI System using ODBC– Compatible with most off the shelf BI Tools Microsoft PowerBI and Excel, Tibco Spotfire,Tableau, Datawatch, SAP BusinessObjects, Cognos Copyright 2015 OSIsoft, LLC30

Tangible Benefits Easy to deploy, easy to explore, easy to iterate Explore PI System Data in tools that business users arealready comfortable using Identify correlations across fleets of assets Tap into the most valuable data set in the essIntelligenceEnterpriseIntelligence Copyright 2015 OSIsoft, LLC31

Call to Action Stay for the Next Talk– Demo of Data Designer– Integration with Hadoop and Statistical Analytics Come see us at Product/Partner Expo– PI Integrator for SAP HANA Friday 10am – Big Data and Business Intelligence Sign up for Interest in Beta – Q2– PIIntegrators@osisoft.com Copyright 2015 OSIsoft, LLC32

John Baierjbaier@osisoft.comDirector of Integration TechnologiesOSIsoft, LLCDon MorrisonDon.Morrison@dvn.comReal-time Data EngineerDevon Energy Copyright 2015 OSIsoft, LLC33

QuestionsPlease wait for the microphonebefore asking your questionsState yourname & company Copyright 2015 OSIsoft, LLC34

Copyright 2015 OSIsoft, LLC

Integration with Analytics 13 Guaranteed Delivery & Storage Full Fidelity of Sensor Optimized for Real-Time Backup/Restore HA Security Designed to Analyze Large Sets Expects that the Data Exists Problem Defines Data Shape Typically Evenly Spaced in Time Needs Analytics Packages Visual Analytics Statistical Analytics