This is the fourth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll 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.
Offered By
About this Course
No prior experience with spreadsheets or data analytics is required. All you need is high-school level math and a curiosity about how things work.
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat you will learn
Define data integrity with reference to types of integrity and risk to data integrity
Apply basic SQL functions for use in cleaning string variables in a database
Develop basic SQL queries for use on databases
Describe the process involved in verifying the results of cleaning data
Skills you will gain
- Spreadsheet
- Data Cleansing
- Sample Size Determination
- SQL
- Data Integrity
No prior experience with spreadsheets or data analytics is required. All you need is high-school level math and a curiosity about how things work.
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessOffered by
Syllabus - What you will learn from this course
The importance of integrity
Sparkling-clean data
Cleaning data with SQL
Verify and report on your cleaning results
Reviews
- 5 stars85.31%
- 4 stars12.09%
- 3 stars1.82%
- 2 stars0.40%
- 1 star0.36%
TOP REVIEWS FROM PROCESS DATA FROM DIRTY TO CLEAN
My course instructor Sally was really passionate and informative of this course. It motivated to work harder and made me more enthusiastic to indulge in this course even more.
Thank you Sally!
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.
Sally was a wonderful instructor. Her enthusiasm for data analysis was apparent and helped to keep me motivated in continuing on in my journey. Her videos were very clear and easy to understand.
This course was very informative, learning about the functions for Excel and SQL were great. I like how I was able to format my resume for specifically a Data Analyst job. Overall, just great.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
What is the refund policy?
What is data analytics?
Why start a career in data analytics?
Why enroll in the Google Data Analytics Certificate?
What background is required?
Do you need to be strong at math to succeed in this certificate?
What tools and platforms are taught in the curriculum?
Which “spreadsheet” platform is being taught?
Do you need to take each course in course order?
More questions? Visit the Learner Help Center.