Chevron Left
Back to Data Wrangling, Analysis and AB Testing with SQL

Learner Reviews & Feedback for Data Wrangling, Analysis and AB Testing with SQL by University of California, Davis

3.3
stars
961 ratings

About the Course

This course allows you to apply the SQL skills taught in “SQL for Data Science” to four increasingly complex and authentic data science inquiry case studies. We'll learn how to convert timestamps of all types to common formats and perform date/time calculations. We'll select and perform the optimal JOIN for a data science inquiry and clean data within an analysis dataset by deduping, running quality checks, backfilling, and handling nulls. We'll learn how to segment and analyze data per segment using windowing functions and use case statements to execute conditional logic to address a data science inquiry. We'll also describe how to convert a query into a scheduled job and how to insert data into a date partition. Finally, given a predictive analysis need, we'll engineer a feature from raw data using the tools and skills we've built over the course. The real-world application of these skills will give you the framework for performing the analysis of an AB test....

Top reviews

MF

Sep 22, 2020

A good course for learning and apply sql to conduct analysis on ab testing results. Would be better if the instructor could provide more info about how to design and apply AB Testing on the customers

SP

Jul 29, 2019

The instructor is very smart and her syllabus is very easy to follow. The real life examples are great and helps put ideas in perspective! I would definitely recommend this course and already have!

Filter by:

326 - 350 of 390 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Farouk E

Oct 14, 2023

Need a lot of work when it comes to tasks, such as wording, information given

By Ümüd O

May 14, 2020

Poorly designed course. Not enough explanation to solve the exercises.

By Mercy C

Feb 6, 2023

This course is poorly prepared and delivered. Hence, I am quitting.

By Alireza M

Jan 11, 2023

The worst Coursera instructor. Disorganized.

By Yifeng W

Sep 1, 2021

This course is almost a waste of your time.

By Chin M W

Mar 2, 2023

The contents are poorly organized

By Sky W

Aug 25, 2022

Not structured appropriately

By Mei H

May 11, 2020

It is really hard to follow.

By Amir E

Jul 25, 2024

This course was ambiguous.

By Ольга Ш

Mar 18, 2024

I can't get my certificate

By Cầu T

Jan 12, 2024

Too hard for the beginner

By Ahmed A

Sep 9, 2022

Very difficult

By marco a p

Feb 25, 2023

very confusing

By Якухин В С

Dec 18, 2020

Did not like

By Miguel d S B

Oct 8, 2024

no comment

By Marharyta K

Sep 27, 2024

I usually don't write reviews, especially negative ones, but I feel like I should share my experience with this course. I regret not reading reviews before enrolling because it was a terrible experience. Firstly, the difficulty level of this course is significantly higher than the previous one in this specialization, making it impossible to take them sequentially as intended. Secondly, the course is poorly structured, making it difficult to follow the topics. While the lecturer seems knowledgeable, she struggles to effectively explain the material. The practice exercises were the worst part. The absence of an Entity-Relationship Diagram (ERD) made it hard to understand the dataset's table structure. Additionally, the tasks were unclear and sometimes incomplete, such as "Write a query to format the view_item event into a table with the appropriate columns" or "Use the result from the previous exercise, but make sure." Furthermore, it seemed like the dataset had been updated, leading to discrepancies between the practice exercises and the solution videos. The solution videos were also problematic. The lecturer appeared unfamiliar with the tasks, providing poor explanations and wasting time trying to find mistakes in her code. I'm disappointed and won't recommend this course unless it undergoes significant improvements.

By Nicolis A

Dec 30, 2022

This course is the definition of nonsense . The bones are great interesting topic and knowledgeable instructor. But that is where the positives end. In week one you from 0 to 100 mph. Then in subsequent weeks you get philosophical ideas with expectations of you knowing how to apply them with no how. for instance you learn doing idea A is important, get asked to apply A. Then solution video of look at me applying A in a very specific method that was never shown. Then in week 4 you get final assignment which again you are unprepared for and given vague instructions. People fail you for little reason despite knowing the challenge and futility of this course. Only those who truly see this course for what it was will pass you. best of luck and please pass people on the final assignment.

By Brenda B

Sep 20, 2023

