Process Data from Dirty to Clean
link Origem: www.coursera.org
list 6 sequencias
assignment Nível: Introdutório
chat_bubble_outline Idioma : Inglês
card_giftcard 176 pontos
Logo My Mooc Business

Eles escolhem Edflex para desenvolver suas habilidades na empresa.

Saiba mais
Avaliações
-
starstarstarstarstar
Ver avaliação

Informações principais

credit_card Free accesso
verified_user Certificado pago
timer 22 total de horas

Sobre o conteúdo

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.

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, you will be able to do the following:

  •  Learn how to check for data integrity.
  •  Discover data cleaning techniques using spreadsheets. 
  •  Develop basic SQL queries for use on databases.
  •  Apply basic SQL functions for cleaning and transforming data.
  •  Gain an understanding of how to verify the results of cleaning data.
  •  Explore the elements and importance of data cleaning reports.

more_horiz Ler mais
more_horiz Ler menos
report_problem

Pré-requisito

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.     

dns

Programa de estudos

WEEK 1: 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.

WEEK 2: 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.

WEEK 3: 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.

WEEK 4: 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.

WEEK 5: Optional: Adding data to your resume
Creating an effective resume will help you on your data analytics career path. In this part of the course, you’ll learn all about the job application process with a focus on crafting a resume that highlights your strengths and applicable experience. Even if you aren't applying to jobs yet, it's still a good time to improve your resume. It's like spring training for the first season in a major league–you don't want to miss it!

WEEK 6: Course challenge
Prepare for the course challenge by reviewing terms and definitions in the glossary. Then, demonstrate your knowledge of the importance of sample size, data integrity, and the connection of data to business objectives during the quiz. You will also have an opportunity to apply your skill with data cleaning techniques in both spreadsheets and SQL. Finally, document, report on, and verify your data-cleaning process and results.

record_voice_over

Instrutores

Google Career Certificates
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.

store

Criador do conteúdo

Google

Google est une entreprise fondée le 4 septembre 1998 dans le garage Google dans la Silicon Valley, en Californie, par Larry Page et Sergueï Brin, créateurs du moteur de recherche Google.

L'entreprise s'est principalement fait connaître à travers la situation monopolistique de son moteur de recherche, concurrencé historiquement par AltaVista puis par Yahoo! et Bing. Elle a ensuite procédé à de nombreuses acquisitions et développements et détient aujourd'hui de nombreux logiciels et sites web notables parmi lesquels YouTube, le système d'exploitation pour téléphones mobiles Android, ainsi que d'autres services tels que Google Earth, Google Maps ou Google Play.

assistant

Plataforma

Coursera

A Coursera é uma empresa digital que oferece um curso on-line massivo e aberto, fundado pelos professores de computação Andrew Ng e Daphne Koller Stanford University, localizado em Mountain View, Califórnia.

O Coursera trabalha com as melhores universidades e organizações para disponibilizar alguns dos seus cursos on-line e oferece cursos em várias disciplinas, incluindo: física, engenharia, humanidades, medicina, biologia, ciências sociais, matemática, negócios, ciência da computação, marketing digital, ciência de dados. e outros assuntos.Cours

Você é o criador deste MOOC?
Qual a sua apinião sobre esse recurso?
Conteúdo
5/5
Platforma
5/5
Didática
5/5