[Michael Frank]

We are almost complete with a similar project, however we did the work mostly internally.  Our BW system was in need of an upgrade, and the low usage couldn’t justify the costs.  We decided upon Snowflake as our cloud database, and connected it to AWS storage, with Tableau as the query tool of choice.  It’s been a little arduous, but honestly I’m surprised at how simple the solution has turned out to be.  I thought there was more to the ETL behind the scenes in BW than there were.

 

 

Michael Frank

Data Enabler

Tacoma Public Utilities – Market Development

Mfrank@cityoftacoma.org

HANAlytics Enterprise Reports

Moderna 2021

 

 

 

 

 

——————————————-
Original Message:
Sent: 8/3/2021 4:15:00 PM
From: Phil Teng
Subject: SAP BW to Azure Analytics

Hi All!

We have an outdated and minimally used SAP BW solution. We would like to build data storage, ETLs, and reporting in Azure to migrate the existing data in SAP BW and sunset the BW system. This will serve as our first step of our enterprise analytics strategy. So we are looking for a vendor with expertise to help architect, design, and build this solution. Could anyone offer some references or advice on particular vendors to engage? Thanks!

Phil

——————————
Phil Teng
Manager of Information Services
Rochester Public Utilities
507-280-1530
——————————

[Ben Ettlinger]

I think you have framed it well. “similar goals, similar mindsets, similar interests. It’s also about sharing information and helping each other, and making connections with people you wouldn’t otherwise meet.”  It also means becoming a magnet, generating interest in your cause to better your cause and those who join.

——————————
Ben Ettlinger
Emerging Technologies
Enterprise Architecture & Engineering Group
New York Power Authority
White Plains, NY
914 681 6496
——————————
——————————————-
Original Message:
Sent: 08-03-2021 10:11
From: Leslie Cook
Subject: What Does “Community” Mean To You? 🧐

Hey UAI Members!

I was thinking this morning about what community means, and that made me want to put the question to my favorite community members here!

So I’m asking you all – what does “community” mean to you?

What makes up community in your mind. What you get out of it, what you expect from it, etc.

I’ve been managing and participating in communities (both online and communities that meet in-person) since my early career days. And to me it’s finding people “like” you – similar goals, similar mindsets, similar interests. It’s also about sharing information and helping each other, and making connections with people you wouldn’t otherwise meet.

I have professional connections and personal friends (some professional connections that have become friends) all over the globe thanks to communities, so they hold a special place in my heart, and it’s one of the reasons I work so hard to keep people engaging through UAI.

Now it’s your turn – what does “community” mean to you?

I ask, because I want to make sure I am providing you the type of “community” you want and need.

@Leslie
​

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————

[Ron Capute]

Besides what has been stated I think community involves a sense of inclusion.  Everyone’s opinion counts.  Everyone is on the same team.

——————————
Ron Capute
Sr Project Manager
Florida Power & Light
Jupiter FL
5619043273
——————————
——————————————-
Original Message:
Sent: 08-04-2021 11:05
From: Ben Ettlinger
Subject: What Does “Community” Mean To You? 🧐

I think you have framed it well. “similar goals, similar mindsets, similar interests. It’s also about sharing information and helping each other, and making connections with people you wouldn’t otherwise meet.”  It also means becoming a magnet, generating interest in your cause to better your cause and those who join.

——————————
Ben Ettlinger
Emerging Technologies
Enterprise Architecture & Engineering Group
New York Power Authority
White Plains, NY
914 681 6496
——————————

Original Message:
Sent: 08-03-2021 10:11
From: Leslie Cook
Subject: What Does “Community” Mean To You? 🧐

Hey UAI Members!

I was thinking this morning about what community means, and that made me want to put the question to my favorite community members here!

So I’m asking you all – what does “community” mean to you?

What makes up community in your mind. What you get out of it, what you expect from it, etc.

I’ve been managing and participating in communities (both online and communities that meet in-person) since my early career days. And to me it’s finding people “like” you – similar goals, similar mindsets, similar interests. It’s also about sharing information and helping each other, and making connections with people you wouldn’t otherwise meet.

I have professional connections and personal friends (some professional connections that have become friends) all over the globe thanks to communities, so they hold a special place in my heart, and it’s one of the reasons I work so hard to keep people engaging through UAI.

Now it’s your turn – what does “community” mean to you?

I ask, because I want to make sure I am providing you the type of “community” you want and need.

@Leslie
​

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————

[Bich Nguyen]

Hello Nadia,

