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:

51 - 75 of 370 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By John M

Jul 13, 2022

Useful, but certainly a drop in quality from the first course. The real-world application to preface each lesson was really good, but the quality of the instruction (more presenting information than actual instruction) and the follow up assignments weren't up to par: Frequently the lessons didn't provide enough information needed to do the assignments, and you'd only discover that when watching the follow up videos (quite frustrating). One of the solution videos in particular answered the questions out of order, which was quite confusing (how was that not caught before publishing?!). Several of the lessons felt a quite rushed - perhaps the slides could have included SQL snippets with bullet points and when to use each (like in the first course), in addition to watching the instructor construct the query. Often the assignment questions were ambigious - it wasn't clear what an end result should look like... an example of a finished query and maybe a hint or two about what would needed could have alleviated this.

Overall, I can't say that I'd recommend this course. While the subject matter is a nice progression from the first course, the lessons and assignments aren't clear enough (they seemed lazy at times) and you can probably find better courses elsewhere.

By Mariza M

Nov 8, 2021

Course is difficult to follow, a lot of the assignments/quiz questions are vague, the reference materials are no longer accessible. If you are doing this as part of Learn SQL Basics for Data Science Specialization: this course references SQL not learned in the first course. You can muddle through but it's frustrating the whole time.

By Mateusz

Apr 25, 2023

Bad course, awfoul problem set. I hope not to be bored enaough to have time for this one in future. I loved the first part but this one is trash.

By Mercedes T

Mar 21, 2022

This course uses Postgres - it is never once mentioned. It is also completely unnecessary to download any editor as all your "work" is done on Mode (external website).

There is a HUGE gap in knowledge between the first course and this second course in this series. The topics mentioned that we should know or go back to the first course were not even in the first course, and if I'm going to be constantly going to videos online on free sites, then what was the point in paying for this course? It also became painfully clear that it's expected that we have some deep understanding of the data and business, and since we (the students) did not create this data and don't have any real maps of how things are connected or what they acutally represent, it makes this course that much more aggrevating. I'm still not even sure what the "AB Testing" portion of this class was aside from the instructor talking about a few examples in her videos. Possibly there was AB testing in an assignment, but it was never once made clear that is what we were doing.

There is absolutely no actual instruction going on in this class. It's very frustrating and is structured as following:

a "lecture" (the instructor talking about something kinda of related to what you might be doing),

an assignment that is more along the lines of "figure it out,"

