Blog

Much has been written about the shift from ETL to ELT and how ELT enables superior speed and agility for modern analytics. One important move to support this speed and agility is creating a workflow that enables data transformation to be exploratory and iterative. Defining an analysis requires an iterative loop of forming and testing […]

It’s safe to say that 2020 showed us that data warehouses have not only found a new home in the cloud but have cemented their position as the foundation of every organization’s data strategy moving forward. By 2022, Gartner predicts the overwhelming majority of all databases (75%) will be deployed or migrated to a cloud […]

Exponential growth, coupled with a whirlwind of change – this is how I would describe the past five years of the data and analytics industry.  At the platform level, it seems like only yesterday Big Data was at its peak and we were watching many of the major platform providers go public. Now, it’s undeniable […]

Automatic data quality assessment is a Trifacta user favorite. Who wouldn’t want to give their eyes a rest from combing through data while Trifacta automatically points out possible data flaws? The feature is particularly useful when onboarding or integrating unfamiliar data. With unfamiliar data, it’s not only difficult to tell what errors might be lurking […]

We hear a lot about organizations undergoing “data modernization” in order to become more data-driven. Essentially what that means is that these organizations have recognized that legacy data tools aren’t very good at solving modern data problems. They’re in the process of moving data out of legacy mainframe databases and, at the same time, replacing […]

Google Sheets is one of the most widely-used spreadsheet tools. Still, many of its best features go undiscovered. Let’s take a closer look at how to do data validation in Google Sheets, which is commonly used to build drop-down lists.  Why data validation matters Data validation is like the analytic version of copyediting. As much […]

This article explains how to use Cloud Composer to automate Cloud Dataprep flow migration between two workspaces. This process can be leveraged for your Cloud Data Warehouse project to move from development, test, and production following what is known as Continuous Integration and Continuous Delivery (CI/CD) pipeline in agile development. At a high level, this […]

Through advanced machine learning (ML) techniques and the use of key technologies like Trifacta, Ángel has built a COVID-19 Diagnosis Tool that helps healthcare professionals better respond to COVID-19 cases.

The MIBA programme at ESADE focuses on how data-driven technologies are reshaping the world. We approach this transformation from three different perspectives: Business, Data Science, and Engineering. In the real world, the engineering part related to data sciences is progressing quickly thanks to the democratization tools and platforms that allow companies to streamline and industrialize […]

When you enter a date into Microsoft Excel, the program will format it according to the default date settings. For example, if you want to enter the date February 6, 2020, the date could appear as 6-Feb, February 6, 2020, 6 February, or 02/06/2020, all depending on your settings. You may find that if you […]

When publishing data to cloud data warehouse Snowflake for analytic use, data quality is of the utmost importance. Improperly curated data threatens the validity of the end analysis.  Data Quality Rules in Trifacta accelerates the process of ensuring data quality by automatically generating a list of data quality rules for users to select from and […]

If you are using Snowflake as your cloud analytics platform, Trifacta can help accelerate the process of data preparation and cleaning. In this demo, we will demonstrate how to use Trifacta to accelerate the process of preparing data before publishing the results to cloud data warehouse Snowflake. Specifically, we will showcase finding the price-to-rent ratio […]