These are great questions! Here OGE this is the way we approached it..

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise? Our AMI data is part of our overall data strategy and analytics platform
2 – What is the hand-off between IT supported functions and analytics? From a supported perspective, if it’s data availability and data questions we have a data product line that addresses the issues which is now a function of IT. And if it’s technical support we have some SME and system support folks. 
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both? Our data strategy and governance rest in our Business Intelligence group specifically in the data product line group however, there’s a shared responsibility with the data owners/business units as well. 
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision? The way we approach it is that broke our data and analytics road map into different pillars and AMI is a part of that.
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform? We also have an Analytics center of Excellence who help drives the engagement and support our analytics platform. 

I hope this help and if you have further questions we can connect and I can get some folks on our team to share with you in details. 

——————————
Bich Nguyen
Manager Analytics COE
OG&E
——————————
——————————————-
Original Message:
Sent: 08-02-2021 17:12
From: Nadia Powell
Subject: Organizational Structure

Hello all,

We seem to be struggling with a coordinated direction.  I have a few questions:

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise?
2 – What is the hand-off between IT supported functions and analytics?
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both?
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision?
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform?

Very much appreciate your input!

nadia
El Paso Electric

——————————
Nadia Powell
Director of Palo Verde Management and Local Gen Support
El Paso Electric
——————————

[Rosemary Peh]

At Hawaiian Electric, we have just formally established our Enterprise Data & Analytics organization and aligned it to our Data Governance Group, and overall strategies.  We ran a Data & Analytics Initiative for about 2 years getting buy in from our organization across all business units, before transitioning this year into our going forward operating model.  We did it this way because, we had multiple analytics teams that were specific to a particular business unit, and our strategy called for the optimization of resources and capability across the entire company.  See answers to your specific questions below:

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise?
We have one platform that services the entire enterprise.  Primarily because our decisions are more and more integrated across the entire utility space.

2 – What is the hand-off between IT supported functions and analytics?
We have created a DataOps team within the CIO business unit and it has federated business unit “spokes”.  The “hub” team under the CIO takes care of all the ELT or ETL work coming from transactional systems, and maintains the central repository.  It currently has Data Engineers, and Data Analyst, and will add Data Scientists as appropriate.  The hub supports the business units that have data analysts, and a limited number of specialized data engineers.  In this way, the line between IT and business blurs, as the CIO hub – has both business analytics and IT technical support roles and capabilities.  The spokes will depend on the hub as they mature or are already mature.

3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both? 
Our data strategy and governance is the responsibility of our Enterprise Architecture team – as led by the Data/Information Architect.  They work closely with the new EDA team and the business to ensure alignment.

4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision? 
As mentioned above, AMI is part of our overall Data & Analytics Strategy and therefore, its Roadmap.

4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform? We have a Data Governance Group that is cross functional across the organization and facilitated by the Data/Information Architect.  Data Owners, Stewards and Custodians are being identified, and our intent is to utilize this group and the spoke leads to vet and update the Data & Analytics Strategy and Roadmap.

Hope this helps.

——————————
Rosemary Peh
Operations Excellence Director
Hawaiian Electric Company
1-808-543-4790
——————————
——————————————-
Original Message:
Sent: 08-05-2021 11:54
From: Bich Nguyen
Subject: Organizational Structure

Hello Nadia,

These are great questions! Here OGE this is the way we approached it..

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise? Our AMI data is part of our overall data strategy and analytics platform
2 – What is the hand-off between IT supported functions and analytics? From a supported perspective, if it’s data availability and data questions we have a data product line that addresses the issues which is now a function of IT. And if it’s technical support we have some SME and system support folks. 
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both? Our data strategy and governance rest in our Business Intelligence group specifically in the data product line group however, there’s a shared responsibility with the data owners/business units as well. 
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision? The way we approach it is that broke our data and analytics road map into different pillars and AMI is a part of that.
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform? We also have an Analytics center of Excellence who help drives the engagement and support our analytics platform.

I hope this help and if you have further questions we can connect and I can get some folks on our team to share with you in details.

——————————
Bich Nguyen
Manager Analytics COE
OG&E
——————————

Original Message:
Sent: 08-02-2021 17:12
From: Nadia Powell
Subject: Organizational Structure

Hello all,

We seem to be struggling with a coordinated direction.  I have a few questions:

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise?
2 – What is the hand-off between IT supported functions and analytics?
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both?
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision?
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform?

Very much appreciate your input!

nadia
El Paso Electric

——————————
Nadia Powell
Director of Palo Verde Management and Local Gen Support
El Paso Electric
——————————

[Leslie Cook (Adm)]

I love seeing this active thread. If you are interested in this topic, please make sure to join us for the next UAI Enterprise Analytics Community Conversation.

Join the Enterprise Analytics Community on Thursday, August 26th at 1:00 PM CT for a panel discussion around, Big Data/AMI Data, with the following panelists:

