Free online courseData analytics for beginners by Google

New course

17h48m of online video course

Quality content and selected for your learning.

Certificate

Download your digital certificate of course completion after watching all course videos.

Exercises to train your knowledge

Many of the courses available have exercises to help with learning.

Free lifetime access

This course is free today and always will be, from start to finish you will pay nothing.

IT Tools

Free courses to learn how to use some IT tools to help you manage systems, lower costs, and improve staff performance

Course content preview

Data Analytics for Beginners | Google Data Analytics Certificate

0h18m

5 Skills Data Analysts Need | Google Data Analytics Certificate

0h26m

Intro to Spreadsheets, Databases, and Query Languages | Google Data Analytics Certificate

0h20m

Spreadsheets and SQL for Beginners | Google Data Analytics Certificate

0h21m

The Power of Data in Business | Google Data Analytics Certificate

0h20m

Coca-Cola: Real-World Data Analytics Example | Google Data Analytics Certificate

0h04m

Problem Solving with Data Analytics | Google Data Analytics Certificate

0h23m

Making Data-driven Decisions in Business | Google Data Analytics Certificate

0h24m

Data Analysis Using Spreadsheets | Google Data Analytics Certificate

0h34m

Communication Do's and Don't for Data Analysts | Google Data Analytics Certificate

0h42m

Understanding Data Types and Structures | Google Data Analytics Certificate

0h29m

Ensuring Credibility in Your Data | Google Data Analytics Certificate

0h28m

Databases and Metadata for Beginners | Google Data Analytics Certificate

0h35m

Organizing and Protecting Data | Google Data Analytics Certificate

0h10m

Create Your Data Analyst Online Presence | Google Data Analytics Certificate

0h14m

How to Report Your Clean Data | Google Data Analytics Certificate

0h28m

Getting Hired as a Data Analyst | Google Data Analytics Certificate

0h30m

Ways to Ensure Data Integrity | Google Data Analytics Certificate

0h33m

How to Clean Raw Data in SQL | Google Data Analytics Certificate

0h42m

Understanding Clean Data | Google Data Analytics Certificate

1h06m

Course comments

There are no comments yet for this course.

Watch the 1st video of the course

Share

Evaluate course

Go to certificates

Report a problem

Course content

0h18m

Data Analytics for Beginners | Google Data Analytics Certificate

Explore the data ecosystem, find out where data analytics fits into that system, and go over some common misconceptions you might run into in the field of data analytics. Mastering these data basics will help you empower organizations to make data-driven decisions.

0:00 Data All Around Us
5:32 How Data Becomes Insights
9:24 Working Within the Data Ecosystem
13:52 How Data Informs Better Decisions

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h26m

5 Skills Data Analysts Need | Google Data Analytics Certificate

Analytical skills are qualities and characteristics associated with solving problems using facts. There are a lot of aspects to analytical skills, but we’ll focus on five essential points: curiosity, understanding context, having a technical mindset, data design, and data strategy.

0:00 Key Skills Data Analysts Possess
6:38 Assessing Information Through an Analytical Lens
11:45 Exploring Core Analytical Skills
16:18 Using Data to Drive Successful Outcomes
20:57 Real-world Data Magic

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h20m

Intro to Spreadsheets, Databases, and Query Languages | Google Data Analytics Certificate

How do data analysts bring data to life? Well, it starts with the right data analysis tools. These include spreadsheets, databases, query languages, and visualization software. Don’t worry if you are new to these tools, we'll cover them in this video. At one point, every data analyst has been right where you are right now, and they probably had a lot of the same questions.

0:00 Learning About Data Phases, Processes, and Tools
2:43 The Data Life Cycle and Its Phases
7:30 The Six Step Data Process
14:10 Exploring Spreadsheets, Databases, and Visualization Tools

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertifica

0h21m

Spreadsheets and SQL for Beginners | Google Data Analytics Certificate

Break down spreadsheets basics to better understand a few of their features and functions. Next, see SQL in action. Data analysts use SQL in their work all the time -- like when they need a large amount of data in seconds to help answer a quick business question. If you're new to SQL, that's okay, we will walk through it with you.

0:00 The Ins and Outs of Core Data Tools
2:22 Columns, and Rows, and Cells, Oh My!
12:06 Running Queries with SQL
15:34 Becoming a Data Viz Wiz

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h20m

The Power of Data in Business | Google Data Analytics Certificate

