Posts

Showing posts from May, 2014

Step by Step: Power BI Q&A in Office 365

Image
While I was exploring the awesomeness of Power BI in Excel 2013 and Office 365, I came across this amazing feature of Power BI  Q&A . Simply, Q&A is a way to interact with your data, to filter, sort, aggregate, group and display data using natural language! Yea, you read that correctly, natural language!  I was really blown away by this smart yet indeed useful feature. Well, in this post I'll lay down how to utilize this amazing feature, step by step. Prerequisites First of all, Power BI features associated with SharePoint are only available with Office 365 (cloud only, not available on-prem). In order to get Power BI capabilities (app) with Office 365, you need to register for Power BI for Office 365 . You need to have Excel 2013 Professional Plus installed on your local machine. Finally, you need to start PowerPivot add-in Excel 2013 . Collect and Model Your Data There are various astonishing ways to collect your data with Excel 2013, however, I