“Learning is a process, a method, an area of mastery, and with effort, focus, and practice, we can get a lot better at gaining expertise.” – Ulrich Boser

Today I am going to speak to you about Exam DA-100: Analyzing Data with Microsoft Power BI. I will talk about my experience, how I passed the exam, and then give you some tips to help you be successful too. All the links needed to access a suggestion is located on the last page. Enjoy!

We recently helped The Oil & Gas Technology Center (OGTC) and Microsoft to facilitate a codeless Power Platform hackathon to solve industry challenges like tackling CO2 emissions, avoiding downtime, increasing asset efficiency, etc. Intelligent Plant provided a live connection to vendors historians some of which contained years of data using the Industrial App Store.  Rightfully, the participants (engineers, data scientists and others) went ahead and tried to extract RAW data from data silos containing 5+ years of data for multiple sensors at 1s frequency, but is this the right approach?

Extracting data from the websites could be easy but equally tricky. In this article, I explain how we can get data from multiple webpages in one go, using Power BI parameters.

In this article I review the difference between data types, data formats and data categories available in Power Query and Power BI. It's a long topic and this post brings an introduction to that topic.

Data historians are used throughout industry for mass-long term storage of time series data. There are a number of historians on the market with varying popularity but one thing they tend to have in common is their lack of integration options to popular visualisation tools such as Microsoft Power BI. Until now....