Tuesday, May 14, 2013

Self Service BI–Excel Rocks!!

Microsoft is coming with lot of Self Service BI tools the recent addition is Data Explorer.

In Excel now you have the following component for Data Analysis

  • PowerView: You can same experience as SharePoint integrated PowerView inside excel for the data in Excel Sheet
  • PowerPivot with powerful DAX Support: There are lot of content on Web on this.
  • Data Explorer Download

Data Explorer try to standardize and customize data consumption experience.  There are many new data sources added, For example “Folder”, SharePoint List, Hadoop file, SQL Azure, Facebook.

imageimageimage

Query on Active Directory are really an interesting new way of getting data image

Facebook Graph API support

image

image

image

7 years back I have worked on POC called Mappy with HCL Technologies, the fundamentals are exactly same.  Great to see it is a product now from Microsoft.

No comments:

Post a Comment

Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...