Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
The Most Addictive Python and SQL Courses
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
In this lab, you will examine how Dataprep can be used on complicated data structures in BigQuery.
Syllabus
- GSP826
- Overview
- Setup and requirements
- Task 1. Retrieve dataset files
- Task 2. Open Google Cloud Dataprep
- Task 3. Create Datasets
- Task 4. Create Dataset with custom SQL
- Task 5. Parameterizing with custom SQL Datasets
- Task 6. Working with advanced data types
- Task 7. Targeted/partial deduplication
- Task 8. Run job with parameters/overrides
- Congratulations!