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 […]
More Bertrand Cariou • December 17, 2020 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 […]
More Bertrand Cariou • December 13, 2020 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 […]
More Bertrand Cariou • November 2, 2020 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 […]
More Bertrand Cariou • October 25, 2020 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 […]
More Bertrand Cariou • October 22, 2020 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 […]
More Bertrand Cariou • October 22, 2020