Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. It does this by provided straightforward methods for connecting to data previously unheard of, without a developer, in Excel. It also provides a basic ETL tool for those involved in self-service BI projects all within Excel.
Currently Data Explorer is only available as a preview and works with Excel 2010 SP1 or Excel 2013. You can download the Data Explorer preview from http://www.microsoft.com/en-us/download/details.aspx?id=36803.
Once you download and install the add-in you will have to enable it by going to File –> Options –> Add-Ins. Then Select COM Add-ins from the Manage dropdown and click Go
Check off Microsoft “Data Explorer” Preview for Excel from the Add-Ins available list then click OK.
Once you have enabled the add-in the DATA EXPLORER tab will appear in the increasingly crowded Office ribbon.
Let’s take a look at what this new add-in has given us.
A very detailed list of each element of Data Explorer can be found here http://office.microsoft.com/en-us/excel-help/start-page-HA104003813.aspx.
In this post I’ll walk you an example that i think all companies are starting to take a lot more seriously, which is social media sentiment. In other words how does the public perceive our company.
With the built-in ability to import data from Facebook Data Explorer can very easily analyze things like statuses, likes. comments, and much more. Let’s walk through an example:
Having the ability to create these kinds of report in a very short amount of time is exactly what our Marketing department needs to analysis our true reach.