hussain.ijtaba
What is a Power Query and how to use it
What is a Power Query and how to use it?
Power Query helps in connecting multiple source and size of data. It helps in defining an automated process while connecting first time and this can be used multiple times to save time and resources.
Power Query is a business intelligence tool to perform extract, transform and load function in Excel/Power BI. It has graphical interface to load data and Power Query Editor helps in transforming data in a desirable way.
How to use power query in Excel:
To use power query in excel we need to go in ribbon and select Data option. We will get first options as Get & Transform Data. In this option we get option Get Data which has more options to get data from multiple sources as shown in second image.
power query
We can choose any option to get data from the given source.
power query
In this example we can will use csv to understand how Power Query works. Usually CSV and text are most used options to load data in excel.
import data from csv
It will ask us to take to the folder from where we want data file to connect.
importing data
By following the above steps we will get our data, which now needs to transform(using Transform Data) or can be directly load(Load option) into the excel file. We will try Transform Data option to understand it better.
We will get options to transform our data. There are multiple tabs to transform the data. We can remove undesirable columns and can change columns data type.
What is a Power Query and how to use it
What is a Power Query and how to use it?
Power Query helps in connecting multiple source and size of data. It helps in defining an automated process while connecting first time and this can be used multiple times to save time and resources.
Power Query is a business intelligence tool to perform extract, transform and load function in Excel/Power BI. It has graphical interface to load data and Power Query Editor helps in transforming data in a desirable way.
How to use power query in Excel:
To use power query in excel we need to go in ribbon and select Data option. We will get first options as Get & Transform Data. In this option we get option Get Data which has more options to get data from multiple sources as shown in second image.
power query
We can choose any option to get data from the given source.
power query
In this example we can will use csv to understand how Power Query works. Usually CSV and text are most used options to load data in excel.
import data from csv
It will ask us to take to the folder from where we want data file to connect.
importing data
By following the above steps we will get our data, which now needs to transform(using Transform Data) or can be directly load(Load option) into the excel file. We will try Transform Data option to understand it better.
We will get options to transform our data. There are multiple tabs to transform the data. We can remove undesirable columns and can change columns data type.