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.
- 5 stars34.40%
- 4 stars18.32%
- 3 stars16.08%
- 2 stars14.68%
- 1 star16.50%
來自DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL的熱門評論
Amazing work guys! I enjoyed the coding part a lot. Thank you!
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.
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
Meticoulosly designed course and equally well delivery. Exercises were challenging and fun!