Data Wrangling, Analysis and AB Testing with SQL

Overview

In this Data Wrangling, Analysis and AB Testing with SQL  course offered by Coursera in partnership with UC Davis 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.

What you'll learn

• Validate and clean a dataset

• Assess and create datasets to answer your questions

• Solve problems using SQL

• Build a simple testing framework to touch on AB Testing