Improvements to Browse Tool Data Profiling in 11.7
With the release of version 11.7, we've upgraded the graphic displays of Data Profiles. This includes more attractive charts as well as many new options to customize their display.
One of the biggest challenges in data analysis is data cleansing. We all want clean data, but sometimes it's difficult to know that there's cleaning still to be done. That's where Alteryx's Data Profiling is indispensable. As of version 11.0, the Browse tool became a convenient supplement to the Basic Data Profile tool, providing much of the same information in a more convenient format complete with graphical depictions of the data's profile. Now we have improved the Browse tool even further with Plotly visualytics built in.
The new graphics continue with the same basic format, but also allow dynamic customization.
In addition to the now-familiar color coding that indicates data quality, the graph has been reworked to order the most common string values together so that it's easier to tell which values occur most often. But the real magic is the ability to customize the display as needed using the new icons that appear when the cursor hovers over the graphic window:
In addition to being able to show details when the cursor is over a datapoint, you can now zoom in or out, and reset the axes at will. When you have the view you desire, you can save it as a .PNG file to be used as needed later.
The display with numeric fields is also enhanced with the axes labeled much more clearly on both the main plot and the whisker plot.
Hovering the cursor now displays both the column value and the record number, so that it's easier to find specific points in the data. This can be done any of three ways: using spike lines, showing both coordinates together for easy selection of points with similar values, or showing the coordinates separately for easy browsing of points in record number order.
Just as introduced in 11.0, numeric columns can be displayed as sums by time or date if Time or Date fields are also present:
All of these displays are accessed by selecting the Browse tool after running a workflow. So it's more convenient than ever to verify the cleanliness of your data.