How to enable the Data Profiling Tools in PowerBI

PowerQuery has a great set of tools called the "Data Profiling" tools that allow you to quickly understand the quality, distribution, and profile (descriptive statistics) of your dataset. 

The Column Quality tool allows you to see the percent rows that are valid, blank, or have errors (typically an error row doesn't match the column data type).

The Column Distribution tool gives you a quick visual of the value distribution in each column, along with a count of distinct and unique values contained in every column. I find this tool to be super helpful for data validation as you can use it to quickly spot data errors like 'USA' and 'USA ', where the second one has an extra blank.

The Column Profile tool gives you a summary of all the statistics regarding your column sample, it includes the minimum value, max value, standard deviation, unique values, distinct values, and the number of values. It can be very helpful when trying to spot outliers or wrong values.

You can read more about them here.

Watch the video below to learn about the Data Profiling tools in PowerQuery and how to Enable them.

@datawithluis Replying to @catgentry This is how you can enable the data profiling tools in PowerQuery for PowerBI. Let me know if you have any other questions and follow me for more data content. #DataAnalytics #dataanalyst #data #powerbi #powerbihelp #datavisualization ♬ original sound - Luis - Data Analyst


Leave me a comment on TikTok if you have any questions!  

Popular posts from this blog

How to get started with SQL

I think SQL is the most important tech skill for a Data Analyst to know. It allows you to find and manipulate data without waiting on an IT team or a Data Engineer to find and manipulate data for you. You can watch this video to learn more about why SQL is so important for a Data Analyst.  Below are my favorite FREE  SQL learning resources: SQL for Data Analysis | Free Courses | Udacity : This free course from Udacity covers everything a beginner Data Analyst should know. It covers SQL Basics (SELECT, FROM, WHERE), Joins, Aggregations, Data Cleaning, and Window Functions. It has a mix of video and written lectures along with quizzes to help you master the content. They advertise that it takes about 4 weeks to complete the course, but I think it's completely worth the time investment.  Sololearn: Introduction to SQL : Sololearn offers a great introductory SQL course that covers all the basics from SELECT statements to SQL best practices and creating/deleting tables. I wouldn't
Read more

How to become a Data Analyst

 Here is everything I would learn if I were trying to break into an entry-level data analyst role today. Just as a disclaimer, I don't think you necessarily need a college degree to be a data analyst, but a degree (in anything) certainly helps! @datawithluis Replying to @Eljay This is everything I would learn if I were trying to become a data analyst without any experience. -Excel -SQL -Data Visualization -Tableau -Networking All the links are in my bio, let me know if you have any questions, and follow me for more data content #DataAnalytics   #DataAnalyst   #SQL   #Tableau   #alteryx   #python   #PowerBI   #excel #careeradvice #breakintotech #jobtok #STEM ♬ original sound - Luis - Data Analyst Intermediate Excel (Lookups (V, X, H), Pivot Tables, String Functions, Statistical Functions) W3 Schools Excel Tutorial Youtube: FreeCodeCamp TikTok: MissExcel Intermediate SQL (Data Types, Joins, Group By, Aggregate Functions, Window Functions, Data Preparation, Perf
Read more

Data Preparation Practice

I am a huge advocate for hands-on practice when it comes to learning data skills. Whether it's SQL , PowerBI , or Tableau , I will always recommend completing hands-on exercises as part of your learning to become a Data Analyst. As I covered in one of my latest posts  Data Preparation is a crucial skill for data analysts to have in their arsenal, and in this post I will be discussing what I believe to be the best website to practice your data preparation skills, Preppindata.com The website offers a range of challenges and exercises that simulate real-world data scenarios, allowing analysts to practice and refine their data preparation techniques. By providing step-by-step solutions and fostering community discussions, preppindata.com creates an environment for learning and collaboration among data professionals. The platform is important for data analysts because it helps them become more proficient in cleaning, formatting, and transforming raw data, which are critical steps in ens
Read more