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

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”

Power BI Legend Slicer from a JSON File with M and DAX

Data is king, or queen depending on your household dynamics. How you communicate that data and its impact to your clients can help or hurt your business. Both your short and long term relationships can hang in the balance, which is why the quality and delivery of your Power BI reports are everything.

Case Study: Power BI Report Development

In this blog post mini-series, we will be taking you through the process of creating a Power BI report. The demo report draws from one we created for a client as part of a larger dashboard project. It implements a line chart to visualize the weather on Mars.

The actual report we developed had nothing to do with Mars, space, or weather, but you should find it useful to understand how real-life issues can be resolved and optimizations can be employed. The first post in the series focuses on data-prep and implementation of a legend slicer.

Continue reading “Power BI Legend Slicer from a JSON File with M and DAX”

The NEW Mi4.com

We launched our updated Mi4.com website this week! Developed in-house, we think it is a big improvement over our old site, but we’re biased. So don’t take our word for it, head over to Mi4.com and tell us what you think.

In my last post I mentioned that you would be seeing more of our new logo and that we had several releases planned in the near future. I was not pulling your leg. These are busy, exciting times at Mi4. Stay tuned.

Redgate Certified Partner

Mi4 is excited to announce that we are now a Redgate Certified Partner.

Redgate makes ingeniously simple software used by over 800,000 IT professionals and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day.

Mi4 customers have actually been enjoying the benefits of Redgate’s tools for years without realizing it. We employ SQL Compare to rollout updates across all of our customers’ databases and use SQL Monitor to ensure the Productioneer databases are operating at peak performance.

Continue reading “Redgate Certified Partner”

CockroachDB Test Drive

We do a lot at Mi4. We create turnkey applications, custom software solutions, provide BI and data visualization consulting, software integrations, cloud migrations, cloud to on-premise connectivity, and a bunch of other stuff that is slipping my mind right now. We also write fascinating and insightful blogs.

Because we offer so many IT solutions we keep a pulse on what’s going on in the IT world around us. We stay abreast of updates, changes, and new feature options that are available on the platforms we currently use, but we also keep an eye out for new products and techniques that could benefit our customers.

I came across one of these products called CockroachDB while naviguant sur Internet (French for “doing market research”). CockroachDB is a cloud-native SQL Database; a new breed of solution that is a consistently-replicated, transactional datastore by default. Now the name “CockroachDB” makes more sense doesn’t it?
Continue reading “CockroachDB Test Drive”