Understanding Data Cleaning | Google Data Analytics Certificate

Data cleaning is essential for successful 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 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.

#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics

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.

[sustainability.s]

With clarity, eloquently and in simple language concepts are explained. Much appreciated and anyone interested in data analytics & related disciplines could learn a lot.

[ivanklful]

I've past through the entire course and I had completed it in period between July and November 2021, this year, and I earned certificate. I would say that the course is really awesome in many aspects, one of which is data cleaning jobs searching!

[kakayemi]

When you are able to clean you data, your analysis begins and that is where it all starts, data cleaning. cleaning data is critical to a good analysis

[ditsaphongthep]

Her section is the best of this course.

[robinpuerta]

Excellent summary of key functions on Spreadsheets for data cleaning!

[taiwoakinosho]

Interesting stuff. I don't use conditional formatting to find errors that much. I use filters and inspect the dropdown for inspecting anomalies. The dropdown contains unique values anyway.

[ksumar]

Nicely explained. Very clear vocabulary and examples. I've not really used Google Sheets but Excel is the King of tools I use. Some great tips were given, thank you!

[beetelvj]

This session is eazy n engaging, it's can be more effective if the whole screen in the vedio becomes the computer screen n the instructor holds a small place at the corner...it's solves the problem for those who are using it in mobile, and sometimes the text becomes hazy n hard to read.

[fuehrer_tb]

keep in mind that data cleaning is the hardest and the most time consuming phase in data analysis..

[minjinjargalsaikhan]

Thank you so much. I would love to see your videos more. I really needed this well explained content. Thank you. You are the best!

[inhlam]

* Starting the data cleansing process: 18:57
* Cleaning Data from multiple sources: 25:16, 25:48
* Data cleaning features: Conditional format rules, Remove duplicates, Split, Concatenate
* Optimize the Data Cleaning Process: 35:11, 38:27, 39:36, 40:00, 41:18
(Functions: COUNTIF, LEN, & Conditional formatting, LEFT, RIGHT, MID, TRIM, CONCATENATE, ..)
* Data perspectives: Sorting, Filtering, Pivot Table, VLOOKUP, Plotting
* Even more data cleaning techniques: Data mapping, Compatibility, Schema, Primary Key, Foreign Key

[nanasophia]

So easy to understand. Thank you so much!

[WidianiLarasati]

Easy to understand even for a very beginner like me!

[sanjayrajbanshi]

Beauty with the brain. Clearly explanation!

[federicofiorio]

12:50 The rows #27 and #31 are not duplicates, they have different SO number and different amount of dollars transfered

[shreeshree]

Can We Have A Video On Cleaning A Database With Multiple Column Header Like, Subject, Term1 & 2, Unit tests For Yearly Resuult Of a School

[AnneLopezlovesLife]

Done watching. Thanks for freely sharing this Google :)

[Mrroy]

Plz provide this Data Sets where I can access the MULTIPLE Data Sources for DATA CLEANING Portfolio Projects.

[keylanoslokj]

We have an Excel file with 10 columns and 500 rows. Last.4 columns have years and sales. There are blanks there but are randomly distributed. We want to delete the rows that have 4 blanks in a row. How would you go on about it?

[musicbox]

Is this included in Google data analytic certificate offered by coursera?