pi integrator for business analytics enterprise reporting · pi integrator for business analytics...
TRANSCRIPT
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Presented by
PI Integrator for Business Analytics – Enterprise Reporting
Matt Ziegler
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Access for everyone In user’s tool of choice
People Reduce the time to get it
Powered by PI Asset Framework
Data
Any System Standard & Native Integrations
Systems Effortless
Self Service UI / Centrally Managed
Integration
Empowering: People – Systems – Process
2
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Operational Reporting & Analysis Architecture
3
3
… All BI tools that support ODBC
Tableau Spotfire
SAS
MSFT BI
PI Server
PI Integrator for Business Analytics – Business Intelligence Edition
System of Record
Visualization & Analytics
Data Preparation and Integration
Layer
I want to analyze operations data
stored in the PI System using modern BI tools
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Enterprise Data Warehouse Architecture
4
4
PI Server
PI Integrator for Business Analytics
Tableau Spotfire
System of Record
Visualization & Analytics
Data Preparation and Integration Layer
Oracle DW, SQL Server, Teradata Enterprise Data
Warehouse / Data Mart / Data Lake
Custom Applications
SAS MSFT BI
Custom or 3rd Party Data Management and ETL
EAM Sales CRM
ERP HR …
Hadoop
I need to fit operational data into my existing
company IT information architecture
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
How to Properly Model Data
5
Weather Temperature
Heat Index
Cooling Degree Days
Wind Speed
Show me the total energy cost
Month
Day
Hour
Shift
Date & Time
Peak Status
Off-Peak Partial Peak Peak
For the first shift
During Peak Status
Time-series data stored in PI System
Context stored in PI System
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Can HVAC problems be predicted & prevented?
6
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Verify your data and conclusions with reality and actual people
People Gather more data
HVAC Power Profiles
Data
Determine an action plan for Improvement and information distribution
Systems Share data with HVAC contractor
Integration
Next Steps
10
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
PI Integrators Roadmap
11
2015 2Q 3Q 1Q 4Q
2016 2Q 3Q 1Q 4Q
Wave 1 – Business Intelligence & Data Warehouses
PI Integrator Lighthouse Program
PI Integrator for Business Analytics 2016 -- Oracle RDBMS 11 & 12 -- Hadoop HDFS & HIVE
PI Integrator for SAP HANA
Wave 2 – Streaming Applications, Partners, Programming*
*Subject to change
11
PI Integrator for Business Analytics 2015
TBD
PI Integrator Lighthouse Program 2.0
Research -- Partner Needs (SI, ISV) -- Streaming Systems (Kafka, SAS, etc.) -- Services, Architecture & PoC
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Commercial Model
12
PI Integrator for Business Analytics
BI Edition Data
Warehouse Edition
SAP HANA Edition
PI Views
--Access data via ODBC X X
Native Connections
--SQL Server X
--Flat File X
--SAP HANA X
Data Flow
--By calendar times X X X
Common Features
--Create Asset Views X X X
--Cleanse and filter data using Event Frames X X X
--Automatic Dimensionally modeled data X X X
PI Integrator for Business Analytics
Output
Data
Streams
BI Edition
Data
Warehouse
Edition
SAP HANA
Edition
1000 Talk - -
2500 to - -
5000 - Your -
10000 - OSIsoft Sold By
20000 - Account SAP
50000 - Manager -
100000 - Today -
*Not included in most Enterprise Agreements
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Contact Information
Matt Ziegler
Product Manager
OSIsoft, LLC
13
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015 14
Questions
Please wait for the microphone before asking your questions
Please don’t forget to…
Complete the Online Survey for this session
http://eventmobi.com/emeauc15
State your name & company
© Copyright 2015 OSIsoft, LLC EMEA USERS CONFERENCE 2015
Thank You