Data Transformation in the Cloud

This course is part of Google Cloud Data Analytics Professional Certificate

Instructor: Google Cloud Training

Sponsored by Louisiana Workforce Commission

3 modules

Gain insight into a topic and learn the fundamentals.

4.3

(13 reviews)

Beginner level

No prior experience required

17 hours to complete

3 weeks at 5 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

4.3

(13 reviews)

Beginner level

No prior experience required

17 hours to complete

3 weeks at 5 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Describe the steps of the data journey and how they are used to drive data-driven decision making.
Recognize the role of data transformation in preparing data for analysis.
Describe the benefits and challenges of transforming data in the cloud.
Identify the key components of a data transformation plan.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

13 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Software Development expertise

This course is part of the Google Cloud Data Analytics Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Google Cloud

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 3 modules in this course

Embark on the ultimate data adventure! This module maps out the cloud data journey, revealing the secrets of collecting and preparing data to fuel those brilliant business insights. You’ll uncover the power of structure, the pros and cons of cloud transformation, and the essential tools that shape data along the way.

What's included

8 videos11 readings3 assignments1 app item

8 videosTotal 13 minutes

Introduction to course 31 minutePreview module
Alyx: Data analysts help others learn from data1 minute
Welcome to module 10 minutes
Stages of the data journey2 minutes
Steps for effective data collection1 minute
The process stage ensures clean and consistent data2 minutes
Manual and automated transformation2 minutes
Wrap-up0 minutes

11 readingsTotal 180 minutes

Course 3 overview20 minutes
Helpful resources and tips10 minutes
Lab technical tips10 minutes
Explore your Course 3 scenario: TheLook eCommerce10 minutes
The data journey is a flexible path20 minutes
Impacts of the data journey on decision making20 minutes
[Supplemental] Process and summarize data20 minutes
Techniques used to transform data, part 120 minutes
Techniques used to transform data, part 220 minutes
Storage options for transformed data20 minutes
Glossary terms from module 110 minutes

3 assignmentsTotal 66 minutes

Module 1 challenge50 minutes
Test your knowledge: Introduction to the data journey and collecting data8 minutes
Test your knowledge: The processing and storage stages of the data journey8 minutes

1 app itemTotal 90 minutes

Practice Transformation Methods90 minutes

Become the architect of data flow! Discover how a data pipeline works, guiding data from its origins all the way to analysis. You'll dive into each stage of the process and even get the chance to build your own SQL pipeline. Hands-on experience for the win!

What's included

11 videos9 readings5 assignments1 app item

11 videosTotal 32 minutes

Welcome to module 20 minutesPreview module
Data pipelines in the cloud2 minutes
Alyssa: Improve systems by collecting data and asking questions2 minutes
The difference between ELT and ETL4 minutes
Data ingestion methods that suit your needs4 minutes
Data mapping helps ensure consistent data3 minutes
Introduction to profiling and cleaning data2 minutes
Common ways to manipulate data3 minutes
Different approaches to loading data3 minutes
Overview of data validation strategies and rules3 minutes
Wrap-up1 minute

9 readingsTotal 170 minutes

Overview of data pipeline stages and benefits20 minutes
Strategies and tools for efficient data ingestion20 minutes
Data transformation steps to ensure reliable data20 minutes
Data transformation techniques that achieve different business needs20 minutes
Transformation approaches for securing data20 minutes
Data anonymization with generative models20 minutes
Data dictionaries and monitoring help maintain data integrity20 minutes
Analysis and visualization after the data pipeline20 minutes
Glossary terms from module 210 minutes

5 assignmentsTotal 88 minutes

Module 2 challenge50 minutes
Test your knowledge: Introduction to data pipelines10 minutes
Test your knowledge: The extract stage of data pipelines10 minutes
Test your knowledge: The transformation stage of data pipelines10 minutes
Test your knowledge: The load stage of data pipelines8 minutes

1 app itemTotal 90 minutes

Creating and managing SQL pipelines90 minutes

Ready to streamline your data operations? This module is your guide to tackling the massive amounts of data that modern businesses generate. You'll explore strategies to optimize data for analysis, and you'll practice cleaning, summarizing, and joining data sets – skills that make your insights shine.