community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

Data Profiling in the Browse Tool | Alteryx 11.0

Community Operations Manager
Community Operations Manager
Created on
 

 

Welcome to Alteryx 11.0's new feature Data Profiling in the Browse Tool.  We are excited about this and we hope you will be too!

 

The Data Profiling in the Browse Tool was created to assist the user in better understanding the quality of their data at any point within the workflow.

 

This option will assist users in understanding the quality of their data, assist in troubleshooting and help fix issues that may arise when attempting to parse, join, or output their data.

 

1.jpg

  

How the Data Profiling works:

 

Add a Browse Tool after any tool you want to check the quality of your data. We highly recommend getting into the habit of adding a Browse Tool after your Inputs. This will allow you to understand right off the bat what your data’s condition is in.

 

You can then run the workflow and select the Browse Tool. The Configuration Window will display graphs relating to each of your columns in your data as well as some specific information on the field and the type of data. By selecting a specific column in your Results window the Data Profiling in the Configuration Window will change showing you the quality of the data within that column. You will receive different graphs and information depending on the data type in the field.

 

Please see our wonderful online Help document for the Browse Tool which contains all of the information on the charts and Metadata, click on View data on the page to find out more. We also have a short video that will walk you through the Data Profiling.

 

Tips and Tricks:

 

The Browse Tool will only render the Data Profiling when the Browse Tool is selected. Depending on how much data that you are running into the Browse Tool, it may take a little time for the Browse Tool to render the Data Profiling reports. If you don’t select the Browse Tool when you are working in the workflow it will not use any memory until you select the Browse Tool to render the reports.

 Basic Data Profile.png

 

If you would like to capture this data and use the data in a workflow or extract that information you can use the Basic Data Profile Tool. This tool will grab the information from the Data Profiling in the Browse Tool. At this point in time, we do not have the option to export the graphs.

 

You can turn the Data Profiling feature off by going to your user settings and uncheck the "Collect and display data profile information". However, as recommended earlier in the article, using the Data Profiling after your Input Data Tool is now considered best practice and at the very least the Data Profiling should be used at this point. You can always turn the option off after you have reviewed your data. 

Comments
Alteryx Certified Partner
Alteryx Certified Partner

This is a fantastic addition to alteryx for both new and existing users. 

7 out of 10 problems i have relate to data quality.

I'm getting such good value out of this already!

 

Asteroid

This a nice feature for alteryx users.

Asteroid

I love this new feature.  It is so useful in finding issues with my data.

 

One thought though... could we change the box plot to set the whiskers at 1.5 IQR for outlier detection?

Moderator
Moderator

HI @BPurcell,

 

Have you thought about posting your comment to our Product Ideas page?

 

Thanks!

Meteor

This is Great, Thanks


Great idea for small data, but thank goodness we can turn it off. We regular have outputs > 500M rows, and it would take either forever to render or make the entire software fail. If anyone is frustrated with 11.x releases and has very large outputs, turning off this feature makes everything run extremely smooth. Alteryx is back to feeling like Alteryx!

Alteryx Partner

What is the difference between Empty and NULL in data profiling feature of Browse Tool?

Alteryx Partner

Bonjour,

Cela nous permet de faire de superbe analyse.

Mais malheureusement je n'arrive pas à exporter les graph du dataprofiling automatiquement pour les joindre à mes fichiers, à part de faire des captures d'écran.

Est ce qu'il y a un composant ou un workflow qui nous permet d'exporter automatiquement ce résultat (Graph et stat ) dans un fichier excel ou pdf  SVP ?