Chevron Left
Volver a Analyze Data to Answer Questions

Opiniones y comentarios de aprendices correspondientes a Analyze Data to Answer Questions por parte de Google

4.6
estrellas
7,670 calificaciones

Acerca del Curso

This is the fifth 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 explore the “analyze” phase of the data analysis process. You’ll take what you’ve learned to this point and apply it to your analysis to make sense of the data you’ve collected. You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations on your data to complete business objectives. You’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. 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: - Learn how to organize data for analysis. - Discover the processes for formatting and adjusting data. - Gain an understanding of how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets for data calculations. - Learn how to complete calculations using SQL queries....

Principales reseñas

PB

23 de dic. de 2022

Very good and useful practice of SQL. The JOIN party is pretty hardcore so I definitely couldn't master it but got enough of an understanding where I could learn quickly with some on the job training.

TK

6 de ene. de 2022

An excellent course for learning analysis techniques using Spreadsheets and SQL. Recommended for all engineering and data science students as well as for those managing businesses and human resource.

Filtrar por:

1 - 25 de 1,479 revisiones para Analyze Data to Answer Questions

por William G

23 de may. de 2021

This module is honestly very badly made.

Firstly, there is a lack of explanation on more complex queries.

Secondly, some of them do not work and give syntax errors even after trying multiple times.

Thirdly, I encountered a question on the weekly challenge that was marking the right answer as wrong and suggesting the wrong one was correct.

There are a lot of similar complains in the week 4 of this module in the discussion. For an important module that is heavily covered in SQL, it should have been better made. Unfortunately, I will have to redo SQL in a different course to learn better.

por Mahmoud E I

29 de may. de 2021

Does the instructor even know that this is a course for beginners who have zero experience with SQL ? She was too fast in SQL Queries, and she wasn't even explaining why and what is she doing, frankly you could've added all SQL videos without any commentary from her and it wouldn't have a made any difference.

Will have to study SQL from a different source. Very poorly put course.

por Mohamed A E

18 de abr. de 2021

although the reading material is very well constructed, but in that particular course all video materials were useless to me; the instructor talked so fast, she went through complicated formulas and queries with a very quick pace making it impossible to follow with her

por Gyuyong “ H

2 de abr. de 2021

The difficulty level has gone up so high from the previous module.

It was quite difficult to follow on some part of the module.

por Yichen P

22 de may. de 2021

It is the worst course amongst all courses of this certificate..

por Mariya A

29 de abr. de 2021

I'm a little disappointment in the teaching format here - it seems like there should be more structure and repetition of concepts. I was really discouraged in Week 1 where the Qwiklabs project was totally out of scope for the rest of the Week 1 syllabus - I found myself copying and pasting SQL without any context about meaning. I feel that there should be a whole module of videos about just using some of the Spreadsheet and SQL functions via elementary case studies. I understand everything in the moment and pass the tests, but I don't feel like this necessarily prepares me for the job.

por Ivelina T

6 de may. de 2021

Well, we didn't answer many questions in that course. We did, however, get the copy/past SQL queries, watch presenters write SQL queries, putting more effort in spelling out the name of the database that they were querying than actually explaining the query itself. Oh, yes, and at one of the labs, we did get to see a solution which was incorrect and made no sense.

por Elzbieta Z

5 de ago. de 2021

This is definitely the weakest course in this specialization so far which is telling, because the whole package and concept has been extremely bad so far. Please be aware that you will not learn how to analyze data, in spite of the title. You will learn about a bunch of – useful, I admit – formulas and functions, but there is no mention how to read the results you receive and what are they telling you. Please note the use of the word “about” in the previous sentence. This is deliberate. You will not learn how to use the functions, different situations they might come useful etc. They are shown with no context whatsoever. This applies mostly to the SQL commands. We are bombarded with more and more complex functions with absolutely no explanation, and the quizzes and challenges openly instruct: copy and paste this command and see what happens. Google evidently has zero respect for the students and just wanted to join the mass MOOC hysteria that started during the pandemic.

I have no idea who is the target audience for this specialization and this course in particular. On one hand, they treat you as if you’d never seen a spreadsheet or even a number before, on the other, in order to understand certain topics you need to already be an expert. I really don’t understand why didn’t google create separate courses for SQL and spreadsheets using the BigQuery and Google Sheets respectively. Instead, we have this vague and pointless division into “preparing data for exploration”, “cleaning data” etc. that is generally superficial and repetitive.

