Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Moving Analytics to the Cloud?

Survey of 600+ data workers reveals biggest obstacles to AI/ML in the cloud

Get the Report
Schedule a Demo

What’s the difference between Data Wrangling and ETL?

February 16, 2017

Born out of necessity, data wrangling has emerged as a solution used to facilitate and expedite the data analysis process. With the constantly expanding amount of new and diverse data sources, business analysts can easily spend up to 80 percent of their time formatting and standardizing data before ever getting a chance to derive value from it. While traditional ETL technologies focus on enabling IT users to extract, transform and load data into a centralized enterprise data warehouse for reporting, data wrangling solutions are specifically designed for business users to explore and prepare diverse data themselves for a variety of downstream uses.

As head of products at Trifacta, clients, partners and analysts are always asking me to differentiate data wrangling and ETL. Given there is some overlap in functionality across the two tool sets, I can understand why there is some confusion. To highlight the differences between data wrangling and ETL, I’ll explain three major differences between the two technologies.

Check out the full article on TDWI here.

Related Posts

The New Competitive Differentiator? Your Data

Whether you’re in government or retail, healthcare or financial services, telecom or consumer products,... more

  |  May 27, 2016

How to Wrangle Third-Party Data In Record Time

Working with your own data is challenging enough, but today, most organizations rely upon some form of... more

  |  June 28, 2016

Why Data Wrangling is Key to Avoiding a “Frozen” Data Lake

When one of the biggest healthcare providers designed and implemented a data lake, they had big expectations.... more

  |  April 29, 2016