© copyright 2013 osisoft, llc

Presented by


Gaining Operational

Intelligence from “Big

Data” Using Emerging

Self-Service Technologies

Curt Hertler, OSIsoft

Jaipal Kothakapu, Artha Data Solutions


• Step change in Microsoft self-service BI tool set

– Excel 2013 – Analysis and Reporting

– SharePoint 2013 Power View – Ad Hoc Analysis and Collaboration

• When combined with a real-time infrastructure offers significant opportunity for enhanced operational insight.

• Companies are re-evaluating their BI vision to strategically

leverage new tool kit to drive business value, enable and

empower employees, and manage the cost/risk equation.

3

Key Points


• Business Analytics Toolkit - 2013

• Pattern Matching and Network Analysis

– Business Context - PI Asset Framework (PI AF)

– Data Access - PI OLEDB Enterprise

– Analytic Reporting and Analysis - Excel 2013

– Collaborative Analysis – SharePoint 2013, MS SQL 2012

• Case Study: Artha Data Solutions

– Solution Architecture - Windows Azure

– Challenges and Alternatives – Example Reports

4

Overview


Business Analytics Toolkit - 2013

PI System

Real-time Data

and Events

Infrastructure


Microsoft Excel 2013

• Includes PowerPivot and Power

View.

• Integrates with Bing Maps.

• Integrates large datasets.

• Calculations are defined in

an Excel-like fashion.

• Data stored with spreadsheet.

• Supported in SharePoint

2013 Enterprise.


PowerPivot Creates the “Cube”

Substation Data Meter Data

Work Orders

Asset Specs

Weather Utility Rates

DGA Analysis

GIS Coordinates

Import data tables from;

• Real-time infrastructure

• Relational databases

• Data marketplaces

• Spreadsheets

• Copy and paste

© Copyr i gh t 2013 OSIso f t , LLC. 8

Network Hierarchy: PI Asset Framework (AF)

“Meter” Template

Asset

Hierarchy

• Substation

• Feeder

• Pole

Transformer

• Meter

“Pole

Transformer”

Template


PI Asset Framework (AF)

Pole

Transformer

Attributes

• Location

• Capacity rating

Meter Attributes

• Meter reads

(PI System Data)

Location and

manufacturer

• Service and

responsible entity


1

0

PI OLEDB Enterprise

Important

Considerations

• Leverage structure

used throughout

the PI Infrastructure

• Correct aggregation

of real-time events

• Scalable, driven

from PI AF Structure


1

1

PowerPivot in Excel 2013

PowerPivot

functionality

is Included

in Excel

2013


1

2

Power View in Excel 2013

Power View

worksheets

provide

ad hoc

analysis in

Excel 2013


1

3

Power View in Excel 2013

Bing Map

Integration

• Street

Address

• Lat – Long

• Filtered

Zoom and

Pan


Solution Architecture

17

Data From

- Smart Grid

- Smart Meter

SharePoint Collaboration

SharePoint Dashboards &

Scorecards

Analysis Services

Integration Services

Reporting Services

Microsoft Office 2013

Operational Data

PI Server &

PI AF

Excel Power Pivot and

Power View

Cloud Solution


NuGreen Utilities – A Case Study

• Identify loading on feeders and transformers – Assists in system planning New Transmission

lines

• Identify load patterns of customers – Engage and Educate customers for targeted

demand response

• Reduce energy loss by identifying low consumption

– Theft of energy

– Defective meters

Load comparison at Transmission & Distribution level

– Study effectiveness of demand response

– Understand demand variation over previous years

18

• Overloading of Transmission & Distribution

• High energy cost during peak periods

• High capital investment in new infrastructure – New Generation

– New Transmission lines

– Upgrade of Distribution System

Peak Demand Challenges Alternatives


AF Structure with Element Attributes

19


Feeder, Aggregated C&I and Domestic Load Profile for a

day


Distribution Transformer and Connected Meters Load

Profile – Power View


Bing map with 2 tool tip values limited to 1000

22


Benefits with Artha-DS Analytics

• Self Service Analytics with Power Pivot and Power View

• Technology helps bridge gap between IT and OT – no programming

required

• Analyze, filter, slice tsunami of Smart Grid data from various

applications

• Rapid BI solution deployment

• Utilize proven technologies of OSIsoft & Microsoft BI Platform

• Move the Cap-Ex to Op-Ex and pay as go with optional cloud

hosting

23


Self-Service BI at UC 2013

24

Day1 - “Self Service Business Analytics” Demo Pod

OSIsoft Product Expo and Reception

12:30 – 6:45 Golden Gate Rooms

Day 2 - “Slice and Dice PI System Data”

9:40 – 10:10 Grand Ballroom A


Curt Hertler [email protected]

Partner Solutions Architect

OSIsoft, LLC

25

Jaipal Kothakapu [email protected]

President

Artha Data Solutions

mailto:[email protected]




Brought to you by


© copyright 2013 osisoft, llc

Documents