por Robert W F

19 de may. de 2021

Courses 1-4 all had great flow. Each course left me with the feeling of building towards the next step in the data analysis process. This course fell short of that. Compared to the preceding courses, this course came across as disorganized and most of the lessons simply reviewed skills presented in previous courses. For the course focused on the analyze step of a data analytics certificate, I expected much more than a scattered review of previous concepts.

por Apurv G

5 de abr. de 2021

Some part of the course goes into very basic and some part of the course goes to advance part very fast.

Entire course Audio is too low.

The course contains very basics of Data analysis.

por Renee E

19 de mar. de 2021

Could use some work - possibly spending more time breaking down the SQL sections and rearranging the order of some of the videos/readings.

por Xinyu Z ( - A

25 de mar. de 2021

There are lack of practices on session of subqueries.

por Sonu K

13 de may. de 2021

Pace is too high, sometimes you need to use external resources to supplement the course material.

por Samantha B

31 de mar. de 2021

There needs to be a QA review of the quizzes for Course 5. Some of the quizzes mark correct answers as wrong. I have literally plugged a formula into a spreadsheet (ie, vlookup section) or tested a SQL query with my own data set and I was able to get the correct answer, but it was marked as wrong on the quiz. Other quiz questions just didn't make much sense, like a question where a group by clause was supposed to be used but the group by field wasn't included in the select statement. The errors/inconsistencies are frustrating. I didn't have these problems with courses 1 - 4.

por Dona T

21 de jul. de 2021

This course failed in terms of explaining the more complex SQL queries. The instructor did not explain the logic behind some of her queries, made too many mistakes, and the hands-on assignments were all about copying and pasting. Also, the reflect questions were too repetitive and meaningless.

por Elissa H

2 de may. de 2021

Questions aren't being answered. We aren't able to get direct answers on specifics. It feels like no one is manning the course.

por Nauan S

6 de abr. de 2021

Need more SQL exercises

por Ruy N P

27 de abr. de 2021

This is probably the least interesting course in the series so far. It only revolves around more processes to manipulate and clean data without giving insights in actual analysis. I think it wouldbe great if it included some tools for searching for correlations, the differetn types of relationships among variables (linear, logarithmic, exponential, etc.), discussing about correlation and/or causation, etc., two variables relationships and multiple variables relationships, and so on.

por Fred D

28 de abr. de 2021

Covers a lot of material that was already covered in other courses. ideally would focus more on the advanced uses of SQL - which it does to an extent - only more

por Scott H

4 de may. de 2021

Information seemed to be hodgepodge at times. Oddly put together and had the feeling of being crammed.

por Mohit S

18 de dic. de 2021

This course is honestly very weak. It's very inconsistent. The volumes of the videos keep changing between high and low.

The instructor jumps from nested SQL queries to very basic function of SUM in spreadsheet in the next video.

Also, I don't understand why the course keeps jumping between spreadsheet and SQL. It would've been much better to cover one first completely before moving on to the next one. Changing the software continuously kills the momentum completely.

por Prinn S

25 de abr. de 2021

My hands are not dirty in SQL

por L T

1 de abr. de 2021

Good information, well delivered. The only thing I don't like are the QwikLabs. They're awkward to get into, and then a lot of the instructions involve cutting and pasting SQL queries rather than learning to type and format them yourself. I try to understand what I've pasted, but in the more complex ones I still have trouble. The course (and earlier ones) should take more time on simpler queries typed in manually before moving on to cutting and pasting for complex queries.

por titas b

6 de may. de 2021

SQL part was lacking. To use the analogy of chess, you can know how the pieces move, but that's not what learning chess is about, the amount of possibilities to achieve the goal is endless and not all are equally effective. I was hoping this course would teach more about how to use SQL smartly and effectively to solve complex problems. Instead, all I got is SQL syntax with fairly simple examples of applying it.

por David B

18 de may. de 2021

The concepts covered in this course were presented well. It does seem that a lot of this course felt more like part 2 of the "Process" step instead of the "Analyze" step. This course helped with learning many new SQL an Spreadsheet functions, however I feel if perhaps some introductory Statistics were included, it would help with the goal of the "Analyze" phase, which is to find trends and relationships in the data.