Blue Margin - Oil and Gas Production

Blue Margin used Power BI to help the Colorado Oil & Gas Conservation Commission convert countless spreadsheets of tabular data into a single set of powerful analytics.

파트너에 문의 비디오 보기

Colorado Oil & Gas Conservation Commission

Blue Margin used data from the Colorado Oil & Gas Conservation Commission (COGCC) to help users gain better insight into the state’s oil and gas production levels.

Problem

The COGCC is sitting on a goldmine of historical data about oil and gas production in nearly every county in Colorado. Yet, to gain meaningful insights, users have to pour over years of granular data, and wrangle multiple spreadsheets (55 to be exact) to answer even simple (but critical) questions, such as:

• What county has produced the most oil over the past 3 years, consistently?

• What region had the least natural gas production in the past 4 years?

• How much CO2 has been produced in Montezuma County since 2010?

• Which region shows the greatest growth trend in water production?

What’s the value of these insights? The state is making serious investments in natural-resource infrastructure and needs solid insight to determine how to most effectively spend their budget. Key decision makers need accurate, rather than speculative, answers to make sound investments.

Solution

Using Power BI, Blue Margin took stale, tabular data, and transformed it into dynamic visualizations that allow users to discover insights, leading to better decisions regarding Colorado's investment in natural resources.

Now, users can easily:

• Determine total production and sales quantities, by county and resource type.

• See production levels and resources sold in an interactive map, by county and by year.

• Make meaningful comparisons of natural gas versus oil production levels by county.

• See total CO2 produced over the last 5 years by county.

. . . as well as many other insights.

Value

Using Power BI, Blue Margin transformed Colorado’s historical data into a strategic asset, empowering users in both the public and private sectors to make informed decisions about the state’s rich natural resources.

Gaining actionable, new insights from historical data is just one of the high-impact values of Power BI.

Power BI brings data to life so users have the ability to answer questions more easily, make better forecasting decisions, see historical patterns and trends, and visualize activity by geographic location through interactive maps.

Power BI 파트너가 되고 싶으세요?

인증 파트너는 팀의 중요한 부분입니다. 새로운 비즈니스 기회를 찾고, 연결하고, 전 세계 Power BI 사용자와 귀사의 재능과 경험을 공유하세요.

등록

등록하는 데 도움이 필요하세요?
pbiptnr@microsoft.com에 문의하세요.

Request demo