How to use the Data Profiling feature to analyze data?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for Snowflake, Navicat Premium

The Data Profiling feature is integrated with table data grids and BI data sources.

To use Data Profiling:

1. Click Data Profiling in the toolbar.
2. Select the specific profiling options you want to use.
3. Click Start Profiling to begin the analysis.

After profiling is complete, the results are displayed, providing information such as:

• Column Quality: Highlight data quality like null value percentages and outliers.
• Column Distribution: Present histograms illustrating the distribution of values in each column.
• Column Statistics: Display statistical information, including data type, minimum, maximum, average, standard deviation, number of distinct values, and number of null values.