skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Energy finance data warehouse: Tracking revenues through the power sector

Abstract

Reliable data is needed to understand financial relationships in the power sector. However, relevant data acquisition and visualization can be a challenge due to the fragmented nature of the power sector. The Energy Policy and Systems Analysis office of the U.S. Department of Energy led a team of data scientists at Oak Ridge National Lab to collect revenue information from a variety of sources.

Authors:
 [1];  [1];  [2];  [2];  [1];  [1]
  1. U.S. Department of Energy (DOE), Washington, DC (United States). Office of Energy Policy and Systems Analysis (EPSA)
  2. Oak Ridge National Lab. (ORNL), Oak Ridge, TN (United States)
Publication Date:
Research Org.:
Oak Ridge National Lab. (ORNL), Oak Ridge, TN (United States)
Sponsoring Org.:
USDOE
OSTI Identifier:
1348347
Alternate Identifier(s):
OSTI ID: 1415869
Grant/Contract Number:
AC05-00OR22725
Resource Type:
Journal Article: Accepted Manuscript
Journal Name:
Electricity Journal
Additional Journal Information:
Journal Volume: 30; Journal Issue: 3; Journal ID: ISSN 1040-6190
Publisher:
Elsevier
Country of Publication:
United States
Language:
English
Subject:
29 ENERGY PLANNING, POLICY, AND ECONOMY

Citation Formats

Claire, Zeng, Hendrickson, Stephen, Lee, Sangkeun, Chinthavali, Supriya, Lin, Jessica, and Hsieh, Eric. Energy finance data warehouse: Tracking revenues through the power sector. United States: N. p., 2017. Web. doi:10.1016/j.tej.2017.03.001.
Claire, Zeng, Hendrickson, Stephen, Lee, Sangkeun, Chinthavali, Supriya, Lin, Jessica, & Hsieh, Eric. Energy finance data warehouse: Tracking revenues through the power sector. United States. doi:10.1016/j.tej.2017.03.001.
Claire, Zeng, Hendrickson, Stephen, Lee, Sangkeun, Chinthavali, Supriya, Lin, Jessica, and Hsieh, Eric. Fri . "Energy finance data warehouse: Tracking revenues through the power sector". United States. doi:10.1016/j.tej.2017.03.001. https://www.osti.gov/servlets/purl/1348347.
@article{osti_1348347,
title = {Energy finance data warehouse: Tracking revenues through the power sector},
author = {Claire, Zeng and Hendrickson, Stephen and Lee, Sangkeun and Chinthavali, Supriya and Lin, Jessica and Hsieh, Eric},
abstractNote = {Reliable data is needed to understand financial relationships in the power sector. However, relevant data acquisition and visualization can be a challenge due to the fragmented nature of the power sector. The Energy Policy and Systems Analysis office of the U.S. Department of Energy led a team of data scientists at Oak Ridge National Lab to collect revenue information from a variety of sources.},
doi = {10.1016/j.tej.2017.03.001},
journal = {Electricity Journal},
number = 3,
volume = 30,
place = {United States},
year = {Fri Mar 24 00:00:00 EDT 2017},
month = {Fri Mar 24 00:00:00 EDT 2017}
}

Journal Article:
Free Publicly Available Full Text
Publisher's Version of Record

Save / Share:
  • The Office of Energy Policy and Systems Analysis s finance team (EPSA-50) requires a suite of automated applications that can extract specific data from a flexible data warehouse (where datasets characterizing energy-related finance, economics and markets are maintained and integrated), perform relevant operations and creatively visualize them to provide a better understanding of what policy options affect various operators/sectors of the electricity system. In addition, the underlying data warehouse should be structured in the most effective and efficient way so that it can become increasingly valuable over time. This report describes the Energy Finance Data Warehouse (EFDW) framework that hasmore » been developed to accomplish the defined requirement above. We also specifically dive into the Sankey generator use-case scenario to explain the components of the EFDW framework and their roles. An excel-based data warehouse was used in the creation of the energy finance Sankey diagram and other detailed data finance visualizations to support energy policy analysis. The framework also captures the methodology, calculations and estimations analysts used for the calculation as well as relevant sources so newer analysts can build on work done previously.« less
  • This paper assesses the potential of selected efficient electrical appliances for avoiding power generation and for mitigation of selected air pollutants from the power sector in Pakistan from technical as well as national, utility and user perspectives. The study shows that about 14, 21 and 35% of the total CO{sub 2}, SO{sub 2} and NO{sub x} emissions in the business as usual (BAU) case could be avoided by the adoption of selected efficient appliances during 1997--2015 from the national perspective, while the corresponding figures from the user perspective are 12, 17 and 29%, respectively. All selected efficient appliances would bemore » cost effective to the users if electricity prices were set at the long-run marginal cost of supply.« less
  • A needed new model should make it possible to conclude whether or not a restructured electricity market produces its desired results and should serve as a tool for formulating energy policy. This proposed model is focused on four basic aspects of electricity competitiveness pertaining to consumers, efficiency, development, and reliability. (author)