Part 2 – Data Import and Query Editor

This part will delve into the intricacies of data import and the potent Query Editor. You will learn about the key aspects that need to be considered when importing data and build confidence in working with the Query Editor. You will also explore the M language, unraveling its syntax and capabilities for transforming data, before being introduced to data profiling for exploratory data analysis, thus enhancing data accuracy within Power BI.

This part has the following chapters:

• Chapter 5, Importing Data into Power BI
• Chapter 6, Cleaning Data with Query Editor
• Chapter 7, Transforming Data with the M Language
• Chapter 8, Using Data Profiling for Exploratory Data Analysis (EDA)