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:

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

By Sunny Y Y S

Mar 30, 2020

The teaching value provided is great, and uses real life cases that I can relate to. 5/5 For that. However, it became a 3/5 stars due to the assignments not being as interactive that gives us an opportunity to write the code and have feedback from. Secondly, personal opinion, I definitely did not like there were a lot of limitations and constraints along the way to prevent myself to look in advance of the workload. Changing this would be beneficial to know what are the things to look out for during the videos.

By Brady S

Feb 5, 2021

It seems there was HUGE gap between this course and the previous one in the specialization. A lot of unaccounted for material and the difficulty jump is quite large. The structure of this course is subpar as there is no real learning; it's more or less giving you an exercise and then a VERY surface level explanation in a solutions video. However, the content is good. There is a LOT of material and it's all very useful - the exercises are almost all applicable to real world problems

By Dalton E

Dec 5, 2022

This was a huge jump from the first course, I was lost for the majority of this section. I also don't like the way the lessons are taught. You just watch the instructor play around with the coding until she gets it and then you move on. You're asked to try to do it first before even knowing what exactly to do. And even when she explains it, you're still a bit confused. I did like how even she messes up and made it known that it's normal to mess up on small things.

By Bjoern F

Apr 26, 2024

The topic of this course is relevant if you want to dive into SQL and data science. But the course itself is problematic. Most tasks do not explain what is expected from you. I learned most through the solution videos, everything else was often simply guesswork. That is not how learning should occur! Also the rating criteria for the final assignment do not really align with the tasks. I would recommend Coursera to re-work this course substantially.

By Leong J J B

Jun 17, 2020

Topics and skills taught were relevant and good. However, more materials could have been given before letting us practise the practise questions ourselves. A lot of the questions needed knowledge of functions or ways of implementing SQL code that we did not learn before and it would have been helpful if this was taught to us first, rather having us learn from the solution videos.

By Oscar A

Feb 8, 2021

La profesora es agradable. Las primeros módulos son la continuación del anterior curso, se aprenden algunos comandos más. Algunos ejercicios requieren comandos que no se han visto pero en los videos de solución los muestran. Recomiendo leer bien la página de ABBA (ellos te dan el link) para entender mejor en qué consiste el AB testing. Me gustó la plataforma de Mode Analytics.

By jose c

May 24, 2020

The content of the course is very interesting, however it seems to me that it is not well structured, during the practices the objective in general is not understood, I think that the course should improve those details that not only consist of writing queries without knowing the meaning of each one of the variables that are being consulted in the different tables

By Wanda H

Feb 24, 2022

I thought this class was a continuation of the first course, but realized there was really no continuity between the two. The instructor should have explained more in depth especially when using shortcuts in Mode Analytics. I did not always understood what was happening and needed extra help. This course could be fined tuned a bit more.

By Laura M D V

Aug 9, 2020

First week was hard to follow. I felt very discourage to continue that it took me almost a week to return and do the rest of the course. It got better the next weeks. However, I think that strategies and pedagogical teaching can be improved. What I really like is when Katrina coded on lectures, it was cool to see her thinking process.

By Carolyn O

Dec 28, 2020

The instructions were frequently not clear. I often took her literally, which was not correct. Sometimes she didn't specifically state something she expected us to do. Other times, she stated it differently than what she really meant. It was a struggle. But I'm glad I gained more knowledge and practice writing queries.

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 Sahil

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.