Data Management andAnalytics for UtilitiesThomas Bialek, PhD PEChief Engineer – Smart GridSan Diego Gas & Electric

2Defining a Technology Strategy Where we have come from Where we are going– Establishing interoperability and the future architecture vision of data andanalytics– System Integration: Finding ways to correlate data and optimize data feeds torun analytics and improve operational efficiencies– Choosing a standard data format for your company for moving data, dealingwith legacy systems and deciding between one database and many– What issues have utilities faced in implementing available technologies? Whyexisting analysis tools are often inadequate

3Historical System planning driven by the one peak hour of the year Electro-mechanical meter– Hourly consumption Siloed operation– Minimal data sharing– Customized solutions Proprietary solutions– Vendor lock-in Analysis paralysis

4Roadmap to the Future Probablistic system planning for every hour of the year Digital meter– 15 minutes C&I, Hourly residential– Power off notifications– Voltage reads Breaking down siloes– Data shared across organizations– Single source of the truth– Common language Standards based enterprise solutions– Open interfaces

Smart Grid RoadmapWorkforceDevelopmentIntegrated &Cross ectric VehicleGrowthSMARTGRIDSmart GridRD&DSecurityOperationalEfficiencyReliability &SafetyDeployment Roadmap San Diego Gas & Electric

Are we done yet?

Customer Empowerment

8Smart Meters – Data Volume Previously, over350 million datapoints(consumptionreads) were takenannually frommanually readanalog metersand a smallnumber ofremotely readdigital meters.Now we remotelyread nearly 15billion electricityusage data pointsannually fromSmart Meters.

Reliability and Safety

10Outage Management System (OMS)Distribution Management System (DMS)YesterdayManually Design Switching plans toresolve un-planned outages usingmanually maintained operatingmapsFuture StateSelect Switching Plan fromautomatically calculated scenarios.Uses Real Time Information fromSCADA and CBM monitors

11Phasor Measurement Units Range of 0.2 – 2 GB/day/PMU Range of 73 – 730 GB/year/PMU

12Synchrophasors Timesynchronizedhigh speedmeasurementstakenthroughout thegrid Improvesituationalawareness MultipleapplicationsincludingmicrogridsImage: Schweitzer Engineering Labs

SDG&E Weather Network (144 Stations)

Fire Preparation and SafetyMonitoring Santa Ana’s29 CamerasBorrego Springs, Creelman, Loveland, Rincon,Rough-Acres, Warner Springs & other fire-prone areasMonitor the weatherImpacts (vegetation, structures)Flying Debris

Wireless Faulted Circuit IndicatorsPurpose Installation of wireless fault indicators (WFIs) toexpedite location of distribution faults, using OnRamp Wireless communication network.Scope Install roughly 3,600 WFIs at 1200 locations Integrate with new OMS/DMSStatus Over 2,850 WFIs were installed in 2012

16Smart Isolation and ReclosingPurpose Application of pulse closing technologywhen reclosing onto faulted circuits tolimit the energy into the fault, improvingpublic safetyScope Install 18 intellirupters in 2012Status 2009-2011 installations 157 8 installations occurred in 2012

17Outage Management System (OMS)Distribution Management System (DMS) Real Time as-switched view of distributionsystem. Integrated with AMI to more quickly detectoutages. Average of 10 minutes before firstcustomer call and 25 minutes before customercalls would predict same outage location. Integrated with mobile dispatch system todispatch work and track crew status. Aggregates display ofoverall Summary ofoutages in progressand historical trend ofoutage and restorationactivity for thedistribution operator.

Operational Efficiency:Condition Based MaintenanceLTC energy is measured atthe control cabinet on theother side of the NALYSISTRANSFORMERANALYSISDISSOLVEDGASANALYSIS

Research, Development, and Demonstration

Research, Development & Demonstration:SDG&E Borrego Springs Microgrid ProjectDescriptionIn cooperation with the US Department of Energy and the California Energy Commission, SDG&E along with public and private sector partners aredeveloping a “microgrid” project – a small version of its smart electric grid.Benefits: Integrate and leverage various generation and storage configurations and other smart grid technologies Reduce the peak load of feeders and enhance system reliability Enable customers to become more active participants in managing their energy useDistributed EnergyResourcesSecure, 2-wayCommunicationsSubstationEnergy StorageCustomer EnergyManagementHome AreaNetworkMicrogrid ControllerHomeEnergy StorageFeeder AutomationSystem TechnologyCommunityEnergy Storage

Integrated andCross-Cutting Systems

Forecasting Engine(s) ecastIntermittentDERForecastA common, sharedreference model isneeded to alignforecasts to oursystem topologyISO Forecast& ScheduleDERMSIntegratedForecastsDMSEMS

System Operations Forecasts Weather Load Generation Time scales Day ahead Hour ahead Real time Network models 3 phase unbalanced load flow GIS information Load data Generation data State estimation Contingency planning Optimization algorithms Match load and generation Maintain voltage, frequency and power factor within limits Economic dispatch

Strategy Sempra Analytics Center of Excellence Establish a Community of Practice for analytics professionals Enable the development of competencies Exchange information and knowledge about analytics solutions, tools andsystems Increase our abilities as a company to leverage data to run ourbusiness better Blending of IT and OT Multi-variable analysis too difficult to perform manually Visualization tools Present actionable information Require interoperability between systems Avoid proprietary interfaces and systems Develop a smart grid enterprise architecture vision Allow management and project owners to see touch points


Questions ?Thank you.Thomas BialekChief Engineer, Smart rid/

Smart Meters – Data Volume Previously, over 350 million data points (consumption reads) were taken annually from manually read analog meters and a small number of remotely read digital meter