Summary [Video]

Assessing Column Data looks at the tools and features in Power BI Desktop and Power Query Editor for assessing and profiling data within a dataset's columns. We cover essential characteristics such as column data types through to distribution and statistical properties of a column's data. This lesson shows you how to use the various graphical tools in Power Query Editor to visualize data distribution, including uniqueness and distinct values. These tools provide access to filtering functions and detection of empty column values and potential errors due to data type mismatches.

This lesson also looks at factors that impact correctly importing table relationships into a Power BI data model and pitfalls to look for when assessing and profiling column data.

Learning Objectives

• Learn how to carry out column profiling and assess table relationships in Power BI and Power Query Editor

Intended Audience

This lesson is intended for anyone who wants to use Power BI for data analysis and wants to learn how to assess the characteristics of their data before doing so.

Prerequisites

To get the most out of this lesson, you should have some experience with Power BI.