This is the fourth course in the Google Data Analytics Certificate. In this course, you鈥檒l continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You鈥檒l learn how to check and clean your data using spreadsheets and SQL, as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, learners will:
- Check for data integrity.
- Apply data cleaning techniques using spreadsheets.
- Develop basic SQL queries for use on databases.
- Use basic SQL functions to clean and transform data.
- Verify the results of cleaning data.
- Write an effective data cleaning report
Data Cleansing, Data Quality, Spreadsheet Software, Data Analysis, Sampling (Statistics), Data Validation, Data Manipulation, Sample Size Determination, Data Integrity, Data Transformation, SQL
Reviews
4.8 (18,139 ratings)
5 stars
85.05%
4 stars
12.31%
3 stars
1.84%
2 stars
0.42%
1 star
0.36%
NN
Aug 26, 2022
S鈥媋lly is the best instructor of Google data analystics courses so far. Others are also good too. But I really love Sally's teaching way. She is so clear,knowledgable, and passionate. Geat course!
VC
Nov 9, 2021
Probably one of the more technical courses of the program developing your technical skill set and actually preparing you to become a data analyst by introducing more hands-on Excel and SQL exercises.
From the lesson
Clean data for more accurate insights
Every data analyst wants to analyze clean data. In this part of the course, you鈥檒l learn the difference between clean and dirty data. Then, you鈥檒l practice cleaning data in spreadsheets and other tools.