Power Query is a technology that allows you to find, link, merge and optimize your data sources for analysis. Power Query enables you to import, clean and evaluate millions of rows in the data model. Compared with other Excel tools it is an incredibly short learning curve. You set up a query once and use it again with a simple refresh. Power query helps to prepare your data for a pivot table report. A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends.