Data Wrangling, Analysis and AB Testing with SQL
Learn SQL Basics for Data Science,
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.
Get a Reminder
Rating | 3.5★ based on 16 ratings |
---|---|
Length | 5 weeks |
Effort | 4 weeks of study, 2-5 hours/week |
Starts | Jul 3 (43 weeks ago) |
Cost | $49 |
From | University of California, Davis via Coursera |
Instructors | Katrina Glaeser, Katrina Glaeser Poole |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science Programming |
Tags | Data Science Data Analysis Machine Learning |
Get a Reminder
Similar Courses
What people are saying
ab testing
I'm going to have to take a different course on SQL AB testing fantastic Great course!!
), metrics and AB testing.
But once again, a good course, giving insight in data wrangling and AB testing.
Read more
solution videos
Moreover, the instructor often poorly explains the codes that she is teaching in the solution videos.
Very helpful solution videos!
Read more
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
AD, Data Science $47k
Associate Data Science Supervisor $55k
Science writer / data analyst $63k
Genomic Data Science Programmer $75k
Volunteer Director of Data Science $78k
Expert Data Science Supervisor $79k
Supervisor 1 Data Science Supervisor $91k
Guest Director of Data Science $101k
Data Science Architect $105k
Head of Data Science $131k
Assistant Director 1 of Data Science $133k
Owner Director of Data Science $149k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | 3.5★ based on 16 ratings |
---|---|
Length | 5 weeks |
Effort | 4 weeks of study, 2-5 hours/week |
Starts | Jul 3 (43 weeks ago) |
Cost | $49 |
From | University of California, Davis via Coursera |
Instructors | Katrina Glaeser, Katrina Glaeser Poole |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science Programming |
Tags | Data Science Data Analysis Machine Learning |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course