Katrina Glaeser
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. UC Davis, one of the nation’s top–ranked research universities, is a global leader in agriculture, veterinary medicine, sustainability, environmental and biological sciences, and technology. With four colleges and six professional schools, UC Davis and its students and alumni are known for their …
Instructor Details
Courses : 1
Specification: Data Wrangling, Analysis and AB Testing with SQL
|
18 reviews for Data Wrangling, Analysis and AB Testing with SQL
Add a review
| Price | Free |
|---|---|
| Provider | |
| Duration | 23 hours |
| Year | 2019 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
FREE
Shriti P –
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!
Michael P –
Lots of “oh wait, let me catch my own mistakes” on the videos. It appears to be sloppy, rather than a “teaching moment” for how one might debug the query.
Steven K C W –
Amazing work guys! I enjoyed the coding part a lot. Thank you!
Susan L –
I liked the content of this course. It is very practical. The teaching style was frustrating for me, though. I understand that the instructor wanted us to “see” that everyone, even experts, make silly mistakes when they code (like forget ,’s or the mis name variables), but watching mistakes being made in EVERY solutions video was too much. More time should have been taken explaining the coding concepts, rather than watching mistakes. Also, there wasn’t much discussion. I had trouble with some of the early assignments and (as instructed) asked for help in the discussion. But no one EVER responded! So I stopped asking for help. Basically, everyone just wrote “done” or something like that. To be fair, I’m not sure anyone actually looked at or read the discussion threads. You just had to write something in the discussion box to unlock the solutions video. There also seemed to be some errors in the solution codes. Some of the solutions were fine, but others spawned errors when I cut and pasted them into Mode (the software we used). I still don’t understand in one of the final assignments how the instructor used the table dsv1069.events big (or something like that that wasn’t listed as one of the files we had access to). When I tried using this file in my own code, I got an error. When I cut and pasted the entire solution code, I got an error. Maybe I was doing something wrong. I just don’t know. But gaining this understanding was something I really wanted to learn &
Tianmin –
The solution data in the video sometimes do not match with the tasks provided
Gary T –
SQL, Data Wrangling. Challenging and fun course.
Alexandre C –
I find the teacher very interesting. The cases were also interesting. Harder key concepts like windowing functions or multiple subqueries should be included in courses and not only in exercices solution videos.
Christos V –
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.
Jennifer B –
A very thorough overview of SQL and how to best structure data tables and metrics for AB testing. I appreciate the high quality content of the UC Davis courses!
Sanija K –
Awful explanation. No structure.
Mehrshad E –
Good course, not very productive instruction though!
Cristina R –
Pretty informative course! Sometimes the descriptions of the practice exercises seem a bit fuzzy, but as you go with the course it gets easier to understand how to interpret the requirements. Very helpful solution videos!
Karina S –
Great course!! I have learned a lot about how to evaluate the quality of the data received, how to problem solve with SQL when asked ambiguous business requirements, tips to do multiple selection editing in text editor (that was a great discovery!), metrics and AB testing. Highly recommended!
Saman S –
fantastic
Alex B –
this was the worst one I’ve taken on coursera. I couldn’t really concentrate on what the instructor talks about in the video because I had to listen how she slams the keys while typing the code. Seriously? Couldn’t that part have been muted out? This was a very bad experience. I’m going to have to take a different course on SQL AB testing
Marie Eve J –
There is a big gap between what was taught in the previous class and what is expected to be known in this class. Moreover, the instructor often poorly explains the codes that she is teaching in the solution videos. and don’t seem to have been critically reviewed for improvements.
Karan B –
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.
Sunny Y Y S –
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.