Understand the practical ways businesses use data including the kinds of roles data analysts play in different industries, common tasks in those roles, and the importance of fairness and avoiding bias in analyzing data for business tasks.

0:00 Data Analysts Across Industries
4:54 The Power of Data in Business
9:08 Understanding How Data Relates to Fairness
14:17 Where do Data Analysts Work?

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h04m

Coca-Cola: Real-World Data Analytics Example | Google Data Analytics Certificate

Data is changing the way Coca-Cola approaches its marketing strategies. Coca-Cola uses data gathered from consumer feedback to create advertising that speaks directly to different audiences with different interests. How do they do it?

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h23m

Problem Solving with Data Analytics | Google Data Analytics Certificate

Let's talk about how to ask questions that lead to insights that can help you solve business problems. There are six basic problem types to craft effective questions that will help you collect the right data.

0:00 Introduction to Problem Solving and Effective Questioning
3:30 The Problem-Solving Roadmap
8:45 Using Data in Problem-Solving
16:00 The Art of Asking Effective Questions

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h24m

Making Data-driven Decisions in Business | Google Data Analytics Certificate

Learn about how data can empower our decisions, big and small, the difference between quantitative and qualitative analysis and when to use them, the pros and cons of different data visualization tools, what metrics are and how analysts use them, and how to use mathematical thinking to connect the dots.

0:00 How Data Empowers Decisions
5:49 Quantitative and Qualitative Data
10:21 Sharing Findings with Dashboards and Reports
15:40 Data Vs. Metrics
19:24 Connect the Dots: Large and Small Data

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h34m

Data Analysis Using Spreadsheets | Google Data Analytics Certificate

Spreadsheets are a powerful and versatile tool, which is why they’re a big part of pretty much everything data analysts do. Start learning about structured thinking, the process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.

0:00 Data Analysis Using Spreadsheets
2:24 Using Spreadsheets Like a Data Analyst
4:49 Beginner's Guide to Spreadsheets
9:09 Formulas 101
16:17 Functions 101
22:45 Discovering the Scope of the Problem
25:08 Saving Time with Structured Thinking
29:31 Staying Objective as a Data Analyst

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more to

0h42m

Communication Do's and Don't for Data Analysts | Google Data Analytics Certificate

It’s important to keep your team members’ and stakeholders’ needs in mind. You can use these communication best practices in your day-to-day work. Remember, communication is key. Think of these skills as new tools that’ll help you work with your team to find the best possible solutions.

0:00 Your Team's Needs and Expectations
5:14 Focus on What Matters
10:02 Effective Workplace Communication
14:17 Tips for Professional Communications
19:43 Communication Strategies for Success
28:42 The Data Tradeoff: Speed Vs. Accuracy
24:09 The Fool-proof Way to Deliver Data
37:28 Changing Conflict Into Collaboration

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more

0h29m

Understanding Data Types and Structures | Google Data Analytics Certificate

One key to data analytics is to figure out what type of data is right for the question you’re answering. This is where understanding the different types of data and data structures comes in. Plus, gain practical skills about how to extract, use, organize and protect your data.

0:00 Welcome to Data Types and Structures
4:09 Data Collection in our world
8:04 Determining What Data to Collect
11:53 Data Formats
17:02 Understanding Structured Data
18:56 Types of Data vs. Data Types
23:13 Data Table Components
25:38 Different Data Formats

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h28m

Ensuring Credibility in Your Data | Google Data Analytics Certificate

Learn how to analyze data for bias and credibility – this is very important because even the most sound data can be skewed or misinterpreted. Then learn about the importance of exploring good data sources and learning how to steer clear of their nemesis: bad data.

0:00 Ensuring Credibility in Your Data
1:51 From Questions to Conclusions
4:59 Biased and Unbiased Data
17:16 Understanding Biases in Data
11:10 Identifying Valid Data Sources
14:04 What is "Bad" Data?
17:00 Introduction to Data Ethics
22:01 Introduction to Data Privacy
23:59 Accessibility with Open Data

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCer

0h35m

Databases and Metadata for Beginners | Google Data Analytics Certificate

Databases make it possible to find the exact piece of information you need for your analysis. Learn how to sort data in order to zoom in on what you need, to generate insightful reports, and use metadata effectively.

