Data Wrangling, Analysis and AB Testing with SQL
Enhance your data science skills with our SQL course, where you’ll tackle complex case studies and learn to manipulate and analyze data effectively. From converting timestamps to optimizing JOIN operations, deduping data to handling nulls, our comprehensive training will equip you with the tools needed for successful data analysis. Discover how to segment and analyze data using windowing functions and execute conditional logic for insightful insights. Additionally, learn to schedule queries and insert data into date partitions. With practical applications and predictive analysis techniques, you’ll be ready to excel in AB testing. Join us now and unlock your data science potential.
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.
User Reviews
Be the first to review “Data Wrangling, Analysis and AB Testing with SQL”
You must be logged in to post a review.
There are no reviews yet.