Mi4 Blog
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”
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.
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”
Last week I wrote a blog post talking about the TX RRC publishing data to the public that previously was only available via a paid subscription.
After downloading the different data sets and examining the various types of data and formats, I decided to take a closer look at the data that might prove to be useful to us and to our Productioneer clients.
It is not uncommon for location and depth data, as well as other well-header and meta data to be incomplete or non-existent during a software migration, after all this data might not be considered crucial for the daily gauge sheets. Especially in the case of Excel gauge sheets, where additional columns are a waste of “prime real estate” and might be considered as cluttering that particular production report.
It would be nice if we have a quick way to pull the Lat Long data in bulk to speed up the on-boarding process.
Continue reading “Visualizing the RRC Data in the Cloud”In the world of software consulting, it is impossible to ignore the recent precipitous growth of cloud-based software solutions. Since 2016, worldwide spending on cloud-based software has increased by 42% and is expected to rise another 38% by 2020. Cloud capabilities enable new streams of connectivity to take shape in our global networks that make our businesses operate smoothly and more efficiently. Continue reading “The 7 Benefits of Creating a Simple Software Solution Using the Cloud”