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”

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”

Putting on Augusta….

We recently added a putting green to the office for goofing off, gambling, entertaining clients, keeping our skills sharp for the weekend, to relax so we’ll be more productive.

Mi4’s  address is 1502 Augusta Dr Suite 430, Houston, TX 77057….so I’ve played on Augusta.

I feel like there’s also a pun that can be made from being on Augusta DRIVE….if you think of one leave a comment.

Disclaimer: I am neither a photographer or a hand model

Tools of the Trade: Keyboards

The pen is mightier than the sword they say, but for programmers, the keyboard is our tool of choice.

Using the keyboard is the main method we put our thoughts/ideas/code into being. One can even say that the keyboard is an extension of a programmer. With the vast array of keyboard choices, programmers can find the best fit keyboard for their workflow.

Keyboard Sizes

60% keyboard - iKBC New Poker ii
Keyboards come in various sizes that can accommodate your desk space, typing preference or aesthetic. Many are familiar with the standard or full-size ANSI OR ISO keyboards but there are other “compact” formats available. Some examples of compact keyboards:

  1. Tenkeyless – keyboard without numpad
  2. 60% keyboard – generally a keyboard without numpad and F row
  3. 40% keyboard – minimalist keyboard with letters and some modifiers

These compact keyboards may have programmable layers where the numeric row or F row functionality can be accessed. On some, you can create macros that can easily run scripts or simplify hotkey combos with less key presses. EFFICIENCY! Continue reading “Tools of the Trade: Keyboards”