skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Commodity Correlation "Double Helix"

    Commodity Correlation "Double Helix"

    03-01-2017 12:55 PM - last edited 03-03-2017 10:19 AM

    Super User Greg_Deckler
    Super User
    3976 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Greg_Deckler
    Super User Greg_Deckler
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Commodity Correlation "Double Helix"

    ‎03-01-2017 12:55 PM

    Introduction

    Recently, I was paired with Austin-based Energy Consultant and Energy Complex journalist Dallas Salazar as part of the MVP Mentoring Program for Microsoft Data Journalists. The purpose of this program is to assist journalists in leveraging and using Power BI for their work as well as helping these journalists to improve their technical skills around Power BI features and functionality. In short, Mr. Salazar developed a fascinating thesis and supporting model around enterprise risk for Oil & Gas exploration and production corporations. I provided the technical muscle to help improve the model and its presentation.

     

    Description

    The following is how Mr. Salazar describes his model and the value it provides:

     

    “The “Double Helix” model, which is constructed and executed via Microsoft Power BI’s “SandDance” data-visual, is intended to demonstrate visually – using three dimensions across an x, y, and z-axis – an Oil & Gas exploration and production company’s [“E&P”] enterprise-risk to its highly variable environment. Further, it’s meant to do this while factoring in ancillary risk measures which help determine what return the enterprise can generate for investors, if any, at which prevailing variable inputs. The Double Helix backs out marketing programs, investor relations programs, and statistical massaging to produce a model of E&P enterprise-risk which in parallel produces a quantifiable risk measure. Effectively, the Double Helix model provides viewing parties a “DNA” of the underlying E&P in which viewing parties can begin to predictively asses risk and can prescriptively determine risk-management measures.

    The Double Helix, which is a joint venture of many parties and which is the culmination of many technologies, was born out of a necessity to better manage default risk in the progressively riskier global Energy Complex. The same foundational technologies which are allowing of the Double Helix model in execution have also, through innovation and evolution, helped contribute to a global commodity pricing crisis which has caused a step-change in risk for the global Energy Complex; risk which can be quantified by historic spikes in Energy Complex bankruptcies and by historic capital destruction. Never before has the ability to predictively model risk and to prescriptively determine risk management measures been more important. Given the ability to assign a “visual-DNA” to each enterprise, using the Double Helix, viewing parties can now do this. While risk must always be managed dynamically, taking in many disciplines and many theory considerations, having a DNA with which to begin to assess predisposed conditions of variable risk is hugely powerful and, ultimately, could lead to an entirely new, entirely evolved way of protecting capital exposure.”

     

    Dallas Salazar

     

    Insights

    • First, make sure that “Oil” is displayed in the “Commodity” slicer and that “Comstock Resources, Inc (CRK)” is selected within the “Company” slicer.
    • Next, within the SandDance visual, click on the lightbulb icon to open the “Insights panel”. The first panel essentially shows oil price versus stock price at a high level. The stacks within the visual are essentially the count of how many times the stock price for CRK was at a certain value when the commodity price (oil) was at a certain price. The next panel increases the detail related to the commodity price, essentially increasing the number of “bins” for the commodity price aggregation.
    • One can clearly see a “hole” in the visual between the commodity prices of $50 and $74. According to Mr. Salazar, this shows that CRK is essentially a relatively unhealthy company within this range of commodity prices and this is due to CRK’s relatively immaturity as an oil exploration and production company.
    • One can contrast CRK with a much more mature corporation, Chevron Company (CVX), by selecting Chevron from the “Company” slicer. Here, there are not such gaping holes visible owing to the fact that Chevron has a much more mature portfolio of products that allows the company to perform well at a wider range of commodity prices.
    • Now switch back to CRK in the “Company” slicer
    • The next two panels demonstrates the ability to select an individual component of a stack within the SandDance visual and see related “Net Debt/EBITDA” and “Total Debt/EBITDA” information at that point in time as well as date information for the selected element.

    Supporting Links

    • Data Technology: Redefining the “Wealth of Nations” by Dallas Salazar
    • DiY BI - Toys, Tools and Power Tools by Greg Deckler

     

    eyJrIjoiNjVhY2E1OTUtYTUzMi00MWViLThlNWYtNDA3MTY1ZDMyMTUzIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9


    @ me in replies or I'll lose your thread!!!
    Become an expert!: Enterprise DNA
    External Tools: MSHGQM
    YouTube Channel!: Microsoft Hates Greg
    Latest book!:
    Mastering Power BI 2nd Edition
    Preview file
    478 KB
    Commodity Correlation - Final.pbix
    Labels:
    • Labels:
    • Business
    • Economics
    Message 1 of 1
    3,976 Views
    7
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks