Data Transformation in the Cloud

This course is part of Google Cloud Data Analytics Professional Certificate

Instructor: Google Cloud Training

3,571 already enrolled

Included with

3 modules

Gain insight into a topic and learn the fundamentals.

29 reviews

Beginner level

No prior experience required

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

29 reviews

Beginner level

No prior experience required

2 weeks to complete

at 10 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.

Skills you'll gain

Category: Data Cleansing
Category: Data Transformation
Category: Data Collection
Category: Data Visualization Software
Category: Data Integration
Category: Cloud-Based Integration
Category: Data Quality
Category: Data Validation
Category: Data Pipelines
Category: Cloud Computing
Category: Data Management
Category: Data Manipulation
Category: Cloud Security
Category: Data Integrity
Category: SQL
Category: Data Processing
Category: Extract, Transform, Load
Category: Data Governance

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

13 assignments

Taught in English

91% of learners achieved a positive career outcome

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

There are 3 modules in this course

Hi learner! This is the third course of the Google Cloud Data Analytics Certificate. Tap into your creativity as you explore the world of advanced principles of data visualization. You'll discover the benefits and challenges of transforming data in the cloud and the common tools and methods used to collect, process, and store data.

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 item1 plugin

8 videosTotal 14 minutes

Introduction to course 32 minutes
Alyx: Data analysts help others learn from data1 minute
Welcome to module 11 minute
Stages of the data journey3 minutes
Steps for effective data collection2 minutes
The process stage ensures clean and consistent data2 minutes
Manual and automated transformation3 minutes
Wrap-up1 minute

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

1 pluginTotal 15 minutes

Accessing and completing labs15 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 21 minute
Data pipelines in the cloud3 minutes
Alyssa: Improve systems by collecting data and asking questions3 minutes
The difference between ELT and ETL4 minutes
Data ingestion methods that suit your needs4 minutes
Data mapping helps ensure consistent data4 minutes
Introduction to profiling and cleaning data3 minutes
Common ways to manipulate data3 minutes
Different approaches to loading data3 minutes
Overview of data validation strategies and rules4 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.

What's included

10 videos9 readings5 assignments1 app item

10 videosTotal 30 minutes

Welcome to module 31 minute
Challenges of data transformation4 minutes
Data aggregation can make it easier to extract meaningful insights3 minutes
Consequences of duplicate data and how to eliminate it4 minutes
Overview of how joins combine data from different tables4 minutes
Data derivation to combine data and obtain new insights4 minutes
Wrap-up1 minute
Lauren: What makes candidates stand out3 minutes
Lauren and Ela: Interview role play5 minutes
Course wrap-up1 minute

9 readingsTotal 140 minutes

Benefits of data transformation plans10 minutes
Steps for developing a data transformation plan20 minutes
Activity: Analyze a data transformation plan30 minutes
Nulls and aggregate data20 minutes
SQL strategies to join data effectively20 minutes
Interview tip: Explain impact10 minutes
Glossary terms from module 310 minutes
Course 3 resources and citations10 minutes
Glossary terms from Course 310 minutes

5 assignmentsTotal 82 minutes

Module 3 challenge50 minutes
Activity Quiz: Analyze a data transformation plan10 minutes
Test your knowledge: Data transformation plans6 minutes
Test your knowledge: Data aggregation and deduplication8 minutes
Test your knowledge: Joins and data derivation8 minutes

1 app itemTotal 90 minutes

Apply RFM method to segment customer data90 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(7 ratings)

Google Cloud Training

Google Cloud

2,223 Courses4,363,502 learners

Offered by

Google Cloud

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
65.51%
4 stars
27.58%
3 stars
3.44%
2 stars
0%
1 star
3.44%

Showing 3 of 29

Reviewed on Aug 2, 2024

great content and learning, it was not easy but with practice I can make it, thank you.

Reviewed on Feb 5, 2025

it was a great experience for me ....i was highly interested in this course because they taught me well

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.