I am sure it is only a matter of days (hours ?) before Power Query is updated with the Google Analytics connector as well, but I find it very interesting that new Power Query features are now first released in Power BI Designer. I had speculated earlier that Microsoft would/should focus on Designer as the … Continue reading Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t
Category: Power BI
What Is Power BI Designer And Why You Should Start Playing With It Right Now
Although Microsoft has not yet given us an official roadmap for its Power BI offering, I believe it is not beyond the realm of reason to share some educated and uneducated guesses about where the Power BI Designer might fit in. Philosophically speaking, I have heard two opinions about Microsoft creating a standalone tool that … Continue reading What Is Power BI Designer And Why You Should Start Playing With It Right Now
Check out this cool demo of Real Time Power BI Dashboard Tiles
Here is the link
Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
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. … Continue reading Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
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 … Continue reading Microsoft Releases Excel 2013 BI Stability improvements
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 … Continue reading Power BI Tutorial: Generate ID field using Power Query
Vote to Add SAP BW as Power Query Data Source
In its recent post announcing November release of Power Query, Microsoft is also asking us to take a Power Query survey. I have lobbied for a long time to have SAP BW added to the supported PQ data sources. The reasoning is simple, almost half large companies in US run SAP and a good percentage … Continue reading Vote to Add SAP BW as Power Query Data Source
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 … Continue reading Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
Click Here to download this Tutorial file Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. As we can see, we can analyze this data using three different lenses or dimensions: Product Geography Date Unfortunately, if we … Continue reading Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
What is Power BI?
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
business intelligist 