– Mario Correa, Project Manager – SoCalGas

– Sung Yee (Paul) Lam, Sr. Software Engineer – SoCalGas

– Norv Clontz, Director, Data Science Innovation – Duke Energy

– Brad Gall, Sr. Data Architect, Connected Analytics – The Energy Authority

During this session, each panelist will share their implementation of big data/AMI data, their validation process, use of AMI (What are utilities doing with it? How are their utilities using it?), better practices and challenges. Come prepared to asks questions, because panelists will take time to answer questions about the topic from the audience.

If you are not registered for the UAI Enterprise Analytics Community, please do so via our Community Registration Form to get access to this meeting.

Cheers, 
     Leslie

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————
——————————————-
Original Message:
Sent: 08-06-2021 14:08
From: Rosemary Peh
Subject: Organizational Structure

At Hawaiian Electric, we have just formally established our Enterprise Data & Analytics organization and aligned it to our Data Governance Group, and overall strategies.  We ran a Data & Analytics Initiative for about 2 years getting buy in from our organization across all business units, before transitioning this year into our going forward operating model.  We did it this way because, we had multiple analytics teams that were specific to a particular business unit, and our strategy called for the optimization of resources and capability across the entire company.  See answers to your specific questions below:

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise?
We have one platform that services the entire enterprise.  Primarily because our decisions are more and more integrated across the entire utility space.

2 – What is the hand-off between IT supported functions and analytics?
We have created a DataOps team within the CIO business unit and it has federated business unit “spokes”.  The “hub” team under the CIO takes care of all the ELT or ETL work coming from transactional systems, and maintains the central repository.  It currently has Data Engineers, and Data Analyst, and will add Data Scientists as appropriate.  The hub supports the business units that have data analysts, and a limited number of specialized data engineers.  In this way, the line between IT and business blurs, as the CIO hub – has both business analytics and IT technical support roles and capabilities.  The spokes will depend on the hub as they mature or are already mature.

3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both?
Our data strategy and governance is the responsibility of our Enterprise Architecture team – as led by the Data/Information Architect.  They work closely with the new EDA team and the business to ensure alignment.

4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision?
As mentioned above, AMI is part of our overall Data & Analytics Strategy and therefore, its Roadmap.

4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform? We have a Data Governance Group that is cross functional across the organization and facilitated by the Data/Information Architect.  Data Owners, Stewards and Custodians are being identified, and our intent is to utilize this group and the spoke leads to vet and update the Data & Analytics Strategy and Roadmap.

Hope this helps.

——————————
Rosemary Peh
Operations Excellence Director
Hawaiian Electric Company
1-808-543-4790
——————————

Original Message:
Sent: 08-05-2021 11:54
From: Bich Nguyen
Subject: Organizational Structure

Hello Nadia,

These are great questions! Here OGE this is the way we approached it..

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise? Our AMI data is part of our overall data strategy and analytics platform
2 – What is the hand-off between IT supported functions and analytics? From a supported perspective, if it’s data availability and data questions we have a data product line that addresses the issues which is now a function of IT. And if it’s technical support we have some SME and system support folks. 
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both? Our data strategy and governance rest in our Business Intelligence group specifically in the data product line group however, there’s a shared responsibility with the data owners/business units as well. 
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision? The way we approach it is that broke our data and analytics road map into different pillars and AMI is a part of that.
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform? We also have an Analytics center of Excellence who help drives the engagement and support our analytics platform.

I hope this help and if you have further questions we can connect and I can get some folks on our team to share with you in details.

——————————
Bich Nguyen
Manager Analytics COE
OG&E

Original Message:
Sent: 08-02-2021 17:12
From: Nadia Powell
Subject: Organizational Structure

Hello all,

We seem to be struggling with a coordinated direction.  I have a few questions:

1 – If you have AMI, does it have it’s own analytics platform, or is there just one platform that services the entire enterprise?
2 – What is the hand-off between IT supported functions and analytics?
3 – Where does the responsibility for data strategy/governance rest?  Is that an IT function/analytics function/both?
4 – Recommendations on Analytics Roadmap – should there be a separate Roadmap/data vision for AMI or should there be one Roadmap/data vision?
4 – how many people do you have engaged in data strategy/data governance?  How many are engaged in maintaining the analytics platform?

Very much appreciate your input!

nadia
El Paso Electric

——————————
Nadia Powell
Director of Palo Verde Management and Local Gen Support
El Paso Electric
——————————

[Tom Martin]

I’d be happy to do a deep dive into the below items from Leslie’s Use Case list:

 

• Substation asset analytics
• Asset Optimization 
• Transmission Smart Grid Journey
• Condition-based maintenance for substation equipment
• Productionalization of models
• How AMI has enhanced the operations of utilities – hearing from those experienced in developing an enterprise system and using the AMI to support it
• Artificial Intelligence and Machine Learning
• Customer Analytics

 

 

