[This documentation is for preview only, and is subject to change in later releases.]
With Microsoft “Data Explorer” Preview for Excel, you can shape data from multiple data sources by editing query steps to match your data analysis requirements.
Introduction to Microsoft “Data Explorer” Preview for Excel
With the Data Explorer Query Editor, you can navigate, define, and perform data transform operations over a data source.
Import data from external data sources
Shape or transform a query
Shape data from multiple data sources by adding, removing or editing query steps to match your data analysis requirements.
Refresh a query
Refresh a query to import the latest data into a table without having to create the query again.
Combine data from multiple data sources
Combine data from multiple data sources.
Filter a table
Filter a table to reduce the size of your query results by excluding rows or columns based on size, value or condition.
Sort a table
Sort table rows in your query results ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.
Group rows in a table
Group the values in a number of rows into a single value by grouping the rows based upon the values in one or more columns.
Expand a column containing an associated table
Expand a column containing an associated table to reveal the related data. You can extract all column values or selective column values within the related table.
Aggregate data from a column
Aggregate data from any column containing an associated table to reveal the results of a group operation including Sum, Count, Average, Min, and Max.
Insert a custom column into a table
Insert an Index or Custom (you define the formula) column to your current query.
Edit query step settings
With the Steps pane, you can add, edit, reorder, or delete query steps to change how your data is transformed.
Combine multiple queries
Combine multiple queries, by merging or appending them. The Merge and Append operations are performed on any Data Explorer query with a tabular shape, independent of the data source that the data comes from.
Remove selected columns or Remove Other Columns from a query.
Promote a row to column headers
Promote a row to column headers.
Split a column of text
Split a column of text into multiple columns in two ways: by delimiter or by a number of characters.
Insert a query to the worksheet
Insert data from a query into an Excel worksheet. When you insert data from a query, you can choose to load a query to the Excel Data Model.