an "optional" discussion (that isn't actually optional as it unlocks the solution),

and a "solutions" video where the instructor walks you through her thought process of the assignment that you just had to figure out. More often than not, the assignment you do does not match up to what is in the video. Also, a lot of the data isn't the same, and it's just beyond frustrating.

By week 4, I was very much done and didn't care anymore.

I have no doubt that the instructor is very good at her profession (she mentions being a data analyst at Scribd), but she is not a teacher/instructor by any means. This whole course is more of us just following along as she does her solutions on video.

By Jing Z

Mar 18, 2023

I regret to say that this course did not meet my expectations. As a learner seeking to acquire skills in SQL for data analysis purposes, I found the course to be lacking in several aspects that I consider essential to effective learning.

Firstly, the instructor's approach to teaching was less than satisfactory. Rather than explaining concepts and demonstrating their applications, she simply showed what she did, leaving me without a clear understanding of the underlying principles. Consequently, I did not gain much from the course and was left feeling disappointed.

Secondly, the quality of the teaching videos was unsatisfactory. The instructor made numerous mistakes, and the videos were unedited, resulting in lengthy videos that took up valuable learning time. I believe that this shows a lack of professionalism on the part of the instructor.

Thirdly, the instructions for the assignments were unclear, causing confusion among students. Often, it was unclear what was expected in a question, leading to frustration and time wastage.

Fourthly, the course structure lacked organization, with no apparent connection between different chapters. This made it challenging to follow the course and understand how the topics fit together.

Finally, I was disappointed by the instructor's lack of responsiveness to student queries. After asking a question in the Q&A section, I received no response for two months, leaving me feeling unsupported in my learning journey.

While the course covers a wide range of A/B testing aspects, the instructor's inability to teach effectively undermined this advantage.

In conclusion, I would not recommend this course to fellow learners seeking to gain SQL skills for data analysis purposes. Coursera has many other courses and instructors that offer more effective teaching and learning experiences.

By Domenic P

Jun 14, 2022

the platform we are instructed to use only includes a 14 days trial so make sure you finish the course before!!! Or else you might have to pay for it to finish the course!!

Sorry to say this but this because i firmly believe the instructor is a very nice and intelligent person but the course felt like a waste of time to me. I only finished it for the specialization.

The first two to three weeks were mostly irrelevant to the final project. And the module about AB testing felt taken out of context with no proper explanation how a test is set up etc. Even I as an experienced regression analysist felt very confused by her "explanations"

I felt lost during the exercises. The gap between the first course and this course is tremendous. Also, the instructor does not explain anything, rather she expects you to know everything in before or to google your problems. She does provide a solution but its hard to follow why she is doing what she is doing and more than 50% of the videos is her checking on her own mistakes. Furthermore codes during exercises are screenshots not actual lines of code which means you have to copy every starter code by hand which takes a lot of time in the later exercises....I feel sorry to say that because she really does seem a kind and nice person and I believe she has deep knowledge about the topic but the way of "try it for yourself and then I'll show you" is not what i expect from a PAID course. What is the point of paying for a course when I have to refer to external information, get unclear instructions such as "Look at the table and tell me about it".... The first SQL course was so great that I was really looking forward to this course but it turned out to be quite disappointing... :(

By Fryderyk Ł

Nov 18, 2021

I am honestly dissapointed by the quality of this module. I simply despise the way this course is conducted, it's chaotic, not that well explained and somehow done in a manner that's not up to the standards of such courses. The videos are not prepared with enough care and respect, different excersises aren't presented in an easy and understandable way for somebody willing to get a better grasp of SQL, but without some big experience. A big letdown.

By Tiangeng L

Mar 13, 2022

The intended objective of this course is good. This course would have made more sense if (1) codes appeared in the worked samples are replicable from the mode studio, (2) less on-screen editions, (3) more elaborations on the chunk of pre-edited codes copied to the script, and (4) more connections with the previous module.

By Ankit G

Oct 7, 2021

Important topic but the professor delivery style was not at par with other SQL and Python course professors. The speed of teaching and sometimes depth and details were missing.

By Marjorie G

Mar 31, 2022

Worst course ever - I don't recommend it

By Jose L G M

Apr 4, 2022

A lazy written course

By Paul A S

Dec 8, 2023

Badly organised

By Anitha K

Mar 26, 2022

The material & training is really good. Would like to point out that it would be good if a proper into is given about "what is data wrangling" before going directly into practice. I had go through couple of youtube videos initially to get to know about the subject.Could have avoided that by giving a more detailed intro on the subject. But, practice problems are excellent and the way she explains is really excellent. I can see a very sincere effort from the instructor to make her students get comfortable with quering and the approach as its a different approach in quering unstructured data.Really appeciate that. Little confusions for last peer graded assignment as question doesnt ask for % but in the answer it shows %. So will be nice if questions & answers are in sync as well are more clear. Some places we are not sure what the instructor wants, but comes to know after seeing the solution video which is really very helpful and clear. Overall very challenging & exicting course. Kindly provide a more detailed intro on the subject.I would definitely recommend this course for anyone who wants good practice & knowledge in the subject.Thank you.

By Minjae Y

Mar 4, 2022

This is a difficult course when you don't have a previous experience of handling any SQL data and analysis before. However, I bet you would get the real problem-solving experiences if you are patient and try to listen to the lecture carefully.

By Chris H

Apr 4, 2022

I learned a lot from this course. It was tough and really made me think. I do feel like maybe there were some things that were left out of the instruction but appeared on the quizzes and tests. I was surprised at times at the difficulty of the tests and felt I had missed something. Additional excercises with detailed walkthroughs of the code and explanation of the code would have been helpful.

By Khalid A 2

Nov 3, 2022

This course is good but can be better.

It may seem that it's exercises and assignments are not clear, but I think that is a good thing as in real life you are not expecting every thing to be clear and to the point. so it was a good practice to think what did they mean by this and that

By Karan B

Mar 21, 2020

Course was ok overall. I learned the basics and the SQL was good. I learned a lot about the basics of SQL through the course. However, the video could have been better edited and the prompts/questions (especially in the final project) were difficult to understand.

By Nate F

Aug 17, 2022

Like most students I found this course to be a significant leap from the first course. This course could be better if the discussion forum wasn't mandatory, students tend to enter anything just to get to the next step. Which is particularly frustrating when you try to search the forum for help. Also, there are many postings in the forum from students who get frustrated with the solution codes - some solutions don't work as-is in mode.com. However, a student can play around with the code enough to get it to work correctly. Now that I have finished the course, I am glad that I did. Anyone who is thinking about taking this course: it will be difficult, but it is worth it.

By Shaini K

Dec 8, 2021

The course had a lot of interesting material and covered a lot of concepts, however, the HW was unorganized and very little information was provided to get it started. The course needed a document with a schema for the data set and much more guidance in solving the problems. Sometimes, the solutions videos were to fast and skipped over the code quickly so that it was hard to take notes. A guide to the solutions in a document would be great too. However, I learnt a lot and will continue to practice using the other resources provided in the course.

By Katherine H

Aug 1, 2023

Somewhat helpful course.

Pros: better understanding of more SQL functionality

Cons: some material seems to have been changed or updated, so not all assignments flow together well. No visual layout of the data source, which made that part hard to understand. Have to use Mode site, which is mostly fine, except it's not explained how to get a shareable link for the final project. Wish there were more examples and explanations in the course, rather than having exercises and then going over it.

By Alejandro M Z

Jun 24, 2022

The content is good but the assignments are very confusing. Half the time I was guessing at what they wanted me to do. The support is terrible with seemingly no one responding to quesitons and many old questions left unanswered. This is not a well-put together course but if you stick with it you will definitely learn a lot but it takes more effort than it should.

By LUIS G

Jul 25, 2022

no se explica el uso de la plataforma para subir trabajo final. No logre entender el efoque de este curso

By Spyridon M

Jun 16, 2023

Unfortunately, this course looked more like a university course and not at all like an online course. There were many theoretical elements not covered, with strong emphasis towards subjects of little interest (at least to me). For example, in the AB testing section, there very little theory and interminable exercises over tables that have not been sufficiently explained before. Also, terminology was used without having been explained before (the term 'lift' in the final test for example has not been mentioned before).

Another feature I did not appreciate throughout this course was the need to remember the features of a dataset and the contents of the tables without a star schema or other resource. This made the exercises a bit pointless in the sense that for people that cannot go through the course continuously, they had to re-familiarize themselves with the contents of different tables before any new session. For me personally, this defies the entire scope of doing an online course.

The final test also demanded things that were not demonstrated throughout the course (how does one use the report builder to write text?) and no code was assessed (what was the test about then? only AB testing???).

So, bottom line, the only section in this course that was really useful for me was where the instructions on how to construct a complex query were displayed. I certainly hope the next course in this specialization is more interesting and informative.

By Fabian E P C

Aug 24, 2022

Hello,

The course contains good information and an approach to the use of SQL that is not very common, as it does not focus on the uses that are traditionally used for teaching, it is very different to work with data as seen. However, the structure of it, the activities and the way it is explained leaves much to be desired, it is not clear on the tasks, the 'teaching' videos are very vague on the concepts and the flow of the videos is not very dynamic.

I understand that the day to day work of a data scientist is not all roses, but in a course you should be a bit more specific in the assignments and teachings.

I would not recommend this specialization for someone who is just starting with SQL, the two courses I have taken so far I do not consider appropriate for a beginner, the first one for being a mere review in slides and this one for what I have already mentioned.

I am sure Kat is a very good data scientist, but she needs to improve her skills as a teacher and she needs a team to support her, you can see that the courses were created at the first time, without a general supervision and in a very short time.

Regards.

By Aravind S

Oct 6, 2022

I was very disappointed by this course... It was extremely disjointed. You are expected to have SQL skills that were not taught or mentioned in the first section in this series. The instructor was friendly but I did not feel like she explained concepts clearly or how she got to her conclusion. The prompts provided in many of the quizes were open ended and did not outline the steps needed. I understand that data science is a vague subject and your stakeholders won't always know what they are asking for. However, as this course is meant to be for beginners, I found it a little frustrating to follow along. The concepts in the course are interesting but the execution was very poor. I'd suggest skipping this course in the series and learning about AB testing in another course.