Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Public Preview of Data Explorer

with 7 comments

The Public Preview of Data Explorer (which some of you know I’ve been following for a while, since it first appeared in SQL Azure Labs), is now available for download. You can get it here:
http://www.microsoft.com/en-us/download/details.aspx?id=36803

There’s also a good video overview here:

Data Explorer

In a nutshell, Data Explorer is self-service ETL for the Excel power user – it is to SSIS what PowerPivot is to SSAS. In my opinion it is just as important as PowerPivot for Microsoft’s self-service BI strategy.

I’ll be blogging about it in detail over the coming days (and also giving a quick demo in my PASS Business Analytics Virtual Chapter session tomorrow), but for now here’s a brief list of things it gives you over Excel’s native functionality for importing data:

  • It supports a much wider range of data sources, including Active Directory, Facebook, Wikipedia, Hive, and tables already in Excel
  • It has better functionality for data sources that are currently supported, such as the Azure Marketplace and web pages
  • It can merge data from multiple files that have the same structure in the same folder
  • It supports different types of authentication and the storing of credentials
  • It has a user-friendly, step-by-step approach to transforming, aggregating and filtering data until it’s in the form you want
  • It can load data into the worksheet or direct into the Excel model

There’s a lot to it, so download it and have a play! It’s supported on Excel 2013 and Excel 2010 SP1.

UPDATE: Check out the following blogs/links for Data Explorer:

http://blogs.msdn.com/b/dataexplorer/archive/2013/02/27/announcing-microsoft-data-explorer-preview-for-excel.aspx

http://social.msdn.microsoft.com/Forums/en-US/dataexplorer/

http://office.microsoft.com/en-us/excel-help/learn-about-data-explorer-formulas-HA104003958.aspx?CTT=5&origin=HA104003813

http://blogs.msdn.com/b/mllopis/archive/2013/02/28/get-microsoft-quot-data-explorer-quot-preview-for-excel-today.aspx

Written by Chris Webb

February 27, 2013 at 6:04 pm

Posted in Data Explorer

7 Responses

Subscribe to comments with RSS.

  1. [...] Chris Webb posted about Data Explorer being available for public preview and I thought I will give it a quick spin. You can download it here . The installation is pretty straightforward. After the installation, when you open Excel (I am using Excel 2010), you would see a new Data Explorer tab like below. [...]

  2. [...] Public Preview of Data Explorer by Chris Webb. [...]

  3. Looks impressive!

    Frenk

    March 1, 2013 at 12:26 am

  4. The Data Explorer Formula Language is quite extensive. It appears that with Excel 2010 SP1 Data Explorer supports data downloads to a workbook but not to a PowerPivot model.

    Philip Taylor

    March 2, 2013 at 3:20 am

  5. Hi – It is Faisal from the Data Explorer team here. You can load data into the PP model in 2010 but you need to go into PP to do this. Simply use the connection that Data Explorer sets up and pull from PP. This is because Excel 2013 includes the xVelocity engine natively, whereas in 2010 it is not possible to push data into the model from Excel (without explicitly going into PowerPivot).

    Faisal Mohamood

    March 2, 2013 at 5:08 am

  6. [...] Public Preview of Data Explorer [...]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,309 other followers

%d bloggers like this: