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