Data School

Presenting The Data School, our online resource for people who work with data

Learn More


  • English
  • French
  • German
  • English
  • Easily Publish to Data Warehouses with New Rename Functions in Trifacta

    Chances are you’re having to work with several different databases and data warehouses in your analytics stack. It just is what it is today. In order to get an accurate picture in your reporting you have to use everything. However, working with these different database can be like, well this: When publishing tables in different […]

    Nate Vaziri  |  November 24, 2020

    How to Automatically Deploy a Google Cloud Dataprep Pipeline Between Workspaces

    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 […]

    Connor Carreras  |  November 12, 2020

    Trifacta Legend November 2020: Angel Aponte

     Trifacta Legends is a monthly series showcasing users who are doing legendary work with data. Are you doing legendary work in Trifacta? Apply to be a Trifacta Legend HERE. Angel Aponte Citizen Data Scientist When Covid-19 became a global pandemic, many of us felt helpless and with little information to understand what was going on. […]

    Matt Derda  |  November 10, 2020

    Why ESADE MIBA Students Learn to Use Trifacta and AWS

    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 […]

    Marc Torrens  |  November 5, 2020

    Data Preparation Best Practices for Snowflake Data Warehouses

    Snowflake is a platform known for their separation of storage and compute, which makes scaling data more efficient. However, to get the most value from your investment in Snowflake’s Cloud Data Warehouse, your organization must break through the biggest bottleneck to analytics and AI: data preparation. Here are five data preparation best practices your organization […]

    David McNamara  |  November 4, 2020

    Follow Trifacta on Facebook, LinkedIn and Twitter.

    Advanced Analytics vs. Business Intelligence: What’s The Difference?

    Advanced analytics and business intelligence (BI) have more or less the same objective—use data to drive insights that inform business strategy. So what’s the difference?  What is business intelligence?  Business intelligence is an umbrella term for software and services that provide comprehensive yet straightforward insights about an organization’s current state. Think routine reporting or dashboarding, […]

    Matt Derda  |  November 3, 2020

    How to Change Date Format in Excel

    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 […]

    Bertrand Cariou  |  November 2, 2020

    Publishing Data to Snowflake Using Trifacta Data Quality Rules 

    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 […]

    Matt Derda  |  October 27, 2020

    How to Use Trifacta and Snowflake to Prepare Data for Home Price & Rental Analysis

    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 […]

    Brandon Hoang  |  October 27, 2020

    What Is a Customer Data Platform? A Guide to CDPs

    Today’s customers leave digital footprints behind just about every purchase. Any given buyer may start by searching on Google, visiting an eCommerce store, cross-referencing on Amazon or Google Shopping, reviewing the company’s social media channels—and several times back again—before finally making a purchase.  Gathering this kind of data is certainly helpful. But being able to […]

    Matt Derda  |  October 26, 2020

    Be a part of our internationally growing team.

    Join The Team

    Your Guide to the Benefits, Challenges, and Best Practices of Data Governance

    Picture this scenario: a group of health insurance analysts want to understand the variation in cost of a medical procedure. However,  the data they receive from partnering hospitals is stored in different systems throughout the organization and its accompanying metadata doesn’t match up, making it nearly impossible for users to understand the context of the […]

    Will Davis  |  October 25, 2020

    How to Merge Cells in Google Sheets

    Google Sheets has become the spreadsheet tool of choice for many analysts, in part due to its accessibility and collaboration features. Let’s take a closer look at how to perform a common function in Google Sheet: merging cells. More importantly, read on to learn how to merge cells in Google Sheets without losing data.  How […]

    Bertrand Cariou  |  October 25, 2020

    Leveraging the Six Elements of Excel Formatting

    Small formatting adjustments can make all the difference to a Microsoft Excel workbook. A small pop of color here, a change of font there, and suddenly, your workbook is no longer just a sea of rows and columns, but an organized, presentable table of data.  Below, we take a closer look at how to format […]

    Will Davis  |  October 24, 2020

    What Is Data Modeling and Why Does It Matter?

    Data doesn’t exist in a vacuum; understanding the relational nature of data is key to understanding its value. For example, what good would customer IDs be to a product team if those IDs didn’t coincide with the specific products that customers bought? Or, how would a marketing team conduct pricing analysis without being able to […]

    Bertrand Cariou  |  October 22, 2020

    Understanding Automated Cloud Data Warehouse with BigQuery and Looker

    This blog illustrates how the combination of Cloud Dataprep, Looker, and BigQuery fulfills the three necessary elements for a scalable, self-service data warehouse a.k.a. self-service analytics.  What is self-service analytics? Self-service analytics empower the everyday business user to create their own end-to-end analytics solution—that is, accessing data, preparing and cleansing it for use, and generating […]

    Bertrand Cariou  |  October 22, 2020

    October Legend: Misagh Jebeli

    Misagh Jebeli is truly an innovator in the data and analytics space. In the very first IT class he ever took, the teacher went over how Walmart uses data to arrange items in their shelves to boost sales. That was the moment Misagh fell in love with data.

    Matt Derda  |  October 22, 2020

    How Callahan Improved Media Impact by 90% By Automating its Cloud Data Warehouse

    What makes Callahan such a unique digital marketing agency?They start with front-end data analysis to inform client strategy—in other words, gathering as much data as possible (far beyond what would be considered standard marketing sources) to understand the client’s baseline business and marketing operations. The goal is pinpointing exactly wherein lies the biggest opportunity instead […]

    Bertrand Cariou  |  October 21, 2020

    Predicting COVID-19 Cases with Machine Learning and Trifacta

    In the fight against COVID-19, one of the best weapons at our disposal is data. But interpreting COVID-19 data isn’t always cut and dry. There’s no blueprint for a novel virus; instead, the global scientific community has had to sift through complex and ever-evolving data and, bit by bit, begin to assemble an understanding of […]

    Bertrand Cariou  |  October 14, 2020