Microsoft Office 2016: The Complete Guide by Stewart Melart

Author:Stewart Melart [Melart, Stewart]
Language: eng
Format: epub
Published: 2015-11-11T23:00:00+00:00

Step 1: Connection

Connection to only one data source, like Access database, or multiple data files, multiple databases, OData feeds, or Websites dispersed across the internet, by using a query is possible. Get & Transform allows you to unite all those sources by using your unique combinations, and discover new insights.

After choosing New Query from the Get & Transform ribbon selection in the Data tab, the data sources that are available are displayed in a menu. Numerous data sources are available to choose from inclusive of Azure services such as Blob Storage or HDInsight, databases such as SQL Server, Access, MySQL and Oracle, and various other sources such as SharePoint Lists, Facebook, Hadoop Files, Salesforce, the Web, and files like CVS or Excel workbooks and many more.

A Navigator window is displayed in Get & Transform when you make a connection to a data source. This allows the source data to be edited. Get & Transform launches a Query Editor once you have selected Edit from the Navigator button. Query Editor is a dedicated window that enables and displays your data and any transformations applied. Transform, which is the next section, more information about Query Editor will be provided.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.