Data Wrangling, Analysis and AB Testing with SQL

开始时间: 04/20/2019 持续时间: Unknown

所在平台: Coursera

课程类别: 其他类别

大学或机构: CourseraNew

   

课程主页: https://www.coursera.org/learn/data-wrangling-analysis-abtesting

Explore 1600+ online courses from top universities. Join Coursera today to learn data science, programming, business strategy, and more.

课程评论:没有评论

第一个写评论        关注课程

课程详情

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.

课程大纲

Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing

课程评论(0条)

欢迎关注我们的公众号

NLPJob

课程简介

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 s

课程标签

0人关注该课程

主题相关的课程