This course started out okay with the instructor going through everything but as soon as the first assignment started the course showed the cracks. Most of the assignments are not clear on where to start for the practice sheet as it is not linked in the assignment PDF you have to try to search to find it in the discussion forum written by the instructor. That practice sheet for said assignment IF you find it often will give you an error and not allow you to access it on mode. Example "page not found or moved" error. None of the staff responds to you and almost all of the learners are asking for the same help and questions related to finding the practices we are supposed to do. Unfortunately this course is required for the specialization so you must complete it.

By Jason G

Sep 27, 2023

I had to abandon this course and the entire SQL specialization with it. This style of instruction is terrible. Too much time is devoted to learning spoken details of the instructional dataset, and one's ability to pass assignments depend on your ability to memorize those details from the video. They could have just provided an ER diagram and shared key details in writing with the assignment itself. Every other course I've seen focuses the video instruction on generalizable lessons and concepts, but I did not feel like I was learning any. With little meaningful content, I tried to limp through the assignments hoping the next course in the specialization would be better, but I won't ever get there because now I'm stumped by the final assignment. It's over.

By Sofia G

Feb 9, 2023

The solutions of the exercises are very slow paced and not easy to read. There is no real chance to practice a lot of SQL during the course and know if what you have done is correct. Some questions of the quizzes are very ambiguous and specific, designed to trick you beyond a good amount. The peer review project was a pain to do, since the instructions are not clear. I had to resubmit it 3 times due to the link not working. I could have saved days of work and waiting if the ways of using Mode were stated clearly and explained. Mode is also not very intuitive to work with and not ideal for this class. Hard to follow overall with videos which were really slow and boring but omitted important information at the same time.

By Alex A

Aug 10, 2022

I think the instructor is trying to start from a point that is well more advanced than just finishing the first prong of the specialization, so there's a gap in the sequence.

For this course, you are prompted to create an account on mode.com where there's a virtual machine that runs postgresql. When doing the exercises, I found cases where I would get a different result than the solution video, even when I had literally typed the same query as the instructor. There was even a case that referred to a table that didn't exist, so it is very frustrating.

I feel the material is scrambled and the concepts are not presented as you would in a course. This looks more like a walkthrough,

By Thibaut C

Jun 16, 2020

This is a very practical course, with barely no theoretical aspect. You will get more experience of SQL with this course, that is for sure. The videos have very little actual content, they are more an introduction for the practical part that follows.

However, the instructor builds a sequence of strangely named metrics, and supposes you master it in a second. This is especially unhelpful for the project, where the questions are poorly presented and keep on using this vocabulary.

You will have to use another platform to test your code, which is not a bad thing per se. The problem is that this platform is far from intuitive…

This course seems to lack proper planning.

By Anirudh

Jun 18, 2020

This course was not planned out well. I would be hard-pressed to believe that the people who created this specialization had any pedagogical training whatsoever.

Many of the exercises are only partially written and are littered with inconsistencies, typos, and poor instructions. I would suggest to the course creators that they should hire an editor, or at least someone to look over these courses prior to hitting publish.

I honestly would not recommend this specialization to anyone at any stage of learning SQL.

I did like that this course chose to use Mode to run the SQL queries. They seem to have many example datasets already loaded.

By Muhammad B J

Jul 31, 2023

I found this course really difficult to follow. The directions for the quizzes were confusing, and some of the datasets and examples were outdated. The final assignment workbook function was a hassle; I had to submit it TWICE because the first workbook couldn't be shared, so most people in the course ended up using Google Docs, GitHub, or plain text instead. This course might be more suitable for advanced learners rather than those like me who are just starting. It just doesn't seem to match the title claims to be. I apologize for the low rating and please fix the course ASAP.

By Bruce B

Sep 5, 2022

Very sad to be writing this review as I was looking forward to this course after completing the first offering in this specialization. This course isn't for me. I completely understand that datasets may change over time, but someone must update course content so that the examples on screen match what students are doing at home. I really liked Kat because she is obviously wicked-smart and presents well. But I have a hard time paying for training that seems to be somewhat haphazard in organization. Just my 0.02. I'm out. Good luck to all...

~BEB~