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:

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

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 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 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 louis j

May 12, 2022

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

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.