Chapter 1: Installation and Setup

There are many reasons why you would need to use Power Query, but here is a short summary of the reasons why Power Query is a very necessary step if you wish to prepare data for analysis, manipulation, or visualization:

Figure 1.1 – Features of Power Query

Figure 1.1 – Features of Power Query

Power Query is now integrated into all the data analysis and business intelligence tools from Microsoft, such as Excel, Analysis Services, and Power BI. It allows users to discover, combine, and refine their data from various sources.

In this chapter, we will take you through the steps you will need to follow to access Power Query across different versions ...

Get Learn Power Query now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.