Data Dictionary

  • Posted by Nadia Powell on February 14, 2022 at 5:51 am

    Hello all!

    Does anyone know of a standard data dictionary for the electric utility industry?  I thought I had heard that EEI had produced something.  

    thanks!

    nadia

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

    Maggie Peacock replied 2 years, 9 months ago 5 Members · 5 Replies
  • 5 Replies
  • Kevin Praet (Adm)

    Member
    February 17, 2022 at 12:21 pm

    Hello Enterprise Analytics Community Members,

    I hope all is well! We are one week away from our February (2022) Enterprise Analytics Community Conversation and want to get you excited about the session taking place. On Thursday, February 24th at 1:00 PM CT, we will be joined by Ben Ettlinger, IT Data Analytics Architect at NYPA who will be leading a discussion around, “Creating an Analytics Community of Practice.”  As this discussion will be interactive, we encourage you to come prepared with questions and your insight.

    Learn more about this session and our speaker below!

    Session Description:

    During this presentation, Ben will cover the difference between a Community of Practice (CoP) and a Center of Excellence and what it took to create a successful Analytics Community of Practice at the New York Power Authority. We will cover the building blocks of a CoP and what you should be focused on.

    Speaker: Ben Ettlinger, IT Data Analytics Architect (NYPA)


    Ben Ettlinger is the Founding ​Manager of the Digital Analytics group at the New York Power Authority. He is now responsible for Analytics Enablement & Emerging Technologies and has 29 years of utility industry experience at NYPA.​​ 
    __________________________________________________________________________________________________________________________________________________

    A calendar placeholder for this community conversation was sent out via my alternate email address (kpraet@sg.utilityanalytics.com). For your convenience I have also attached the placeholder to this message. If you are not seeing a placeholder on your calendar for Thursday, February 24th at 1:00 PM CT, or are having trouble downloading the placeholder from this message, please reach back out to me so I can be sure you are forwarded the invite an alternate way.

    Thanks and I look forward to connecting next week!

    ——————————
    Kevin Praet
    Membership Coordinator
    Utility Analytics Institute (UAI)
    Boulder CO
    315-440-3033
    ——————————
    ——————————————-
    Original Message:
    Sent: 02-02-2022 14:30
    From: Kevin Praet
    Subject: Upcoming February (2022) Community Conversation

    Hello Enterprise Analytics Community Members,

    I hope all is well! With February just kicking off, I wanted to reach out and get you excited for our February (2022) Enterprise Analytics Community Conversation. On Thursday, February 24th at 1:00 PM CT, we will be joined by Ben Ettlinger, IT Data Analytics Architect at NYPA who will be leading a discussion around, “Creating an Analytics Community of Practice.” I’ll be providing more information on this session one week prior to our meeting but you can always learn more about each of our upcoming Community Conversations on our Events Page HERE.

    Our latest IT update allows me to send meeting placeholders directly to your calendars through my alternate email address kpraet@sg.utilityanalytics.com. I sent out invitations for this community, and each of our other communities, last month. If you did not receive a calendar invitation let me know so I can help troubleshoot. As this seems to be an issue with some of our members’ firewalls, we recommend whitelisting my new email address kpraet@sg.utilityanalytics.com to ensure any invites don’t go to your spam/junk folders.

    Again please let me know if you have any questions/concerns or do not have a calendar placeholder on your calendar.

    Thanks and I look forward to connecting with you all this month!

    ——————————
    Kevin Praet
    Membership Coordinator
    Utility Analytics Institute (UAI)
    Boulder CO
    315-440-3033
    ——————————

  • Travis Metcalfe

    Member
    February 22, 2022 at 3:09 am

    I haven’t heard about anything like this but I too would be interested if someone knows about a standard for the industry floating around out there.

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149
    ——————————
    ——————————————-
    Original Message:
    Sent: 02-14-2022 17:51
    From: Nadia Powell
    Subject: Data Dictionary

    Hello all!

    Does anyone know of a standard data dictionary for the electric utility industry?  I thought I had heard that EEI had produced something.

    thanks!

    nadia

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

  • Sam Held

    Member
    February 22, 2022 at 5:17 am

    Hi Travis,

    Unfortunately, I am not aware of any industry standard data dictionary. Only reference I found out there are data dictionaries on feeds to federal agencies, e.g., FERC. But the way I use data dictionary might be too specific for industry wide use.

    Are you thinking that specific – data field/column names, data type, max length, primary/foreign key, null allowed?  Or are you thinking of what we call business terms which are business words/phrases and their definitions linked to data assets?  The latter provides common language for a utility or even different parts of a business unit.  The former is going to be difficult based on various computer systems by all of the utilities out there.

    Good luck.

    Sam Held

    ——————————
    Sam Held
    Data Governance Specialist
    TVA
    423-751-2220
    ——————————
    ——————————————-
    Original Message:
    Sent: 02-22-2022 15:09
    From: Travis Metcalfe
    Subject: Data Dictionary

    I haven’t heard about anything like this but I too would be interested if someone knows about a standard for the industry floating around out there.

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149
    ——————————

    Original Message:
    Sent: 02-14-2022 17:51
    From: Nadia Powell
    Subject: Data Dictionary

    Hello all!

    Does anyone know of a standard data dictionary for the electric utility industry?  I thought I had heard that EEI had produced something.

    thanks!

    nadia

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

  • Travis Metcalfe

    Member
    February 22, 2022 at 6:23 am

    Thanks Sam, 

    I am not sure what Nadia had in mind when she posed the initial question but I was thinking more along the lines of your latter suggestion of business terms their definitions linked to data assets. 

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149
    ——————————
    ——————————————-
    Original Message:
    Sent: 02-22-2022 17:17
    From: Sam Held
    Subject: Data Dictionary

    Hi Travis,

    Unfortunately, I am not aware of any industry standard data dictionary. Only reference I found out there are data dictionaries on feeds to federal agencies, e.g., FERC. But the way I use data dictionary might be too specific for industry wide use.

    Are you thinking that specific – data field/column names, data type, max length, primary/foreign key, null allowed?  Or are you thinking of what we call business terms which are business words/phrases and their definitions linked to data assets?  The latter provides common language for a utility or even different parts of a business unit.  The former is going to be difficult based on various computer systems by all of the utilities out there.

    Good luck.

    Sam Held

    ——————————
    Sam Held
    Data Governance Specialist
    TVA
    423-751-2220
    ——————————

    Original Message:
    Sent: 02-22-2022 15:09
    From: Travis Metcalfe
    Subject: Data Dictionary

    I haven’t heard about anything like this but I too would be interested if someone knows about a standard for the industry floating around out there.

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149

    Original Message:
    Sent: 02-14-2022 17:51
    From: Nadia Powell
    Subject: Data Dictionary

    Hello all!

    Does anyone know of a standard data dictionary for the electric utility industry?  I thought I had heard that EEI had produced something.

    thanks!

    nadia

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

  • Maggie Peacock

    Member
    February 22, 2022 at 6:30 am

    Along the lines of what Sam and Travis have said I find the glossary on EIA’s site helpful too! Glossary – U.S. Energy Information Administration (EIA)

    ——————————
    Maggie Peacock
    Manager, Analytics and Data Management
    SERC
    ——————————
    ——————————————-
    Original Message:
    Sent: 02-22-2022 18:22
    From: Travis Metcalfe
    Subject: Data Dictionary

    Thanks Sam,

    I am not sure what Nadia had in mind when she posed the initial question but I was thinking more along the lines of your latter suggestion of business terms their definitions linked to data assets. 

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149
    ——————————

    Original Message:
    Sent: 02-22-2022 17:17
    From: Sam Held
    Subject: Data Dictionary

    Hi Travis,

    Unfortunately, I am not aware of any industry standard data dictionary. Only reference I found out there are data dictionaries on feeds to federal agencies, e.g., FERC. But the way I use data dictionary might be too specific for industry wide use.

    Are you thinking that specific – data field/column names, data type, max length, primary/foreign key, null allowed?  Or are you thinking of what we call business terms which are business words/phrases and their definitions linked to data assets?  The latter provides common language for a utility or even different parts of a business unit.  The former is going to be difficult based on various computer systems by all of the utilities out there.

    Good luck.

    Sam Held

    ——————————
    Sam Held
    Data Governance Specialist
    TVA
    423-751-2220

    Original Message:
    Sent: 02-22-2022 15:09
    From: Travis Metcalfe
    Subject: Data Dictionary

    I haven’t heard about anything like this but I too would be interested if someone knows about a standard for the industry floating around out there.

    ——————————
    Travis Metcalfe
    Strategy, Innovation, and Engagement Manager
    Tacoma Power
    Tacoma WA
    2535028149

    Original Message:
    Sent: 02-14-2022 17:51
    From: Nadia Powell
    Subject: Data Dictionary

    Hello all!

    Does anyone know of a standard data dictionary for the electric utility industry?  I thought I had heard that EEI had produced something.

    thanks!

    nadia

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

Log in to reply.