Data profiling area

The Chart tab shows a graphical representation of your data. It is also a quick and easy way to apply filter on your data.

According to the data type or semantic type that you select, the graphical representation of the distribution of values in the tab will be different:

• Vertical bar charts for numerical data
• Horizontal bar charts for text data
• World map for Continent and Continent Code, Country, Country Code ISO2 and Country Code ISO3
• Map of North America for North American state and North American state code
• US map for US State and US State Code
• Map of Mexico for MX Estado and MX Estado Code
• Map of Canada for CA Province Territory and CA Province Territory Code
• Map of France for FR Departement, FR Region and FR Region Legacy

For more information and examples, check Filtering values using charts.

In other words, you will be able to see how the records are structured, with either a word, or character granularity. It is also a quick and easy way to apply filter on your data.

When selecting the content of a column, a horizontal bar chart will display the repartition of the different patterns that are used. According to the type of data that you select, the default displayed patterns will be different:

• Word-based if the column type is text or boolean
• Character-based if the column type is date or number

But whatever the type of data, you can switch between the character-based or word-based patterns from the Pattern tab.

Analyzing word-based patterns would be an efficient way to detect data quality issues in first names or last names, for example. Names that are not exclusively made of words, with punctuation or numbers, will immediately stand out. On the other hand, character-based patterns would be more suited in the case of structured data, such as client ids or account numbers. You will be able to tell from the chart if the number of characters or digits is not the right one.

For more examples, check Filtering values using patterns.