Protiviti / SharePoint Blog

SharePoint Blog

February 19
PowerBI: Get Answers

Last week Microsoft officially released its PowerBI service for Office 365. Power BI has grown to encapsulate the four Microsoft Excel plugins/features of Power Query, Power Pivot, Power View and Power Maps. In addition, when Power BI is deployed to an Office 365 tenant you get a host of features for managing data connections, access to Power View reports via Windows 8 app, a PowerBI dashboard and my favorite natural language search.

Insights through Q&A

At the heart of Business Intelligence is the quest for information/data needed to monitor progress and make business decisions. In reality, answers to questions like ‘How many customers do we have?’ With existing BI tools these types of questions are often answered with reports. Reports are sent via email, printed out put on a SharePoint site or consumed in the form of a dash board. With Power BI this is done by typing your question.

Membership Example

In order to take PowerBI for a spin I used an Excel PowerPivot document with 5 million rows of data about the membership of my subscription based website. To get started, I simply uploaded the file which was around 80 MB (Power BI can support files up to 250 MB). Once uploaded, I just needed to enable it and click ‘Add to Q&A’ which allows you to control what data is available in the Q and A interface. I clicked ‘Search with Power BI Q&A’ and was ready to ask some questions like…

“Membership by location” (and now here is map of members by location)



I then tried “Membership by Tenure” (boom! A bar chart with membership by tenure)



Then changed it to “Membership by Tenure and Product” (WOW!)

This is a pretty powerful way of getting the information you need. The interface is pretty sleek (does require IE 10) and provides ways to change the visual from Bar Chart to Pie Chart to Map, etc. You can even save the question to the Power BI dashboard as a ‘Featured Question’ so that others can simply click on it to view the report without having to ask the question themselves. I really like this natural language option for getting to the data I need quickly and easily.

Quick Launch

© Protiviti 2020. All rights reserved.   |   Privacy Policy