Login
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

What Is Power Query?

Itech Analytic Solutions
15/12/2017 0 0

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

You can think of an ETL tool built into your familiar Excel to search or discover data from a wide variety of data sources (both from your enterprise as well as from online public data sources). Power Query has an intuitive and interactive user interface which can be used to search, discover, acquire, combine, refine, transform and enrich the data.

Getting Started with Power Query for Excel:

Power Query allows users to search or discover data across the enterprise or from valuable public data sources available online as well as from a variety of other data sources. It allows you to bring in data into Excel from virtually any type of data sources as listed below:

From the web:

i. From a file: Excel, CSV, XML, Text or Folder that contains files with metadata and links.

ii. From a database: SQL Server, Windows Azure SQL Database, Access, Oracle, IBM DB2, MySQL, PostgreSQL and Teradata.

iii. From other data sources: SharePoint List, OData feed, Windows Azure Marketplace, Hadoop Distributed File System - HDFS, Windows Azure Blob storage, Windows Azure Table storage, Active Directory and Facebook.

Apart from the above data sources, Power Query allows you to search data publicly available online or published data from your organization. This online search of data, along with data integration from the above types of data sources, makes it a real quick ETL tool built right inside your Excel.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Write A Query To Get Nth Highest Salary
WITH CTE AS ( SELECT EmpID, EmpName, EmpSalary, RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC) FROM dbo.Salary ) SELECT EmpID, EmpName, EmpSalary FROM CTE WHERE RN = @NthRowUse of...
What Is Business Analysis?
BA is the practice of enabling change in an enterprise by defining needs and recommending solutions that value to the stakeholders.Business analysis enables an enterorise to articulate needs and the rationale...
Big Data and Its Impact On the Industry
Emerging Technologies such Big Data, Artifical Intelligence , Machine learning etc would play key role in all the enterprises Performances. For Example, by analyzing large amounts of information, both...

Pandu R. | 22/12/2017

0 0
0
What Is WorkTable In SQL Server?
What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query, there is good chance...

Amitava Majumder | 19/12/2017

0 0
0
Overview Of Database
A Database is a collection of related data organised in a way that data can be easily accessed, managed andupdated. Any piece of information can be a data, for example name of your school. Database is...

Sandeep Tiwari | 15/12/2017

0 0
0

Looking for BI Reporting Training?

Find best BI Reporting Training in your locality on UrbanPro.

Do you offer BI Reporting Training?

Create Free Profile »
Sponsored

Find Best BI Reporting Training?

Find Now »