Familiar. Collaborative. Managed.
Data Explorer Preview for Excel represents a new way to discover, combine and refine data for your self-service BI needs. If you are new to Data Explorer, here are 5 key concepts to get you caught up on how Data Explorer can fundamentally improve the way you work with data in Excel. With Data Explorer you will:
Data Explorer brings the concept of data search to Microsoft Excel. Searching for public data using Data Explorer is easy and straightforward. You get rich and interactive previews of data. When you have found the data you need, a single click will import the data into your workbook.
Here’s an example of a search for “largest cities in Europe”.
Data Explorer supports a breadth of data sources, ranging from simple sources such as text, to more sophisticated sources like Hadoop.
File and text based sources supported include:
Relational engines supported include:
Other sources supported include:
We are also working on a new set of data sources. If there are data sources you would like to see supported, please let us know.
Data Explorer makes it easy to combine data from different data sources. The screen below shows the experience for joining data sourced from an OData feed (Products table) and a text file (Suppliers table)
Data Explorer makes it trivial to reshape and derive new value out of your data. Everything from simple operations such as filter and sort, to the more complex operations such as Unpivot are all done with just a few clicks.
The UI exposes the most useful transforms – but you can always use the Data Explorer Formula Language to harness the full power and expressivity of the Data Explorer.
Shown below is a screenshot of the menu of table transforms exposed in the UI. The formula bar that is shown above the table preview lets you invoke formulas and custom expressions should you need to drop down into the expression yourself.
Data Explorer queries are simply expressions that the UI creates for you when you go through the steps to import and reshape data from a data source. What this means practically speaking is that your queries can be refreshed on demand. The query pane has a refresh link that you can click to update your workbook with the latest data.
Give Data Explorer a shot. We think you will like it. If you have any questions or feedback, we would love to hear from you. You can reach us via the Data Explorer Forum.
Great post! It would be nice to have more videos showing how easy it is to use.
I'm assuming this is Excel 2013 - but it doesn't say so, that I can see. Could you possibly identify which product the posts relate to? Thx
Can't read the first chart - too fuzzy when enlarged.
For documentation on Microsoft “Data Explorer” Preview for Excel, including tutorials and step-by-step instructions, go to office.microsoft.com/.../start-page-HA104003813.aspx .
In the Data Explorer on Azure, one of the features was to enable the data shapes to be published as OData.
What happened to that? Is there a tool which will enable us to do it now?
I just want to say, I really like this post about the coming Data Explorer in SQL Server 2014, so I translated it into my local language: