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:

176 - 200 of 390 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Luis I L M

May 2, 2024

ok

By Nicoll Y S A

Apr 22, 2024

.

By Brian Z

Dec 20, 2022

Tough call on where to rate this: 5 stars for planning and ambition, choice of use case and data; 4 stars for quality of instruction and videos, 2-3 stars for clarity of assignment questions and checking to make sure things are up to date.

I think most people will come out of this course with a deeper understanding of how databases for online stores actually work (not some "toy version" but closer to the real thing) but it can be a frustrating journey as you will have to hack around in Mode to try different things plus use other resources to figure out what's going on. That's a bit more like being a working professional, but maybe you don't want that lesson to be wrapped up with your efforts to acquire some SQL skills and tricks of the trade.

By Kartik D

Oct 15, 2021

The course is good. You will get to learn a lot from this course, as compared to previous Course(which is just the basic). The exercises are somewhat hard. Half of the time, it is due to ambiguity of the questions itself. You will feel frustrated on not knowing what to do. So, if this ambiguity is removed, the quality of the course can be improved. Further, the instructor should provide more videos/content on teaching SQL concepts which are neither taught in this course nor in the previous one but are used in the course.

By Philippe T

Jun 17, 2021

The course was good and the curriculum was well constructed. My only issues are with the clarity of some of the questions, which I sometimes felt was lacking. A diagram showing the schema of the database used in the course would make things a lot clearer. Also, the peer-grading process is a bit of a mess. Instructions on how to make the final submissions accessible to peers should be made clear. I only got it right because it is a common question in the discussion forum.

By Christos V

Dec 16, 2019

I recommend the course in general. It has a combination of theoretical principles and hands on exercises in order to familiarize with the concepts behind the course.

On the other hand, I believe that instructions in order to perform and complete the exercises were not always clear which resulted in losing lots of time in order to try to decode what the actual expectations were.

But once again, a good course, giving insight in data wrangling and AB testing.

By Gisella B

Apr 17, 2020

I had read comments about the instructors reviews that were distracting. But I actually liked a lot to see the construction of real queries in real team. However they were getting increaslingly complex and it was hard for me to keep up. You need a lot of practice on SQL before or during this course. Also, some of the instructions of the assignments were not clear at all. You can learn a lot with this course, but it will not be easy.

By Lesego S

Aug 27, 2021

The practical aspect of this course is amazzzzzzing. I think the course is structured in a 'do-it-yourself' kind of style. The instructor does not spoon-feed, but as a student, you have to research the details of 80% of the material covered. It taught me how to understand data before working it, planning solutions before coding, thinking about what I am actually doing before doing it. The course is real.

By Hema M

May 20, 2024

It was good. I gave rating - 4 because I felt the explanation is not quit adequate especially for the beginners (like me) - So, I needed to get those insights from other resources & watch those videos again & again - only then I was able to get the clear insight of AB testing (in particular). Other than that, this course is amazing!

By Desiray Y

Sep 8, 2022

Provided a great deal of trouble-shooting and hindsight but a lot of times I was scrambling to figure out what the instructor wanted, or how she did something as the directions were vague (I felt like I should have been a mindreader in this class). This class is not suited for users with no SQL knowledge.

By Gerhard T

Jan 16, 2023

A real good and challanging course.

Drawback is that the free usage of Mode analytics - which is essential for the final assignment - does not

come with external/global sharing. So not all workbook could be seen. As these workbooks could not be graded,

to proceed in the peer review, 0 pts have to be given.

By Brian S

Dec 8, 2021

The instructor was great, the course was amazing. It is a difficult course where you learn how to think about data and not just learn SQL syntax.

My only complaint is the lack of help in the discussion forum, the instructor does not seem to be active at all in answering quesions.

By Tihomir V

Apr 5, 2024

The course provides very good knowledge and I think it's worth it. The only problem I had with it was that some of the assignments and the solutions were not very well explained and it at times was really hard for me to know what exactly I had to do.

By asparuh s

Jun 8, 2020

The course is very interesting and with a lot of examples and hands-on exercises. The lector is clear and makes very good presentations. However I found it difficult that the tasks and exercises are not very clear and definitions are sometimes vague.

By Okeefe N

Sep 22, 2021

Overall a really great course to get the analytical side of the brain going! Some of the weeks were a little too open-ended, though the activities were engaging and the solutions to the activities go above and beyond the basic solutions.

By Melih A

Aug 29, 2020

It was a great course. It was challenging but I learned a lot. I would recommend anyone who wants to learn advanced level SQL. But I would recommend the teacher to add some clearer explanations for the assignments.

By He H

May 2, 2020

The course was fine to refresh my SQL knowledge. The business cases are oriented on web analisis, which is new for me and I learned a lot of vocabulary and methos. Nothing super hard or challenging though.

By Paul M

Mar 1, 2020

In the peer-review part of the final project, the lack of answers and the lack of any updates to this issue from the staff knocked this course down from what could have been a very good course experience.

By Destinei S

Feb 7, 2022

I was able to get most of the concepts and the practice. The discussion forums weren't as helpful. Having students answer a box to continue to move on, doesn't help and makes it harder to find support.

By Abdullah S

Aug 20, 2023

I recommend this course for those who are interested to gain the right skills to play as your thoughts tell with the data, it needs to be focused a bit but it is a good start.

By Matthew P

Nov 21, 2021

The course lectures and reading materials were excellent; some of the assignments were a bit unclear in terms of the directions. Overall I'd recommend the course.

By Eddie A R R

Feb 6, 2023

There are some things than I'm not able to understand completly and some errors in the presentation of some videos. But the course it self fulfills its purpose.

By Deleted A

Oct 11, 2021

The difference between the theoretical parts of the class and the exercises is insane!

But the things you learn are nice so worth it

By Frank I

Jul 11, 2024

I preferred not to have the student-graded tests and wish the four courses followed the data used in course 1 of the specialty.

By louis j

May 12, 2022

This challenging course demonstrates the power of integrating SQL, creative thinking and analytics.