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.
提供:
このコースについて
Some statistics is recommended and at least 2-years business experience.
貴社では、従業員に需要のあるスキルを訓練させることによって利益を得ることができるでしょうか?
Coursera for Businessを試す学習内容
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
習得するスキル
- A/B Testing
- Query String
- Data Analysis
- Predictive Analytics
- SQL
Some statistics is recommended and at least 2-years business experience.
貴社では、従業員に需要のあるスキルを訓練させることによって利益を得ることができるでしょうか?
Coursera for Businessを試すシラバス - 本コースの学習内容
Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing
レビュー
- 5 stars33.95%
- 4 stars18.52%
- 3 stars16.37%
- 2 stars14.49%
- 1 star16.64%
DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL からの人気レビュー
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
At first I hated this course bcz it has a lot of exercises but then those actually helped me hone this skill.
It is pretty useful course to understand how to prepare data for AB Testing in real database environment. you should know SQL intermediate leve before starting this course.
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!
Learn SQL Basics for Data Science専門講座について

よくある質問
いつ講座や課題にアクセスできるようになりますか?
この専門講座をサブスクライブすると何を行うことができるようになりますか?
学資援助はありますか?
さらに質問がある場合は、受講者ヘルプセンターにアクセスしてください。