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.


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.


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.


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 用户分享公司的人才和经验。



Request demo