Profile Data in Power BI

What is data profiling? Why do we need to perform in Power BI. Yes, Data Profiling is a crucial part of data warehousing, data migration, and Business Intelligence projects.

•You have to make sure the data which you are loading to the destination is in a good quality.

•During the process of data profiling, mainly do, identify metadata, relationships, NULL values, errors, empty values, and outliers.

Find Data Anomalies And Data Statistics:

•Column quality shows you the percentages of data that is valid, in error, and empty.

•Column distribution shows you the distribution of the data within the column and the counts of distinct and unique values, both of which can tell you details about the data counts.

•Column profile gives you a more in-depth look into the statistics within the column. This column provides several different values, including the count of rows, which is important when verifying whether the importing of your data was successful.

What is Distinct vs Unique Count?

Distinct values are all values in a column, including duplicates and null values, while unique values do not include duplicates or nulls.

Therefore, distinct in this table tells you the total count of how many values are present, while unique tells you how many of those values are not duplicates or nulls.

Check out the below demo video for the detailed explanation with the real time datasets.

Hope you found the post informative. Your valuable feedback, question, or comments about this post are always welcome by leaving me message on contact form is truly appreciated.

Click here for Demo video on Data Profiling

Discover more from LR Virtual Classroom

Subscribe to get the latest posts sent to your email.

Find Data Anomalies And Data Statistics:

What is Distinct vs Unique Count?

Discover more from LR Virtual Classroom

Share this:

Related

Published by Lashmi Bai Ravindrapandian