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 企業版您將學到的內容有
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 企業版
提供方
授課大綱 - 您將從這門課程中學到什麼
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 very thorough overview of SQL and how to best structure data tables and metrics for AB testing. I appreciate the high quality content of the UC Davis courses!
Was a tough one, but eventually made through after several attempts
The course lectures and reading materials were excellent; some of the assignments were a bit unclear in terms of the directions. Overall I'd recommend the course.
I liked the course. I learned a lot. The only thing that final solutions showed in videos could have been shared in text file form also.
關於 Learn SQL Basics for Data Science 專項課程
常見問題
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
有助学金吗？
還有其他問題嗎？請訪問 學生幫助中心。
