Tips for Writing an Impactful HR Resume
August 19, 2024
Article
This course is part of Google Data Analytics Professional Certificate
Instructor: Google Career Certificates
Top Instructor
757,313 already enrolled
Included with
(17,646 reviews)
Recommended experience
Beginner level
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.
(17,646 reviews)
Recommended experience
Beginner level
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.
Define different types of data integrity and identify risks to data integrity.
Apply basic SQL functions to clean string variables in a database.
Develop basic SQL queries for use on databases.
Describe the process of verifying data cleaning results.
Add to your LinkedIn profile
21 quizzes, 3 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
This is the fourth course in the Google Data Analytics Certificate. 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.
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 integrity is critical to successful analysis. In this part of the course, you’ll explore methods and steps that analysts take to check their data for integrity. This includes knowing what to do when you don’t have enough data. You’ll also learn about random samples and understand how to avoid sampling bias. All of these methods will also help you ensure your analysis is successful.
8 videos10 readings5 quizzes1 assignment1 plugin
Every data analyst wants to analyze clean data. In this part of the course, you’ll learn the difference between clean and dirty data. Then, you’ll practice cleaning data in spreadsheets and other tools.
10 videos10 readings5 quizzes1 assignment1 plugin
Knowing a variety of ways to clean data can make a data analyst’s job much easier. In this part of the course, you’ll use SQL to clean data from databases. In particular, you’ll explore how SQL queries and functions can be used to clean and transform your data before an analysis.
9 videos7 readings4 quizzes1 assignment1 plugin
When you clean data, you make changes to the original dataset. It’s important to verify the changes you make are accurate and to let your teammates know about the changes. In this part of the course, you’ll learn to verify that data is clean and report your data cleaning results. With verified clean data, you’re ready to begin analyzing!
6 videos5 readings4 quizzes
Creating an effective resume will help you in your data analytics career. In this part of the course, you’ll learn all about the job application process. Your focus will be on building a resume that highlights your strengths and relevant experience.
8 videos4 readings3 quizzes
Review the course glossary and prepare for the next course in the Google Data Analytics Certificate program.
1 video3 readings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Grow with Google is an initiative that draws on Google's decades-long history of building products, platforms, and services that help people and businesses grow. We aim to help everyone – those who make up the workforce of today and the students who will drive the workforce of tomorrow – access the best of Google’s training and tools to grow their skills, careers, and businesses.
Johns Hopkins University
Course
Course
Course
Course
17,646 reviews
84.99%
12.29%
1.85%
0.42%
0.42%
Showing 3 of 17646
Reviewed on Oct 27, 2023
Fun, concise, and on point course walking new folks through (or a great review for not so new folks) the process of identification, basic change management, and reporting for dataset validation
Reviewed on Oct 26, 2021
Good content overall. However it will be nice to have the glossary for each week not mixed up with those from previous as it makes it hard to navigate and know which new words need to be learnt
Reviewed on Nov 5, 2022
Sally is the best instructor in this course so far. The content itself started of great but I feel it didn't cover enough data cleaning techniques in the second half of the course. Still recommend!
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Data is a group of facts that can take many different forms, such as numbers, pictures, words, videos, observations, and more. We use and create data everyday, like when we stream a show or song or post on social media.
Data analytics is the collection, transformation, and organization of these facts to draw conclusions, make predictions, and drive informed decision-making.
The amount of data created each day is tremendous. Any time you use your phone, look up something online, stream music, shop with a credit card, post on social media, or use GPS to map a route, you’re creating data. Companies must continually adjust their products, services, tools, and business strategies to meet consumer demand and react to emerging trends. Because of this, data analyst roles are in demand and competitively paid.
Data analysts make sense of data and numbers to help organizations make better business decisions. They prepare, process, analyze, and visualize data, discovering patterns and trends and answering key questions along the way. Their work empowers their wider team to make better business decisions.
You will learn the skill set required for becoming a junior or associate data analyst in the Google Data Analytics Certificate. Data analysts know how to ask the right question; prepare, process, and analyze data for key insights; effectively share their findings with stakeholders; and provide data-driven recommendations for thoughtful action.
You’ll learn these job-ready skills in our certificate program through interactive content (discussion prompts, quizzes, and activities) in under six months, with under 10 hours of flexible study a week. Along the way, you'll work through a curriculum designed with input from top employers and industry leaders, like Tableau, Accenture, and Deloitte. You’ll even have the opportunity to complete a case study that you can share with potential employers to showcase your new skill set.
After you’ve graduated from the program, you’ll have access to career resources and be connected directly with employers hiring for open entry-level roles in data analytics.
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.
You don't need to be a math all-star to succeed in this certificate. You need to be curious and open to learning with numbers (the language of data analysts). Being a strong data analyst is more than just math, it's about asking the right questions, finding the best sources to answer your questions effectively, and illustrating your findings clearly in visualizations.
You'll learn to use analysis tools and platforms such as spreadsheets (Google Sheets or Microsoft Excel), SQL, presentation tools (Powerpoint or Google Slides), Tableau, RStudio, and Kaggle.
Learners can self-select which platform they want to use throughout the program: Google Sheets or Microsoft Excel. It’s up to the learner’s preference, and all activities throughout the syllabus can be performed on either platform.
We highly recommend completing the courses in the order presented because the content in each course builds on information from earlier lessons.
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.