The Power BI suite is being developed rapidly and will be going through some exciting changes in the next year.  Last year Power BI was released as an add-in for Office 365 Enterprise accounts and the individual components are add-ins for Excel 2013 ProPlus.  The Power BI Designer and new platform, which was recently made available as an early preview, will not require Excel or Office 365 - but it will be a while before all of the features are ready for use outside of demonstrations and proofs of concept.  


 Important ADMIN Notice

There are embedded videos below. Currently the Wiki only allows to embed HTTP videos.

But due to the fact that Wiki by default loads in HTTPS, you will get a popup to load secure content only.

You can click "Show all content" to load the embedded videos.

The issue has been reported and is under investigation.



The landscape of Power BI and "the components of Power BI" as they are offered today can be explained as follows:

  • The components of Power BI (e.g. Power Query, Power Pivot, Power View and Power Map) are a comprehensive set of tools that can be used on an analysts desktop to build small-scale reporting and dashboard solutions for individual use.
  • For collaborative solutions, Power Pivot and Power View in Excel 2013 can be published to an on-premises SharePoint BI Center site to be shared by members of an organization.
  • These same assets can be published to an Office 365 BI site with the additional capabilities of Power Q&A natural language queries, the Data Management Gateway and scheduled data refresh.

I'm presenting workshops, user group and conference sessions on using the Power BI along with the guidelines and principle to create a complete solution.  I've captured a short version of the presentation in a series of five 10-minute video demonstrations.  Enjoy.


Segments include:

  • Part 1 - Power Query
  • Part 2 - Power Pivot
  • Part 3 - Power View
  • Part 4 - Data Correlation
  • Part 5 - Publish to Office 365

Part 1 - Power Query

Part 2 - Power Pivot

Part 3 - Power View

Part 4 - Data Correlation

Part 5 - Publish to Office 365


You can view these tutorials on my blog here