Power Query is a data transforming engine which you can use to get data from multiple sources, clean and transform that data and then use it further in the analysis.