June 2022
Beginner to intermediate
398 pages
7h 48m
English
Content preview from Microsoft Power BI Data Analyst Certification Guide
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...