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:
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 of Microsoft Excel and install the Power BI engine. We will look at Power Pivot and its shortcomings and how Excel users find it difficult to clean their data in Power Pivot. We will solve this problem by introducing Power Query through an example. After that, we will discuss the use of Power Query, Power...