Data Wrangling, Analysis and AB Testing with SQL

( 12 Reviews )

Created by: Katrina Glaeser

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 76 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a data science course? Or looking for more detail on Katrina Glaeser's Data Wrangling, Analysis and AB Testing with SQL? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

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.

Time: 23h

Instructor Details

Katrina Glaeser

3.8 Rating
12 Reviews

Kat Glaeser received her Master's degree in Mathematics from UC Davis, where she developed a love of teaching and was nominated for the Outstanding Graduate teaching award for her work on an online linear algebra course. Kat started her career working at Yammer which was responsible for introducing AB testing principles to the other parts of Microsoft's Office team. Later she joined Pandora Media as part of a small team serving artists and the music industry. At Pandora she developed the experiments, models and methodology to help artist talk directly to their fans. Currently Kat is part of a small team of data scientists at a Scribd, a subscription-based book company that is changing the way the world reads. Outside of the office she enjoys trail running with her dog, sending snail mail, and bike touring.

The Data Scientist's Toolbox (2019)

5.0 (148 Reviews)

Provider: Coursera
Time: 8h

Free

Python for Data Science (2017)

4.4 (9 Reviews)

Provider: edX

Free

Python A-Z: Python For Data Science With Real Exercises! (2022)

4.4 (150 Reviews)

Provider: Udemy
Time: 11h

$10.44

More Courses

Reviews

3.8

12 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Michael P on 13-Aug-19

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.

By Shriti P on 30-Jul-19

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!

By Susan L on 8-Nov-19

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

By Steven K C W on 1-Nov-19