Advanced Data Cleanup Techniques using Cloud Dataprep (Cloud Next '19)

In this session, we’ll take a deep dive into Cloud Dataprep by Trifacta and how its advanced capabilities address the complex data manipulations required by customers for common use cases like sales analytics and category management. Challenges include working with third-party data with different formats and standards needed to assess and transform to be combined into a single consistent view. After structuring and assessing data quality with Cloud Dataprep, joining (fuzzy matching), and unioning data, you need to pivot and aggregate the data into various logical time sessions to provide meaningful insights and useful pattern trends. Based on this use case, we will demonstrate the advanced features of Cloud Dataprep to master data preparation and generate an easy-to-manage, self-documented logic that can be scheduled with dynamic parameters for repeatable outcomes.

Watch more:

Speaker(s): Cindy Sood, Sean Ma

Session ID: DA309
product:BigQuery,Cloud for Marketing; event: Google Cloud Next 2019; re_ty: Publish; product: Cloud - Data Analytics - Dataprep; fullname: Cindy Sood, Sean Ma;

[WEIyaxiong]

This is great for marketer like me who need to union all spending data from diverse advertising platforms.

[Filip-cing]

will have to give it a chance but at first glance any kind of coding and especially SQL seems easier than visual tools for data manipulation

[ravivenkatatejamucharla]

Hi Team, can anyone explain to how convert the process of what is done using console, to executable code accepting source and recipes

[maitreyibodake]

can we get the dataset in its unwrangled format to test out the capabilities?

[ravivenkatatejamucharla]

can u pls share the source dataset for practice