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.
Dieser Kurs ist Teil der Spezialisierung Google-Datenanalyse Zertifikat über berufliche Qualifikation
52.399 bereits angemeldet
von
Über diesen Kurs
2.130.840 kürzliche Aufrufe
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 4 von 8 in
Stufe „Anfänger“
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.
Ca. 22 Stunden zum Abschließen
Englisch
Untertitel: Englisch
Was Sie lernen werden
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
Kompetenzen, die Sie erwerben
SpreadsheetData CleansingSample Size DeterminationSQLData Integrity
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 4 von 8 in
Stufe „Anfänger“
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.
Ca. 22 Stunden zum Abschließen
Englisch
Untertitel: Englisch
von
Google Career Certificates are part of Grow with Google, an initiative that draws on Google's 20-year history of building products, platforms, and services that help people and businesses grow. Through programs like these, 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.
Lehrplan - Was Sie in diesem Kurs lernen werden
4 Stunden zum Abschließen
The importance of integrity
As you start thinking about how to prepare your data for exploration, this part of the course will highlight why data integrity is so essential to successful decision-making. You’ll learn about how data is generated and the techniques analysts use to decide what data to collect for analysis. And you'll discover structured and unstructured data, data types, and data formats.
4 Stunden zum Abschließen
8 Videos (Gesamt 33 min), 9 Lektüren, 6 Quiz
5 Stunden zum Abschließen
Sparkling-clean data
Every data analyst wants clean data to work with when performing an analysis. In this part of the course, you’ll learn the difference between clean and dirty data. You’ll also explore data cleaning techniques using spreadsheets and other tools.
5 Stunden zum Abschließen
10 Videos (Gesamt 66 min), 5 Lektüren, 6 Quiz
5 Stunden zum Abschließen
Cleaning data with SQL
Knowing a variety of ways to clean data can make an analyst’s job much easier. In this part of the course, you’ll check out how to clean your data using SQL. You’ll explore queries and functions that you can use in SQL to clean and transform your data to get it ready for analysis.
5 Stunden zum Abschließen
9 Videos (Gesamt 49 min), 5 Lektüren, 6 Quiz
2 Stunden zum Abschließen
Verify and report on your cleaning results
Cleaning your data is an essential step in the data analysis process. Verifying and reporting your cleaning is a way to show that your data is ready for the next step. In this part of the course, you'll find out the processes involved with verifying and reporting data cleaning as well as their benefits.
2 Stunden zum Abschließen
6 Videos (Gesamt 28 min), 4 Lektüren, 4 Quiz
Bewertungen
Top-Bewertungen von PROCESS DATA FROM DIRTY TO CLEAN
von VR24. Apr. 2021
Google makes great professional certifications. All the classes so far have been fantastic but getting our hands dirty with the data was fun and challenging. Look forward to completing this series.
von KA17. Mai 2021
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.
von HK22. Apr. 2021
It is better to use more hands-on exercises. Some of the obvious topics repeat itself several times such as removing the duplicates. Some of the multiple choice questions have vague answers.
von MG24. Juni 2021
This course really put deep into the analytics mode. There is no looking back after finishing this course. Really helped to build the understanding about data and building career out of it.
Über den Google-Datenanalyse Zertifikat über berufliche Qualifikation
Prepare for a new career in the high-growth field of data analytics, no experience or degree required. Get professional training designed by Google and have the opportunity to connect with top employers. There are 337,400 U.S. job openings in data analytics with a $67,900 average entry-level salary.¹
Häufig gestellte Fragen
When will I have access to the lectures and assignments?
Was bekomme ich, wenn ich dieses Zertifikat abonniere?
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?
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..
