Power BI Small Multiples Preview Feature

A new Small Multiples visualization feature has been released for public preview in Power BI. I was thrilled to see this first announced on the roadmap and am looking forward to putting it through its paces now that it is out in preview.

“Small Multiples” use multiple similar views to show different partitions of a dataset. Small multiples are sometimes called trellis or grid charts and until now, you have had to use custom visuals or some SVG tricks to get the functionality in Power BI. Continue reading “Power BI Small Multiples Preview Feature”

Productioneer Production Review Dashboard Update

We are happy to announce that in December 2020 Mi4 released an update to the Production Review Dashboard with new features and functionalityThis dashboard is available to all Productioneer customers and allows oil and gas organizations to efficiently aggregate and analyze oil and gas production across a diverse collection of assets quickly and efficiently in one report. 

The Production Review Dashboard offers oil and gas companies a modern dashboarding tool without procuring any software licenses or building it in house.

Continue reading “Productioneer Production Review Dashboard Update”

Azure Data Factory Date Parameters with Timezone Sensitive Default or Adhoc Values

Date and time values have been the bane of programmers’ existence since Pandora opened a box several millennia back……at least it feels that long. I wanted to share with you how we implemented flexible date parameters for an Azure Data Factory pipeline in a recent project.

Names, places, industries, widgets and other identifying information have been changed for entertainment purposes. Continue reading “Azure Data Factory Date Parameters with Timezone Sensitive Default or Adhoc Values”

Productioneer’s Daily Production BI Report

We recently put together a video highlighting the features of Productioneer’s Daily Production BI Report. We are proud to include this BI Report as a standard offering in every Productioneer subscription. Our Productioneer customers can access it using the Productioneer Report Portal.

One aspect of the report that the video does not directly touch on is the BI Report was crafted with performance in mind. We tuned the data model and report design to offer a responsive user experience. Here are a few of the best practices and strategies we used to optimize the report:

  • Using stock visualizations instead of custom visuals
  • Reducing the number of slicers on the canvas and utilizing the Filter Pane
  • Specifying interactions across all visuals to avoid unnecessary background calculations

The report works out-of-the-box for all Productioneer customers and has many advantages over standard paginated reports.

As mentioned in the video, the report can work with other Oil and Gas Production software as well. If you are interested in utilizing this report or other BI Reports in your organization, we would be excited to talk with you.

Use Power BI to Monitor Your Oil Storage Capacity with DAX Moving Averages Excluding Zeros

Productioneer has an extensive paginated report library for our customers to utilize. We have everything from simple data exports to paginated reports that highlight variances and trends.

One of the reports we have had in our library for quite a while, is the Tank Stock report. The user selects a day and the report returns the tank stock and tank production for each tank in the organization for the selected day. It aggregates the stock and production at the tank, battery, field, and organization level and provides the tank strappings (feet and inches) for each tank.  It is a standard and widely used report and I know it has not had any significant changes requested to it for at least 3 years.

Suddenly, without any warning, drastic changes in the market caused everyone to take a closer look at their storage capacity. We were receiving requests from multiple clients to add more analytics to the Tank Stock report. Continue reading “Use Power BI to Monitor Your Oil Storage Capacity with DAX Moving Averages Excluding Zeros”

Jumpstart Enverus Drillinginfo Direct Access API Integrations

Disclaimer: Mi4 is not affiliated with Enverus. Mi4 does not endorse or recommend any particular data subscription service.

Mi4 has helped many of our clients integrate data from data subscription services into their own projects and data initiatives. One of the many subscription services we have implemented solutions around is Enverus Drillinginfo’s Direct Access API.  The Direct Access API allows Enverus customers with DI Plus subscriptions to access Enverus’ extensive collection of public data and bring it in-house.

TL/DR: Check out our C# Classes and SQL scripts for the Enverus Drillinginfo Direct Access API on our GitHub.

Continue reading “Jumpstart Enverus Drillinginfo Direct Access API Integrations”

Processing the RRC Data in the Cloud with Azure Functions

As we wrote about earlier this month, the Texas Railroad Commission (RRC) released a treasure trove of data freely available to the public on their site. It was like Christmas in the Mi4 office. After we sang some carols and drank some hot chocolate, we realized that there was so much data. We didn’t know where to start.

Christmas in September

As my colleague @Talal wrote last week, we decided to get Lat/Long coordinates for every Texas well. In his post, he explained, there are many use cases for this data, so it seemed like an excellent place to start.

In this post I will go over my contribution to the exercise: creating a serverless function to process data in blob storage. Continue reading “Processing the RRC Data in the Cloud with Azure Functions”

Is Your Oilfield Management Software Doing These 6 Things?

Is Your Oilfield Management Platform Doing These 6 Things?

“Digitization is the new lubricant for the future of the oil and gas industry’s upstream sector.” –Strategy& report by PwC

In order to keep a competitive advantage in a cutthroat marketplace, world-class oil and gas operations are tapping into the latest technologies. Augmented reality (AR), machine learning, automation, and robotics are all part of ‘what’s next’ in oil and gas exploration, but the greatest investments in transformative technologies are taking shape around software designed to make exploration more agile and data more accessible than ever before. Continue reading “Is Your Oilfield Management Software Doing These 6 Things?”

Power BI Switching between Logarithmic and Linear Scales

Welcome to the second post in our miniseries: “Are You Developing Power BI Reports the Right Way?” In the two-part series we are designing a sample Power BI report visualizing the weather on Mars and using some real world techniques.

The highlights of our first post were:

    • Getting data from Mars
    • Using a JSON file as a data source
    • Performing operations in the “Get Data” phase using M
    • Implementing a Dynamic Slicer
    • Using Chiclet Slicer and Dummyimage to create a Legend Slicer
    • Making design decisions

Note: Due to the popularity of this article, we have developed a custom Power BI line chart visual that has built-in support for allowing the end users to switch the axis scales, read about it in @Talal’s post. and viewing them in Power BI Desktop.

This post will focus on:

    • Switching an Axis Between Logarithmic and Linear Scales via a Slicer
    • Adding a Date Slicer
    • Using a Dark Theme

Continue reading “Power BI Switching between Logarithmic and Linear Scales”

Productioneer Report Portal General Release

Mi4 is excited to announce the public release of the Productioneer Report Portal to all of our Productioneer customers. The Productioneer Report Portal allows Productioneer users to see their Productioneer reports directly in a web browser. To use the portal, users do not need to have Productioneer installed on their computers and can now view their reports on tablet or mobile devices.

Access to the Productioneer Report Portal is included with a Productioneer subscription and is available to all Productioneer customers at no additional cost. Since Productioneer is not priced by user, Productioneer customers can give any member of their organization or partners access to the portal at no additional fee. Continue reading “Productioneer Report Portal General Release”