technifyed

Google via Coursera

Prepare Data for Exploration

4.823,395 ratings at Coursera

Overview

This is the third course in the Google Data Analytics Certificate. As you continue to build on your understanding of the topics from the first two courses, you’ll be introduced to new topics that will help you gain practical data analytics skills. You’ll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives, and how to organize and protect your data. 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:

- Find out how analysts decide what data to collect for analysis.

- Learn about structured and unstructured data, data types, and data formats.

- Discover how to identify different types of bias in data to help ensure data credibility.

- Explore how analysts use spreadsheets and SQL within databases and data sets.

- Examine open data and the relationship between, and importance of, data ethics and data privacy.

- Gain an understanding of how to access databases and extract, filter, and sort the data they contain.

- Learn best practices for organizing data and keeping it secure.

Syllabus 5

  1. Data types and structures 4 hours

    A massive amount of data is generated every single day. In this part of the course, you will discover how this data is generated and how analysts decide which data to use for analysis. You’ll also learn about structured and unstructured data, data types, and data formats as you start thinking about…

  2. Data responsibility 3 hours

    Before you work with data, you must confirm that it is unbiased and credible. After all, if you start your analysis with unreliable data, you won’t be able to trust your results. In this part of the course, you will learn to identify bias in data and to ensure your data is credible. You’ll also exp…

  3. Database essentials 9 hours

    When you analyze large datasets, you’ll access much of the data from a database. In this part of the course, you will learn about databases, including how to access them and extract, filter, and sort the data they contain. You’ll also explore metadata to discover its many facets and how analysts us…

  4. Organize and protect data 2 hours

    Good organizational skills are a big part of most types of work, especially data analytics. In this part of the course, you will learn best practices for organizing data and keeping it secure. You’ll also understand how analysts use file naming conventions to help them keep their work organized.

  5. Engage in the data community 40 minutes

    Having a strong online presence can be a big help for job seekers of all kinds. In this part of the course, you will explore how to manage your online presence. You’ll also discover the benefits of networking with other data analytics professionals.

Skills you'll practise

DatabasesData SecurityAnalysisData AnalysisSQL

Advantages and disadvantages

Advantages

  • Structured courses with graded quizzes, assignments and deadlines you can reset.
  • A shareable certificate from the university or company when you pay.
  • Financial aid is often approved for students in India (apply 15 days before you need it).
  • From Google, a well-regarded name.
  • Rated 4.8 out of 5 by 23,395 learners.
  • Self-paced: start any time.
  • A clear syllabus (5 parts) you can see before you start.

Disadvantages

  • Paid after a 7-day free trial (Coursera Plus or per course).
  • Some courses can be audited for free, but graded work and certificates need payment.

Some points apply to every course of this kind; see how we rank.

This course is paid. Here is how to take it for free

  • Free trials: You can start a 7-day free trial for many individual courses, Specializations, or a Coursera Plus subscription to test full course features. Cancel before the seventh day if you do not want to be charged.
  • Financial aid: If you cannot afford the fee for a certificate, you can apply for financial aid through the link on the course home page by filling out an application about your background and goals.

Taught by

  • Google Career Certificates

Google is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (88/100). They build what they teach.

Similar courses

Compare these

Harvard University · edX

Exercising Leadership: Foundational Principles

4.71,590 ratings

Mobilize people to tackle tough problems and build the capacity to thrive through the dangers of change

Free to audit4 weeks, 2 - 3 hours per week

Harvard University · YouTube

CS50's Introduction to Cybersecurity

An introduction to cybersecurity for technical and non-technical audiences alike. Learn how to secure your accounts, data, systems, and software against today’s threats and how to recognize and evaluate tomorrow’s as well, both at home and at work. Learn how to preserve your own privacy. Learn to v…

Free video6 videos, 7.5 hours

Harvard University · edX

Fundamentals of TinyML

4.567 ratings

Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.

Free to audit5 weeks, 2 - 4 hours per week

Harvard University · edX

Introduction to Data Science with Python

4.3174 ratings

Learn the concepts and techniques that make up the foundation of data science and machine learning.

Free to audit8 weeks, 3 - 5 hours per week

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Harvard University · edX

Data Science: Building Machine Learning Models

4.4133 ratings

Build a movie recommendation system and learn the science behind one of the most popular and successful data science techniques.

Free to audit8 weeks, 2 - 3 hours per week

Enter your email and the official page opens. Phone is optional.