Chapter 3: Data Exploration in Power Query

In a business context where data is acquiring more value, users—both business analysts and technical users—need a tool to easily explore their data. In order to get relevant insights from data that is continuously growing in amount and in terms of complexity, you need to have at your disposal a range of features and capabilities that will allow you to investigate aspects such as data size, quality, distribution, types, and other factors that will be covered in this chapter.

This chapter is focused on the data exploration features of Power Query. You will learn how to choose a subset of data and explore data profiling tools and query dependencies in order to see at a glance the data you will be dealing with. You will see how to smartly use Queries and Steps panes, with shortcuts and examples. Moreover, Schema view and Diagram view will be explained.

The recipes that will be explored in this chapter are listed here:

...