See How Data Engineering Gets Done on Our Do-It-Yourself Data Webcast Series

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back


Get the latest insights on data engineering

Posts about Business Analytics

How GSK Built an Analytics Center of Excellence (COE) with Data Wrangling

When Mark Ramsey joined GlaxoSmithKline (GSK) in 2015 as its SVP of the R&D Data office, he saw an opportunity to instill change. He considered the life sciences and pharmaceutical industry a “lagging industry” from an analytics perspective, despite its appetite for data, because he rarely saw companies reuse their data. “There’s lots of data […]

Paige Schaefer  |  April 5, 2018

The Work Before Analysis: Data Prep Made Easy

Self-Service Starts Up Data visualization had traditionally been a task left to the IT department. Since IT staff were the only ones with the keys to the data, it made sense that they’d be the ones to prep the data and use it to create dashboards and visualizations. This system had a few obvious weak […]

Will Davis  |  February 22, 2018

Why Excel & Access are the VHS Tapes of Data Prep

While sitting in a cubicle, doing the kind of work you would expect I’d be doing in a cubicle at a large company, I got a Gchat message from my wife. It wasn’t one of her normal Gchat questions—she was asking why her VLOOKUP in Excel was not working. Now, my wife is no dummy. […]

Matt Derda  |  February 22, 2018

Actuaries and Data Overload: An Insurance Use Case

The current low interest rate environment is affecting the bottom line of insurance, threatening income from rate-sensitive products and investments and in turn putting increased pressure on underwriting accuracy to make up the difference. Actuaries are now expected to provide more personalized and accurate policies using information gleaned from of a host of new sources […]

Bertrand Cariou  |  January 31, 2018

More Data is More Power…with the Right Tools

The increased volume of data available to the insurance industry means more information for making informed business decisions—both at the higher level of executives and the micro-level of quantitative analysts. The essential component to truly benefiting from this data, however, lies in using the right data wrangling tools available. Properly executed, wrangling provides data insights […]

Nitesh Patel  |  January 23, 2018

Follow Trifacta on Facebook, LinkedIn and Twitter.

IFRS 17: Get Your Reports Right On Day One

Insurance organizations are now going through what banks have endured for the last 15 years—significant changes in compliance and regulation. Banks initially took a siloed approach to compliance, with business unit by business unit implementing specific solutions. No one knew that regulation would hit banks so hard and, over time, this siloed, uncoordinated response turned […]

Bertrand Cariou  |  January 10, 2018

How Consensus Corporation Accelerated Retail Fraud Detection with Trifacta

Today, we’re excited to officially announce Consensus Corporation as a new customer. Read more about how Consensus is leveraging Trifacta here, and visit our customer page to learn about all of our customer stories.   Retail data powers Consensus Corporation. The company built a platform for retailers that simplifies the complex process of “multiplex selling,” […]

Paige Schaefer  |  November 16, 2017

Garbage In, Garbage Out: Why Data Quality Matters

Data quality refers to the accuracy and cleanliness of data. It includes examining data consistency, completeness, and relevance. Reliable data quality is required for strategic decision-making when we are working with organizational data in an enterprise. The phrase “garbage in, garbage out” is well known to those who wrangle data. And without good data, you cannot […]

Paige Schaefer  |  November 1, 2017

Data Onboarding:
Why It’s Broken, and Why It Matters

Data onboarding—the preparation of unfamiliar data from disparate sources, both internal and external to the organization—is a complex process. Whether it’s combining multiple streams of marketing data into a singular dashboard or augmenting customer data with third-party information, data onboarding involves huge volumes of data and repeats every time new information and sources are found—in […]

Bertrand Cariou  |  October 20, 2017

The Role of Self-Service Data Preparation
in Analytics Modernization

This article was originally published by Datanami on October 5, 2017.  It’s no secret that data is playing an increasingly important role in not only today’s business environment but also within our society as a whole. In a May 2017 article, The Economist laid out why data has overtaken oil as the world’s most valuable resource. […]

Wei Zheng  |  October 12, 2017

Be a part of our internationally growing team.

Join The Team

How Royal Bank of Scotland Optimized Analytics with Data Wrangling

Accelerating Analytics: A Constant Struggle for Data-driven Organizations Organizations that efficiently utilize data to drive decision-making and operational efficiency outperform their competitors. In an Economist Intelligence Unit survey, 76 percent of executives from top-performing companies cited data collection as very important or essential, compared with only 42 percent from low-performers. Data-centric firms are able to […]

Bertrand Cariou  |  August 17, 2017

Optimize SAS Investments with Data Wrangling

The Rise of Data Wrangling Of the many steps required to accurately analyze big data, none is more time-consuming than data preparation. In fact, 80 percent of the analysis process is spent preparing data ahead of any type of analysis. Attempts to solve the problem of data preparation first began in academic circles. Over 20 […]

Will Davis  |  August 14, 2017

Modernize Your Analytics Tools for Faster Results—at Less Cost

Analytics for Yesterday and Today There’s a considerable strain in today’s data analytics landscape. The sheer volume of data today requires robust analysis tools that can handle diverse structures at scale, while shrinking IT budgets and the heightened speed of business call for self-service products designed for business users. Firms using full-stack legacy solutions are […]

Paige Schaefer  |  August 8, 2017

How Nordea Bank Leverages Trifacta
to Accelerate Financial Reporting

Nordea Bank is one of the largest banks in Europe, with over 10 million customers in the Nordic region. As such, they are subject to the highest level of regulatory oversight in the financial services industry. These regulations demand fast delivery on top of precise data, and Nordea recognized a need to rethink its existing […]

Bertrand Cariou  |  June 30, 2017

Managing Diverse Data for Financial Regulatory Reporting

Regulatory reporting requires that diverse data from across the bank be brought together quickly, which can be extraordinarily expensive and resource-intensive. From 2009-2014, reporting challenges led to $204B in fines, even with financial firms spending over $4 billion a year on compliance. Managing diverse data for regulatory reporting is a multi-tiered challenge for today’s banking […]

Will Davis  |  June 27, 2017

3 Data Strategies for Banks to Thrive in a Changing Compliance Landscape

Regulatory compliance costs eat up nearly 20% of a financial services company’s “run-the-bank” cost base, and 40% of “change the bank” costs for projects currently underway. BCBS-239 and Dodd-Frank help protect consumers, but require investment to manage at scale, putting pressure on banking sector profits. Failure to comply led to over $200B in fines from […]

Paige Schaefer  |  June 20, 2017

Effective and Efficient Customer Behavior Analysis

How well do you know your customers? It’s a seemingly simple question that becomes increasingly difficult to answer as you dig into the nuances of customer preferences and habits in correlation with demographics such as age, gender, location, etc. But it’s worth the effort. Answering this question is the key to improving products, gaining new […]

Paige Schaefer  |  June 19, 2017

Data Wrangling Versus ETL: What’s the Difference?

This article was originally published on TDWI Upside on February 10, 2017.  Over the past few years, data wrangling (also known as data preparation) has emerged as a fast-growing space within the analytics industry. Once an analysis bottleneck due to painful, time-consuming work preparing diverse data sources for reporting and analysis, data wrangling technologies have […]

Wei Zheng  |  June 12, 2017