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:

201 - 225 of 390 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Rangga S P

Jun 27, 2020

the solution is not accurate enough with the real answer, it may cause some confusions

By Luis A E E M

Nov 9, 2021

es un buen curso pero hubiera sido perfecto si estaría disponible en idioma español

By Snorri B A

Jun 12, 2021

The course was very informative and useful. I learned a lot taking it.

By Aditya U

Jul 11, 2020

Was a tough one, but eventually made through after several attempts

By Chang

Mar 4, 2021

the discussion board and peer review system seem unstable.

By Leonardo S

Jan 6, 2022

Interesting Course but a step below the previous one.

By Swapnil K

Aug 10, 2020

It was good experience working with SQL

By Philip L

Jul 8, 2020

Nice course, I learned a lot.

By Đàng n C

May 8, 2021

Thank you very much

By Rommy O R G

Jun 5, 2020

Good training.

By Varsha D

Nov 30, 2022

Good

By Ainun E M

Jul 9, 2022

good

By Ronobir D

Jun 5, 2024

You know this class would be SIGNIFICANTLY better if the actually set proper prerequisites and taught the material correctly in the past class. Okay so the assignments themselves, why are they screen caps? What not share a Mode environment, a notebook or hell just include it as text? I mean come on the design of the assignments is terrible. A lot of the material that is not video based is terrible. The directions are poorly explained and poorly written. I would recommend that anyone taking this learns what CTEs and Window Functions are before attempting this. Go through Mode's Tutorial, go through Data Lemur's tutorial and once you've understood that then come back. Go through all of PGExercises too I'd say. Maybe go through some material on AB Testing. That said, even with all these problems that make the course worse than it could be, it has valuable information. If presented differently, it is actually a really useful course that will help you as an analyst. A lot of the questions asked in this course or activities done in this course are in fact the exact activities you do as a junior analyst, speaking from experience. For that reason it is a really great course, it just needs to get out of its own way. And present the material better. I don't think UCDavis is redoing this course but if they do just make basic statistics and a higher level of SQL a prerequisite to this course, maybe consider teaching it themselves as part of the course. Because the information inside is actually really valuable but the way it's conducted as a course is objectively so terrible.

By Olga D

Apr 14, 2021

Unfortunately, overall I was not satisfied with the course.

Positive points: the course provides a training platform that enables the students to program. Not just theory! The suggested problems are business-related and seem like real-world problems. However

Negative points: the questions to the tasks are really not explained. There is some documentation to each, however, it is still unclear, unstructured, and often starting code contains the mistakes. The comments of the lecturer to every situation are very fuzzy and very hard to follow. Additionally, the follow-on part with the solution explanation seems completely unprepared, and improvised.

The final module intrigues with a very business-demanding task as A/B Testing, but the theory to it is poorly explained. So here I recommend reading some text book.

There was no guidance whatsoever on how to use the coding-submission platform, so be careful, as it is not straightforward how not to lose a part of the result during the final submission.

Overall, I give 3 points as this is the only course on Coursera with A/B testing tasks with SQL, so with a lot of patience and side learning one could try to solve suggested tasks and get some experience about complicated SQL code.

By Maryna

Mar 8, 2021

The Tasks and info are very interesting and what you really will need in your daily routine at work.

But, this course is a huge step from the first one, so huge, that there is, for sure, need to be another in between. It's definitely not for beginners. So much time was spend trying to understand the tasks and how to make them right. 'Cause, it's really poorly written.

And another huge minus for the Final assignment. You need to write it somewhere, that cloning Task, people need to choose Community mode, otherwise, other people can't see their report. I've spent a lot of time trying to resolve it. Interesting, that, when I tried to switch my report, it said that I need to upgrade, so I didn't have that option. Needed to make it again, from the beginning, in community mode. Plus, when I was reviewing, there were a bunch of people with the same problem (when others can't see their reports) and they haven't even understand, that there is a problem. They were just waiting.

By Thomas M M

Mar 30, 2023

Overall, this course provided the relevant topics for wrangling, analysis, and AB testing. Although the topics were taught, there are certain concerns that I want to raise:

* Difficulty gap between this and the previous course. The lessons were just decent enough to be understood but did not translate well in applying them to the assignments.

* Instructions provided in the assignments were too vague and does not provide references on what it is talking about. Instead of giving 'hints', it would be much more helpful to provide guiding phrases (e.g. 'refer to the assignment/lesson in 1.x'). Learners are here to actually learn, not to do a 'scavenger hunt'.

* The lectures during coding is of low quality. If the coding discussion was done in the similar way as topic discussion, it would have been better. Felt annoyed when the instructor ends up mumbling at times (noticeable on the caption when it specifies [mumbling]).

