Chapter 3: Profiling the Data

After connecting to data and getting it into Power BI, your next step will be to profile your data, or as data scientists and statisticians call it, performing exploratory data analysis. This is the process of getting to know your data. One of the worst things you can do is to create reports without knowing how the underlying data is structured. This is particularly true of data you work with all the time. It's often a great idea to step back and really look at the data you are working with to make sure you understand what is there and what isn't.

If you have null values in a column of data, how will you handle them? If you are only getting 100 rows when you expected 10,000, what will you do?

Power BI loves working with date fields, but what if your dates are coming in as text? Or as a number?

You will have to learn how to identify these problems and correct them. The PL-300 exam may test you on how to identify and fix these problems...