Utility Project Profile Database

Salt River Project NAICS Game plans

  

ANALYTICS AREAS

 

  1. Which of the following analytics areas apply to your project (see definitions at end of document)? Place an “X” in the appropriate boxes.

 

 

Implementation underway

 

 

Project completed

Future

 

Meter data analytics

_______

 

 

_______

_______

Credit and collections

_______

 

 

_______

_______

Call center optimization

_______

 

 

_______

_______

Fraud detection

_______

 

 

_______

_______

Campaign management

_______

 

 

_______

_______

Customer segmentation

___x____

 

 

_______

_______

Pricing optimization

_______

 

 

_______

_______

Demand response programs

_______

 

 

_______

_______

Energy efficiency programs

_______

 

 

_______

_______

Distributed generation management programs, including electric vehicles

_______

 

 

_______

_______

Transformer management

_______

 

 

_______

_______

Substation equipment management

_______

 

 

_______

_______

Overall transmission & distribution management

_______

 

 

_______

_______

Outage management

_______

 

 

_______

_______

System modeling

_______

 

 

_______

_______

Power quality optimization

_______

 

 

_______

_______

Advanced distribution management

_______

 

 

_______

_______

Analytics for real-time network operations

_______

 

 

_______

_______

 

Other: 

 

 

PROJECT OVERVIEW

 

  1. In two or three sentences or a short paragraph, please describe this project (include business drivers, how project aligns with utility’s corporate strategy, project goals, results achieved/desired outcomes).

 

NAICS is a customer segmentation tool used primarily in the marketing department. It helps the team to target campaigns, determine remaining market size, and shows where the marketing team can build awareness for a product.



BUSINESS VALUE

 

  1. Describe actual and/or anticipated QUALITATIVE (e.g. better customer service) and QUANTITATIVE (e.g. ROI, cost savings, revenue increases) benefits of this project.
    • Note: Any and all quantification of benefits helpful including estimates, ranges, percentage increases or decreases in costs, resources, etc.

 

Being a younger project, there is no real quantitative data that can be measured (as of now). With a deeper understand of the customer, the hope is that this will increase engagement and energy efficiency.

 




BUSINESS PROCESS IMPACTS

 

  1. List the key business processes impacted (or expected to be impacted) and describe the nature of those impacts.

 

This will only impact some business processes regarding marketing population.

 

 

 

TECHNOLOGY

 

  1. Identify the PRIMARY TECHNOLOGY COMPONENTS associated with this project including the technologies used (or expected to be used) for: 1) data collection/integration 2) data analysis 3) data presentation and 4) data storage.
    • Notes: Identify the solution providers and products by name if possible

 

SRP has a server data warehouse where they use SSMS to pull data together and feed into Tableu. The data presentation layer is a custom Tableu dashboard. The dashboard is pushed onto a Tableu server which is updated daily but checked monthly. 

 

  1. Identify the PRIMARY DATA INPUTS/ELEMENTS utilized and their sources.


Few data elements produce several metrics. NAICS code is the primary data input which is assigned when a record is created in the billing system. Program data such as participation on each program comes from the marketing data warehouse.

 

PEOPLE

 

  1. Identify the following individuals by job title (as applicable):

 

  • Business-side Project Leader: Cathy Den Dulk
  • Technology-side: Eric Hirsch

 

 

  1. Identify and describe the role of external providers (e.g. strategy, consultant, design, development, implementation, ongoing operations).

 

No external consultants/providers.

 

 

  1. Describe the investments required to implement and provide ongoing support for this initiative.

 

  • Internal resources (identify type of internal resources, e.g. job titles and quantities of each (e.g. # of full time/# of part time, total FTEs):

 

Used over a 3 week period.

 

 

 

  • Technology investments (estimate/provide ranges for one time and recurring costs if possible or indicate that existing technologies were leveraged):

 

Only technological investment would be a Tableu desktop license.

 

 




BEST PRACTICIES/LESSONS LEARNED

 

  1. What advice would you share with those either planning or implementing a similar initiative (e.g. best practices, lessons learned, what to do, what not to do)?

 

 

Best advice would be to stay engaged with stakeholders and make sure what’s being produced adheres to them. Focus on tools and technology but don’t forget about the needs of the stakeholders.


 

CONTACT INFORMATION:

Name:

 Eric Hirsch

Title:

 

Company name:

 

Email:

 

0 comments
37 views

Permalink