Analytics - Mi4 Blog

March 16, 2023March 16, 2023

Calendar Table for Oil & Gas Data (Date Dimension)

Dates in the Oil & Gas industry data can be a little tricky.

Especially when aggregating data, such as production volumes, to a daily level, and trying to connect multiple tables with date columns.

Some tables, such as tank levels or production volumes, could be based on a Gauge Date (aka Report Date) since the data is measured, aggregated, reported or “gauged” on that date (today), but in essence it is yesterday’s data, or to be more accurate, it is the data for the 24 hour period that began yesterday at the contract hour (e.g. 6am) and ended today at that same time, or the Production Date.

Other tables could have actual dates, such as sales tickets, run tickets, operation logs, etc.

January 12, 2022January 12, 2022

Build a Nutritional Power BI Dashboard in a few minutes

Most websites that offer Nutrition Facts and Food data lookup functionality seem to offer a top down, food driven search function. First you select or search for a food and they return the nutrition facts for your selection. I was looking for the opposite and I couldn’t find it. Thanks to Power BI, I was able to build one in minutes, here’s how I did it…

April 18, 2021April 18, 2021

We ❤ Power BI so much we created a custom visual

About a year ago (March 2020) We needed a line chart that can do the following:

Allow the viewer of the report to change the Y axis scale on the fly
Allow the X axis to be placed near the top of the chart
Have the ability to invert the Y axis*

When we started, we didn’t want to reinvent the wheel, so we searched first but couldn’t find a chart on the App Source marketplace that could do all of these thing I listed above*. So we started creating our first custom Power BI Chart Visual: CHARTURO

October 20, 2019January 9, 2022

Let the data be the map in Power BI

I was recently experimenting with plotting over 1 Million well surface locations from the TX RRC data dump.

I didn’t like the traditional map; it was too cluttered. I needed a better option that also has to be quick and easy to implement…And I found one:

SandDance

July 2, 2019April 21, 2021

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 is published to the Power BI AppSource Marketplace and 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”