Tutorial: Data Analysis & Profiling with HQ

Ready to use HQ Data Profiler to analyze some data? Let's open the tool.
Data Profiler & Data Analysis Tool Main Screen Click "Choose data file" and select the file. We will choose this JSON file, but HQ Data Profiler supports many other file types such as CSV, Excel, JSON, and XML:
Data Profiler & Data Analysis Tool File Selection Screen Now, we can see a preview of the file. HQ Data Profiler automatically handles arrays, nested fields, and other complex data formats:
Data Profiler & Data Analysis Tool File Data Preview Screen Scroll down to the bottom of the screen, and we can see the schema which was auto-detected and can be modified:
Data Profiler & Data Analysis Tool File Schema Selection Screen Let's click the "profile" button to get metrics from our data:
Data Profiler & Data Analysis Tool Profiling Request Screen Many metrics for each field are calculated and displayed, such as the number of unique, duplicate, and distinct values and the min, median, max, and top 10 values:
Data Profiler & Data Analysis Tool Profile Data Quality Report Screen Let's go back and click the "analyze" button:
Data Profiler & Data Analysis Tool Analyze Selection Screen Each unique value for each field is displayed, sorted with machine learning to display values most likely to be outliers first.
Data Profiler & Data Analysis Tool Data Quality Analyze Outlier Screen HQ Data Profiler does all processing securely and privately on your own device. Get started today.