0:00 Accessing Databases
0:27 Database Features
4:40 Exploring Metadata
8:33 Using Metadata Like an Analyst
12:22 Metadata Management
15:52 Working with Various Data Sources
19:02 Importing Data
22:56 Using Filters and Sorts
28:07 Large Dataset Challenges

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h10m

Organizing and Protecting Data | Google Data Analytics Certificate

Keeping your data organized is important for a few reasons: it makes it easier to find and use, helps you avoid making mistakes during your analysis, and helps to protect it. Go over the basics of organizing data for personal and professional use, file naming conventions, and security features for spreadsheets.

0:00 Data Management
0:28 Let's Get Organized
5:04 File-naming Conventions
7:39 Security Features in Spreadsheets

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h14m

Create Your Data Analyst Online Presence | Google Data Analytics Certificate

Get started building your online presence, or if you’re already part of the community, how you can take your online network even further.

0:00 Managing your Data Analyst Presence
0:28 Importance of an Online Presence
3:46 Tips for Enhancing your Online Presence
7:22 Networking Basics
9:46 Benefits of Mentorship

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h28m

How to Report Your Clean Data | Google Data Analytics Certificate

Learn how to verify and report on the integrity of your cleaned data. Reporting is a great opportunity to show stakeholders that you’re accountable, build trust with your team, and make sure you’re all on the same page about important project details. Different strategies for reporting include creating data-cleaning reports, documenting your cleaning process, and using something called a changelog.

0:00 Verify and Report Results
3:43 Checking Outputs with Expectations
8:41 The Final Step
16:38 Using Change Logs
22:37 Why Documentation is Important
26:02 Data Cleaning Insights

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #Goog

0h30m

Getting Hired as a Data Analyst | Google Data Analytics Certificate

Learn how to create a resume with your current experience, even if you're planning to switch careers. After walking through the application process, discover the different types of data analyst jobs that are available and which ones might be a fit for you.

0:00 Getting Hired as a Data Analyst
1:49 Data Analyst Job Process
8:39 Creating a Resume in Google Docs
17:47 Unique Elements of Data Analyst Resume
21:15 Translating Past Work Experience
26:09 Explore Different Data Analyst Positions

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h33m

Ways to Ensure Data Integrity | Google Data Analytics Certificate

Let’s talk about how to make sure that your organized data is complete and accurate. Clean data is the key to making sure your data has integrity before you analyze it. We’ll show you how to make your data clean and tidy.

0:00 Welcome to Data Integrity
4:22 Why Data Integrity is so Important
7:15 Balancing Objective and Integrity
10:31 Dealing with Insufficient Data
14:22 The Importance of Sample Size
17:51 Using Statistical Power
22:51 Determine Sample Sizes Through Population and Purpose
27:40 Reliable Data

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

0h42m

How to Clean Raw Data in SQL | Google Data Analytics Certificate

Learn about the different data cleaning functions in spreadsheets and SQL, and how SQL can be used to clean large datasets. See how to develop basic search queries for databases and how to apply basic SQL functions for transforming data and cleaning strings.

0:00 Use SQL to Clean Data
0:28 Understanding SQL Capabilities
3:49 SQL vs. Spreadsheets
8:04 Common SQL Queries
14:15 Cleaning String Variables Using SQL
27:03 Advanced Data Cleaning Functions
33:25 Advanced Data Cleaning Functions Pt. 2

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

1h06m

Understanding Clean Data | Google Data Analytics Certificate

Clean data is incredibly important for effective analysis. If a piece of data is entered into a spreadsheet or database incorrectly, or if data formats are inconsistent, the result is dirty data. Let's go through why and how to clean your data.

0:00 Getting Started with Data Cleansing
3:20 Why Data Cleaning is Important
9:05 Identify Dirty Data
14:31 Starting the Data Cleansing Process
20:51 Cleaning Data from Multiple Sources
26:37 Data Cleaning Features
34:43 Optimize the Data Cleaning Process
48:50 Data Perspectives
59:12 Even More Data Cleaning Techniques

This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data.

The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics.

To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ? https://goo.gle/3amvXxY

Why earn a Google Career Certificate?
? No experience necessary: Learn job-ready skills, with no college degree required.
? Learn at your own pace: Complete the 100% online courses on your own terms.
? Stand out to employers: Make your resume competitive with a credential from Google.
? A path to in-demand jobs: Connect with top employers who are currently hiring.

Visit https://goo.gle/2NCbbSc to learn more today.

#GrowWithGoogle #GoogleCareerCertifica