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 ...

Get Power Query Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.