m

l

,

T

.

1

.

c

The instructor went way too fast over the SQL commands. I mean, it was ridiculous. I do IT for a living, so I was able to keep up after stopping, going back, reviewing multiple times, and then proceeding. My two friends are totally lost . One wants to leave the medical field, and the other is trying to leave retail, so this training is important to them and their futurte. But, I am having to tutor them. One has lost confidence is close to dropping out. The other is not sure. This is due in part to the instructor in my opinion. Knowing subject material doesn't mean that you can teach it to others. I have taught computer-related classes at a university for 22 years, so I believe that I have a little more insight than the average student. If you take these reviews seriously, then take my advice, review your training methods. Answer this question: do we want students with little technical background to succeed? I think you do. Make it happen. It's that easy. Teach the material, but slow it down with the advanced material and don't fly through it. For me this has beena great 5 classes, but for my friends, they are on the verge of dropping out, and I just hate to see their future dreams crumble.

This course was on the longer side but it was packed with a ton of info, so possibly the most valuable course so far in the class.

Some pros and cons:

Pros

Tons of information - SQL, spreadsheets, functions, etc. And plenty of time explaining them to the point I was surprised when we rehashed a few topics a bit, but that is better if you didn't get it the first time.

Plenty of great outside links to continue/expand education beyond the class. Love this.

Hands on experience in BigQuery - anything hands on is invaluable when learning and I was happy to see this was implemented

Cons

My only gripe - and I will say I know this is a Google class, so I get it - is the overuse of Google Sheets. There are some workflows that don't translate well over to Excel, specifically in making pivot tables and assigning values in them. This part was very frustrating because I had to have a friend explain to me how to do something in Excel when you were teaching Google sheets and had little to no Excel documentation. Again, I get that this is a google class, but Excel is industry standard and I feel like if I walked into any other business and said I use google sheets for professional work, they would laugh at me.

i will be honest, this course definitely made me feel really disappointed. now i cant judge the whole thing yet since i only just completed week 1, but the quality difference is plain to see. This week 1 feels like it was made without considering what was taught in previous courses- why would you dedicate a whole week into sorting and filtering..?

Hopefully i can just storm through this course then go to udemy to learn whatever sql syntax they will teach here+ other stuff

Edit: Finished this course, gotta say that while it isnt the best within this google analytics course, it still feels pretty comprehensive and i feel like i learnt alot. granted, stuff like subqueries were just skimmed through and i definitely need to practice more after this, but it is clear the instructor knew her stuff and tried to make her teaching good (i love the intermediate sql pdf that summaries functions taught, although theres none on subqueries)

i think i was too harsh on the rating since you know, this is a google course. but overall i think its still a fantastic course and we just need to remind ourselves this isn't the holy grail to data analytics; we still need to learn more outside this

The course materials are great, but the instructor is disappointing. She's too fast in demonstrating and the screen is too small and at times not in focus. I learned most of the materials from the Hands-on activities.  The video using JOIN, alias and CASE together is a disastrous one, especially since we have not previously introduced CASE. She also didn't consistently type "AS", so it makes it a lot more difficult to follow, especially for first-time learners.

Most importantly, she typed the wrong data set name for the new_york_bikeshare data set in Bigquery. Instead of typing new_york_citibike_citibike_trip,  she typed new_york.citibike_trip in the query in both the week 2 CONCAT in a SQL query and the week 4 Temporary Table videos, even though she showed the correct data table for bike_trip earlier in the video. As a result, my results are different from hers since the new_york.citibike_trip is from the new_york data set and not from the new_york_citibike data set and are different. I hope this will be corrected.

I assume that the content is based upon knowledge of the necessary topics to fundamentally prepare for the a job as an entry-level data analyst so in that respect (only) I would give the module 5 stars. The instructor moved from introductory methods using a spreadsheet to SQL syntax to perform the same analytical methods. Again, 5 stars for content and the ability of the instructor to make the topics understandable and to demonstrate their usage.

Where I felt the instruction fumbled and detracted from its overall excellence was in areas regarding SQL syntax where either the syntax was incorrect or a corrective slide was inserted but was incorrect and times that writing bigquery queries came back with syntax error messages, or even the time that for some reason I received an error message that I my project hadn't started within bigquery and therefore I couldn't run the query. That cost not only days of frustration but impacted the overall amount of time it took me to complete the lesson and/or module.

This course was definitely challenging and I think I can provide a couple of suggestions that might help you guys improve things in the future: 1- I believe it would be great if, during the course, you guys could choose only one database and use it throughout the different topics because it is especially challenging to learn new tools and functions already to then have to process new datasets on each video. Allowing learners to adapt and understand one dataset might make learning about the following topics a lot easier because you don't have to understand a new database, just a new process, function, formula, etc while working with the same data. 2- Some topics are more complex than others, but it seems like you guys dedicate the same amount of time to developing each regardless of its complexity. This makes me feel overwhelmed because I feel like more complex topics deserve longer videos and lectures. So I would advise dedicating more time to more complex topics as they are harder to understand.

