New Features of SQL Server 2014 Bi (1) five key points show you how to use data explorer in Excel

Data Explorer is a new feature in SQL Server 2014 that will be released soon. With this feature, self-help business intelligence in enterprises will become more flexible and thus lower the threshold for business intelligence.

This article was found in the official Microsoft Business Intelligence blog. I have not only translated it briefly, but also added some personal insights and notes here, if you are interested in the original text, click the link below to view the original text;

Http://blogs.msdn.com/ B /microsoft_business_intelligence1/archive/2013/05/15/5-things-you-need-to-know-about-microsoft-data-explorer-preview-for-excel.aspx

 

Data explorer preview for Excel provides a new way for self-service Business Intelligence to discover, integrate, and extract data. If you are still unfamiliar with it, the following five points will show you how to improve your data processing methods in Excel.

With data explorer, you can:

 

1. Data discovery

Data explorer introduces the concept of data retrieval in Excel (not a simple document search. In other words, you can search for public data in Excel. In Excel, you can obtain rich and interactive data. After you find the desired data, you can import the data to your Excel Workbook by simply clicking the mouse.

The following is an Excel file for retrieving data about "the largest city in Europe.

 

2. Extensive data source connections

Data Explorer supports connections to many data sources, including simple text data and complicated hadoop data.

Text data includes:

• Text based sources (plain text, CSV)

• XML

• Excel files

• Access Database

• Folders (treats files in a folder as a table)

• Webpage data sources support:

• Tables on the webpage

• Web APIs/JSON

• Odata

Relational engine, including:

• SQL Server, Windows azure SQL database, and SQL Server PDW

• Oracle

• Teradata

• DB2

• MySQL

• PostgreSQL

Other data sources, including:

• Windows azure marketplace

• SharePoint lists

• Active Directory

• Hadoop

• Windows azure hdinsight

• Facebook

More data sources will be added to the official team later. If you want to obtain support for a data source, you can contact the official team directly.

 

3. Merge data from multiple data sources

Data explorer makes data integration between different data sources easier. The following shows how to integrate product tables in odata feed with supplier data tables from text files.

 

4. More efficient data sorting and conversion

In data explorer, it is easy to organize data and derive new data based on existing data. All of this can be achieved through simple split and sort operations, and more complex operations, such as reverse perspective, can be achieved through a few simple click operations.

With the UI operation, you can achieve most conversions. You can also use the data Explorer Language to make full use of the powerful functions and expressiveness of Data explorer.

The following describes how to convert data through menus in the UI operation table. The following public area allows you to reference formulas and write custom expressions.

 

5. Refresh data at any time

Data explorer query is a simple expression. You can import data from the data source and organize the data through several simple steps. This means that these queries can be refreshed in real time as needed. There is a link on the query Panel, through which you can update the data in your workbook to the latest.

Let's take a look at data explorer. I also think that you will like it. If you have any questions or feedback, you can also browse the data explorer forum in addition to leaving a message below:

Http://social.msdn.microsoft.com/Forums/windowsazure/en-US/home? Forum = dataexplorer

 

What the translator wrote below:

As one of the new features of SQL Server 2014, data Explorer is a function in Excel. With this function, data collection and integration will no longer be the patent of IT personnel. In traditional business intelligence projects, Data Modeling and data ETL all require the support of professional tools. However, the new Excel functions of SQL Server 2014 are now available, by using familiar Excel tools and simple interface operations, business personnel can achieve self-service business intelligence. Reducing the dependence on it by a large number of demands will greatly shorten the data processing cycle. At the same time, with the help of features such as the power view, fully runs through the Business Intelligence self-service from the top to the end. From a series of new products and features released by Microsoft, we can see that business intelligence will be more flexible and efficient in the future.