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
922 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:

226 - 250 of 370 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Tummala S R

Feb 3, 2022

The data set used in course is incoherent. There was issues deciphering the tables, column names, field names etc. Instructions were ambiguous at times making it even more cumbersome to deal with the exercises given as part of the course. Answers to the questions given as part of the final project need a review.

By Misato Y

Feb 27, 2021

The course structure is well designed to achieve the course objectives. I appreciate that the course addresses the real-world example and we can do practical exercises. However, exercise questions are not enough or well worded to understand what the instructor intends to ask. It could be a negative point.

By José P

Dec 22, 2020

It's a little bit disappointing that even when classes are recorded, Kat's mistakes haven't been edited and in a couple of times, in the middle of her struggling with some issue with Mode, the record were suddenly interrupted and next the issue was 'magically' fixed (would've been helpful to know how!).

By Kenneth W

Jan 12, 2023

Instructions need updating from initial launch. Instructions on how to create final report were missing. More instructions on developing codes would have been helpful. There was very little support and responses to questions posted on forum. More mentors would be helpful to assist with questions.

By Daria I

Feb 7, 2022

This course is nice, but there are many points that make tasks extremely frustrating: vague legend about an on-line shop, unclear tasks in the testing part, uncomfortable Mode Workspaces, which are obligatory to use, and no ER schemes (at the start you will have to guess which tables are connected).

By Denis S

May 31, 2020

The actual coding practice is a bit unstructured and not well explained. All the coding exercises could be easily skipped without even trying in the first place which is bad. This would be a great course if the coding practice were more strict with a definite code for a solution

By Sébastien C

Jul 6, 2020

This is a 3 star course as the concepts presented and the depth of the material covered was interesting. However, I am not sure that the way it was presented was optimal. More small and very focused exercises would have helped instead of large, sometimes hard to grasp exercices.

By Ignacio I

Mar 15, 2020

Some of the excercises are challenging but most of the times the instructions are not 100% clear. Also, despite statistics are not the core topic of the course, further explainations on ABTesting would be useful in order to make the process of answering meaningful.

By Stefan

Jul 31, 2023

Overall I've learned quite a bunch of SQL skills. I liked the applied character of this course. However, it was often not clear what to do. The teacher could have been more clear and precise. The first course of this specialization was way better.

By Hamid A

May 28, 2020

It is an important course. However, the material of the course is not well explained. I struggled to understand what the instructor talked about. She speaks so fast and teaches inconsistently. It was boring and did not add much to me.

By S H

Apr 30, 2021

This was a very useful course. However, most of the videos lacked a context setting which made it a bit hard to follow. The slides could have been better too. But otherwise, the exercises were very helpful.

By Mohd S

Feb 15, 2022

Suggestions for the Instructor - make a separate video on how to use Mode analytics it will help the learners that includes how to build a report, you can remove the lock features on solutions video

By Jill z

Sep 9, 2021

I don't think it's a good course.

To be honest, the content is very good. However the relation of different datasets is very very very ambiguous , it's difficult to finish the case study.

By Alexandre B

Jan 2, 2023

The class is hard to follow and the exercises are not well. But, we learn a lot during this class. I just think we could understand better if the exercices were better.

By PT R

Jun 23, 2020

The practice examples are not written well- it is hard to understand what is actually being asked. This was also true for the final peer-reviewed example.

By Ben

Aug 23, 2020

The content is good, i appreciate that linking SQL with some data science subject such as AB test. that's the main reason for me taking this course.

By eyogiddy

Dec 9, 2022

The course was average. The course was mostly theory with little practical application. The course did not have enough examples

By Tadas

Oct 21, 2022

A subject is very interesting and usfull, however sometimes it lacks more clear explanation and assigments are a bit confusing

By QianHe

Jun 12, 2020

It seemed a bit disjointed. The instructor seemed nervous. Some of the solutions to the exercises seemed overly complicated.

By Raza A

Dec 25, 2022

It's a good course, in that you will learn a lot. However, it's a rather steep learning curve from Course 1 to Course 2.

By Xuan T D

Apr 12, 2023

the exercises are closed to the real world problem. But I need to have a more constructive and well-instructed course.

By Josue J R B

Sep 16, 2022

muy buen curso para desafiarnos en lo aprendido, sin embargo las preguntas realizadas son ambiguas en cieertos casos

By Ifunanya J

Dec 6, 2022

The tutor does not know how to impact knowledge. It was like she was talking to herself.

By Emily M

Jan 16, 2023

A lot of the assignment information is unclear. The final assignment being one of them.

By Cjoy L

Apr 12, 2020

Very difficult, better if there are more practice exercises and examples illustration