This course was certainly more nuts and bolts than the previous courses which was nice, but there was definitely a feeling that it missed some major teaching opportunities about aggregation in SQL and seemed to have a lot more small issues regarding things like pulling variables differently on screen and in the actual database from the reading, etc. Also this is the course where doing some more reading outside the course(or at least going pretty in depth into the "5 minute" supplementary materials) really pays off, to the point of being virtually required. Everything before this course you can breeze through in less than half the time recommended, this one was a little more time consuming. Overall though if you are willing to work on your own(which you probably are if you are here) and you like to explore something you see the instructor do if it isnt explained you will feel much better about your SQL knowledge after getting through this course. The tests are still very easy.

It will always be challenging to have a an online learning course that uses an ever-changing public database. I was able to follow along with the instructor through most queries, but only if I was paying attention to what had changed. The New York Citibike dataset that we worked with often during this course, for example, has changed the name of one of the tables within that dataset. I don't remember exactly what it was, but I do remember needing to make slight changes to my queries each time we used this dataset. On the final activity where we used Austin's bikeshare data, I found that the station ID to be different than what I had been told it would be. The answer for the question in the assignment hadn't changed and was correct, but this could be confusing for some. Ultimately I understand the challenges of a static course working with something as fluid as SQL, but maybe these videos can be edited more frequently to reflect those changes?

The first two weeks were good, the third week was difficult as the instructor didn't say what they were typing and going fairly quickly. I like to think I can type fairly quickly at about 80wpm, but it was a struggle to keep up. Things usually click fairly quickly for me, but again, it was going so fast that I had to rewind the videos multiple times in the same section to even understand what was happening because it was not being explained very well. (SQL classes)

Week 4 was great. The instructor was talking about what they were typing and why they were inputting the functions into SQL. Week 4 clicked.

Overall, the course is a great look into the life of SQL, I love that one of the discussion prompts were me looking for information on my own. I am excited to use this knowledge again to stay in-practice!

Analyze Data is probably THE most important module in the Google Data Analytics Professional Certificate. I found the content to be good, but the organization of this module to be rather confusing because the sub-sections switch back and forth between spreadsheets and SQL. It is a four-week course, but it felt very long, and dense with concepts, functions, and some long SQL syntax.

I feel like this course would have been better if it would break up the module into two sections: one for data analysis with spreadsheets, and one for data analysis with SQL, and keep the two methods of analysis separate for better learning and retention of the concepts. Yes, there is crossover, but when learning, you want to learn ONE thing at a time, not jump between two things quite so much.

In my opinion it is a lot of items to cover up in this course, for me as a future prospect entry level in Data Analysis there is a lot of good information but will be better to split it between course 4 and course 5. There are a lot of structures and syntax for SQL which were covered really fast for the instructor and you don't have the time to get familiar with while you in the next item are covering another one more complex, probably for someone with background in SQL is good enough but for someone like me who is looking for make a full career change and doesn't have any background on is more difficult. In the previous course the SQL items were really good covered, understandable and good paced to watch and review them. In this course all of them were fast paced covered.

This was by far the most difficult module out of the 5 courses I've completed so far....there's a lot of information and new formulas to digest. Quite challenging but totally worth it! I like that the activities set up are walk throughs/ guided formulas to help practice. However, many complex formulas are first sprang on you in a video and then explained much later, so it did feel a bit confusing at times. Would have been great if there were introductions first to these difficult formulas, then working through threm. Otherwise, I have gained so much knowledge. Totally worth it! My brain cells have definitely expanded!

The instructor is very professional and has a deep knowledge of the matter. The operations which can be done on the data are shown for spreadsheets and SQL in a coherent manner, which helps to reinforce what has been learned. It will improve the course to show some schematics of the different tables within an SQL dataset, particularly for the sections where nested queries and joins are discussed. It will help to understand better what the code lines in SQL do rather than just displaying the output of the code in BigQuery.

The preparation of the big query was kind of a headache and some tool to show which function works only on BigQuery and not on other tools would be helpful. Also, the other way around like it was said in the Temp table where SELECT INTO does not work in big query. I was using MySQL for some task and FULL JOIN does not work there so you have to do a right and left join with a very weird method which could have been mentioned in the video. Overall the instruction and activities are well done.

I enjoyed the course but not as much as previous ones. There was a bit of a disconnect between the material being taught and that being tested (taught material was signifiantly harder than the tests). Also, some of the classes could have been scaffolded better with a bit more guidance particularly around nested queries and temporary tables. I only managed to understand this part of the course because I had already completed a Udacity course on SQL. A complete beginner would've been lost.

This is the most technical part of the data analytics course certificate, for me. it was really tough and challenging for me to grasp all the technical terms and functions. The facilitator did her best to break it down. The downside I had with it is the audio volume, it was low/ poor in most of the lessons, and I had to strain to hear. she was a bit too fast while showing the practical examples on a spreadsheet or SQL. Apart from these two issues, I enjoyed her teaching. Thank you.