Tom Martin

Managing Director of Product

E Source Data Science Division

Cell 314-210-7575

tom_martin@esource.com | http://www.esource.com

 

 

——————————————-
Original Message:
Sent: 8/2/2021 12:17:00 PM
From: Travis Metcalfe
Subject: RE: Are You Working on Use Cases in the Enclosed Categories?

We are working on many of the items on this list and are at various states of progress. Would be happy to help connect anyone with a specific question on one of them with someone from our organization.

——————————
Travis Metcalfe
Strategy, Innovation, and Engagement Manager
Tacoma Power
Tacoma WA
2535028149
——————————
——————————————-
Original Message:
Sent: 07-13-2021 09:57
From: Leslie Cook
Subject: Are You Working on Use Cases in the Enclosed Categories?

…If yes, we want to hear from you! 

Hello UAI Members,

Your fellow members are asking if you are working on use cases in the following categories or if you have more information to share on these hot topics. If you are working on use cases in the following categories or have information to share, please let us know by replying to this post or reaching out to me directly at lcook@utilityanalytics.com. Thanks so much for helping each other!

• Substation asset analytics
• Asset Optimization 
• Asset Life for Vehicles
• Transmission Smart Grid Journey
• Condition-based maintenance for substation equipment
• Integrating drone data with historians & analytics around drone data
• IR data integration into asset health analytics
• Tableau Mapping
• Best practices on and how to tune modeling
• Various Architectures
• Share data science tools you are using and how you are using them: Azure, Azure Data Brick vs Machine Learning Studio vs Containers – how are members actually using Azure?
• What models are you doing in the public cloud? 
• Productionalization of models
• Machine learning operations 
• Team Orgs
• How AMI has enhanced the operations of utilities – hearing from those experienced in developing an enterprise system and using the AMI to support it
• Artificial Intelligence and Machine Learning
• Customer Analytics
• I would like to find out how other utilities are getting HR to provide a wage that allows them to retain people with desired skillsets
• Unfortunately, safety is a smaller data set. Telematics from driving is the only exception. How can one work with smaller data sets?
• Project tracking, Displaying trends, Navigating data analytics in a non-analytical role
• Visualizations
• User engagement
• Data Engineering

I look forward to seeing your replies and input on this post. Once I hear back, we can get some separate posts going on the individual topics and/or use cases.

Thanks so much!

     @Leslie

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————

[Sandi Joralemon]

Hello UAI Community,

NBU is working on budget forecasting which includes analytical models for area growth, energy/water demand, revenue, and cost forecasts. Since our SAS platform is very newly in production, we are working with SAS’ experts to learn their methodology for building out data and storing it to the data warehouse for future retrieval on demand.

——————————
Sandi Joralemon
Data Strategist
New Braunfels Utilities
New Braunfels TX
830.608.8941
——————————
——————————————-
Original Message:
Sent: 07-13-2021 09:57
From: Leslie Cook
Subject: Are You Working on Use Cases in the Enclosed Categories?

…If yes, we want to hear from you! 

Hello UAI Members,

Your fellow members are asking if you are working on use cases in the following categories or if you have more information to share on these hot topics. If you are working on use cases in the following categories or have information to share, please let us know by replying to this post or reaching out to me directly at lcook@utilityanalytics.com. Thanks so much for helping each other!

• Substation asset analytics
• Asset Optimization 
• Asset Life for Vehicles
• Transmission Smart Grid Journey
• Condition-based maintenance for substation equipment
• Integrating drone data with historians & analytics around drone data
• IR data integration into asset health analytics
• Tableau Mapping
• Best practices on and how to tune modeling
• Various Architectures
• Share data science tools you are using and how you are using them: Azure, Azure Data Brick vs Machine Learning Studio vs Containers – how are members actually using Azure?
• What models are you doing in the public cloud? 
• Productionalization of models
• Machine learning operations 
• Team Orgs
• How AMI has enhanced the operations of utilities – hearing from those experienced in developing an enterprise system and using the AMI to support it
• Artificial Intelligence and Machine Learning
• Customer Analytics
• I would like to find out how other utilities are getting HR to provide a wage that allows them to retain people with desired skillsets
• Unfortunately, safety is a smaller data set. Telematics from driving is the only exception. How can one work with smaller data sets?
• Project tracking, Displaying trends, Navigating data analytics in a non-analytical role
• Visualizations
• User engagement
• Data Engineering

I look forward to seeing your replies and input on this post. Once I hear back, we can get some separate posts going on the individual topics and/or use cases.

Thanks so much!

     @Leslie

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————