Author Archives: Business Intelligist

Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report

012615_0200_PowerBITuto1.png

Click here to download the data file for this tutorial. We are not always lucky to have our data neatly laid out in rows and columns. Sometimes, our data come in as a formatted report and we need to find a way to massage the data before it can be loaded into a data model. This tutorial will walk you

Read more

Microsoft Releases Excel 2013 BI Stability improvements

Microsoft just released a major stability improvement for Excel 2013. Please read this post here for details. If you have Office 365 you can get this update by clicking on File->Account->Update Options->Update Now. However, many enterprise customers still chose not to deploy Click-To-Run version of office, in which case, there are links to four Knowledge Base (KB) articles at the

Read more

Power BI Tutorial: Generate ID field using Power Query

This tutorial is based on one of the earlier tutorials – How to Create a Star Schema Model. I strongly recommend that you go through it first to become comfortable with using Power Query to create facts and dimensions for your Star schema before we start working on ID generation. The data set that we’ll use in this tutorial is

Read more

SQL Server 2012 SP1 Version of ADOMD.NET is Required for Analysis Services Power Query Connector

Understandably, I was very excited to find Analysis Services as a supported Power Query data source as of November update of the product (those familiar with the Business Objects connector will find the interface to be very familiar). I am running SQL Server 2014 on my machine and have the corresponding version of the ADOMD.NET installed as well. However, when

Read more

Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)

Let’s take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better :) ). In this situation, we have two dates that describe this event, the date of being admitted and the date of being discharged from the

Read more
« Older Entries Recent Entries »