But despite these setbacks, I was able to learn.

By João S

Feb 15, 2023

This module is not easy. It lacks some better edition on videos, to remove errors when the instructor is teaching, and also give a better explanation of the queries. The questions are sometimes vague and difficult to understand what to do, and the tests have tasks with functions and statements that you see for the first time in the solution videos. At the end I struggled a lot on how to build a notebook and also a proper graph in Mode. There's no guide or explanation at all during the course about it. By the other hand, although it's a tough path, I learnt a lot about joins, aggregate functions, subqueries, AB test and I am very confident now when manipulating tables and reading codes. My suggestion to those taking this course is to copy the queries and reproduce them on mode with exhaustion, untill you understand what is going on.

By Antonina S

May 19, 2020

The idea is good - applying SQL knowledge on practice and learning some new features by doing. Although, the realisation is quite poor. I got this impression mostly due to the quality of the tasks formulation - looked raw, so it was sometimes not clear at all what to do. Quality of tests is also not at the best. A little revision would help a lot.

The instructor is nice and cheerful, has a pleasant voice.

Don't expect to learn much not by doing - very few explanations on the subject, mostly the course is about solving those ambiguous tasks (you get a pdf with tasks, then a solution video). There are concept videos aimed to help you a bit with the upcoming tasks but the key word here is 'a bit', so you should have already known the topic or google it.

By Noah M

May 10, 2020

I struggled through some of the exercises as they weren't well written, but in any case it's up the learner to get what he wants out of it in terms of learning goals. I also found it slightly annoying that Starter Code, often a page long was a picture snapshot on a PDF that the learner couldn't copy / paste. But that's part of the struggle I suppose, forced me to read through all the code and I got something out of even that.

I got a lot more confident creating tables for my specific purpose, through joins and feature engineering, the open-ended nature of the questions meant they were a useful step up from Course 1 of the Specialization.

Thanks for the course, good in conception, but execution needs to be tidied up a little.

By Itamara C

Apr 10, 2021

The instructor Katrina Glaeser is really, really good.

I wish I had some of her skills: smart, fast-thinking...

But, unfortunately, in order to make things easy (too easy), it was left outside important emphasis in the key points, or they weren't was explore the way that, I believe is suppose to be. So, for me, the course did not fulfill the purpose. I finished the course with a feeling that I could reproduce and understand what Katrina was planning. but, I could not explain what I was doing myself. I have not to doubt that she is brilliant as a Data analyst, but as an instructor did not work for me. I am still searching on Youtube how to do, understand, and how to analyze AB testing...

Best regards!

By Davide C

Dec 12, 2020

The course is really good to improve your SQL skills. I think the instructor is great and the course covers a lot of practical problems with plenty of possibilities to exercise.

Yet, the course lacks a well-defined structure. However, the main problem is that the training assignments along the course need to be improved a lot. The questions are not well explained and the exercises sheets are really poor, you have the impression that you are pushed to skip directly to the solution video. Also, the instructions for the final assignment are too vague. It's a pity because otherwise would be a really good course.

By Eddie J

Jun 23, 2023

The course knowledge is very practical and useful, but the course material is not well constructed. The instructer always don't give you enough instructions before the assignments, so you will need to try several times.

In addition, the questions of the assignments are quite difficult to understand. The instructer usually include some additional assumptions or conditions apart from the original questions in the solution videos. So, it will be pretty hard for you to do it all by yourself without her examples.

Finally, some videos or assignments are missing in the course material.

By Chris M

Sep 6, 2021

The material itself is interesting and helpful, but it is not always presented in the best way. I frequently had to start the solutions videos just to see what was being tasked, and more than once the solutions weren't possible even if you copied her exact code. She is clearly good at her actual job, but sometimes being good at something makes it hard to teach, because you take knowledge as a given. Several times we were taught things as if they were a continuation of stuff we should already know, and if you're only experience was the previous sections lesson you were lost.

By Mario P

Aug 19, 2021

The course itself presented great material but the manner in which it was taught was incredible difficult to follow along. The concept of attempting SQL practice exercises prior to learning the techniques was challenging. When compared to the first course, this second course was clunking and unstructured. Additionally, there should be better instructions on how to publicly share your mode report. There was a large number of individuals who did not share their report correctly and it delayed their final grade processing. This course needs updating.

By Katrina-Kay A

Feb 15, 2021

Let me start with the positive: my SQL skills definitely improved as a result of this course. It offered good practice for queries that are more complex than those in Course 1 in this specialisation. Having said this, this course really needs a facelift/revisit by the instructor. There are so many questions and assignments that are worded badly and have unclear instructions. I became quite frustrated about this around the halfway mark. As a general FYI: this course uses PostgreSQL and a service called Mode to compile code.