Start Wrangling

Speed up your data preparation with Trifacta

Free Sign Up
Trifacta Ranked #1 in Data Preparation Market Study

Dresner Advisory Services study reviews and ranks 24 vendors

Get the Report
Schedule a Demo

Data Profiling: A Secret Weapon in Your Fight Against Bad Data

Data Profiling is Making Sure Your Data is Definitive

The data profiling process is your secret weapon in your fight for good data. A data wrangler’s understanding of an overall dataset is informed by the statistical analysis of values for logic and consistency, otherwise known as data profiling. Data profiling tools evaluate quality by exploring frequency distributions of different values both within and across tables or columns. With good data profiling, the implementation cycle for a project is made shorter and discovering business intelligence embedded deep within the data is possible.

Up Your Data Profiling Game with Trifacta

Trifacta’s interactive interface was built with powerful data profiling features in mind: data is presented in the most visually compelling representations based on the inferred data type. In fact, every profile in Trifacta is completely interactive—users simply select certain elements of the profile to explore hands-on. For ease of data profiling, Trifacta automatically identifies dataset formats, schemas, specific attributes and relationships across attributes and datasets, along with associated metadata for each dataset.

These visual representations of data enable quick surfacing of patterns or problems, as well as actionable insights throughout the life of your data project. Beyond just identification, pattern profiling alerts users as to common and anomalous formatting patterns within each data type. Trifacta will also suggest script transforms for irregular or incongruent data, eventually automating that process.

Additionally, the Trifacta data quality bar is a valuable asset to your data profiling efforts. When you pull your subset of data to be profiled, Trifacta’s Results Summary page and data quality bar make profiling data easier by giving data analysts the information they need:

  • Core statistics such as the dataset’s size, distribution, quality, distinct values, median, mean, quartiles, average, and standard deviation, to name a few.
  • Percentage of valid, mismatched, and empty values in your results file.
  • The size of the results file, separated by file format.
  • Number of columns in your results file.
  • Number of rows in your results file.
  • The ID of your result file.
  • The data source that was used to generate your results file.

A data analyst’s workload is dramatically lessened by Trifacta’s uniquely interactive and predictive profiling functions. Now, analysts can not only easily spot empty or mismatched values, but with just a few clicks, they can build a transform script to clean their entire dataset. No programming needed. And when the script is executed, Trifacta generates a visual profile of the entire dataset as part of the job. In short, data cleansing and normalizing data with Trifacta has never been easier.

To learn more about Trifacta’s data profiling capabilities download our eBook Six Core Data Wrangling Activities.

Download eBook