Chevron Left
返回到 Data Wrangling, Analysis and AB Testing with SQL

学生对 加州大学戴维斯分校 提供的 Data Wrangling, Analysis and AB Testing with SQL 的评价和反馈

3.4
716 个评分

课程概述

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....

热门审阅

MF

Sep 22, 2020

A good course for learning and apply sql to conduct analysis on ab testing results. Would be better if the instructor could provide more info about how to design and apply AB Testing on the customers

SP

Jul 29, 2019

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!

筛选依据:

1 - Data Wrangling, Analysis and AB Testing with SQL 的 25 个评论(共 275 个)

创建者 Annie L

Feb 28, 2020

创建者 Anisha Z

Apr 3, 2020

创建者 Susan L

Nov 7, 2019

创建者 Marie-Eve J

Feb 11, 2020

创建者 Michael P

Aug 31, 2020

创建者 Alex B

Feb 3, 2020

创建者 Sanija K

Jan 5, 2020

创建者 Claire H

Apr 27, 2020

创建者 Jamison C

Oct 22, 2020

创建者 Adam A

Sep 28, 2020

创建者 Ahmad B S

Apr 12, 2020

创建者 Marston G

Apr 17, 2020

创建者 Tianmin L

Nov 26, 2019

创建者 Marcos d C

Nov 24, 2020

创建者 Lucy D

May 3, 2020

创建者 Sean G

Apr 10, 2020

创建者 Mahmoud E I

Jan 24, 2022

创建者 Lucia

Nov 27, 2020

创建者 Aman G

Jan 28, 2022

创建者 Shriti P

Jul 30, 2019

创建者 Alexandre C

Dec 12, 2019

创建者 Luis F P M

Oct 8, 2020

创建者 Chelsey S

Jul 16, 2021

创建者 Joaquin J C

Nov 9, 2021

创建者 Rohan G L

Jun 28, 2020