Managing the abandoned wells can be a challenge for some organizations since they need to have an abandonment program to identify any issues that could lead to potential leaks about the subsurface and surface abandonment. For this purpose, having a visualization report can be very helpful for prioritizing the tasks that they need to take….
The query folding can be used to increase the performance of your Power BI reports. This feature called View Native Query is available in the applied steps window in Power Query Editor. The query folding is essentially a process by which the transformations and edits that you make in Power Query Editor are sent back to…
Most of the times and for summarizing information, we convert data to pivot tables, but sometimes we need to unpivot data. For example, when we want to create a fact table in our Star Schema model. For this demonstration, I used the data from the previous post as a reference. As you may know, the…
In this report, we take a look at gas and crude oil prices in Canada and US. Gas price is shown by country, province, state and time, and numbers are in CAD. Crude Oil price is shown by time and two main types: Western Canadian Select (WCS) and West Texas Intermediate Crude oil (WTI). The numbers are in…
An event was held in Calgary at the Microsoft office on February, 27 about ETL Best Practices and Techniques, with a focus on SSIS. The speaker was Marc Beacom, a Managing Partner at Datalere, Leverages. The main items that were discussed were : ETL Templates: How we can use ETL template to have a consistent…
In recent years, the Oil and Gas industry started to utilize business intelligence not only in the financial section, but also in the technical side. However, the challenges still exist because of lake of awareness about the potential capability of BI in this industry. Here are some metrics that I have put together which can…
Microsoft recently published a technical whitepaper outlining considerations for a well-performing and secure organizational Power BI deployment. You may like to see the full report here. However, if you don’t have enough time to read all of that, here are the most important points: 1. Introduction High level overview of Power BI as both a…