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.
Este curso forma parte de Programa especializado: Learn SQL Basics for Data Science
Ofrecido Por
Programa especializado: Learn SQL Basics for Data ScienceUniversidad de California, DavisAcerca de este Curso
Some statistics is recommended and at least 2-years business experience.
¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negociosQué aprenderás
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
Habilidades que obtendrás
- A/B Testing
- Query String
- Data Analysis
- Predictive Analytics
- SQL
Some statistics is recommended and at least 2-years business experience.
¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negocios
Ofrecido por
Programa - Qué aprenderás en este curso
Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing
Reseñas
- 5 stars33,75 %
- 4 stars17,90 %
- 3 stars16,36 %
- 2 stars14,83 %
- 1 star17,13 %
Principales reseñas sobre DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL
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 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.
The resources and instructions by the instructor were great.
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!
Acerca de Programa especializado: Learn SQL Basics for Data Science
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
¿Qué recibiré si me suscribo a este Programa especializado?
¿Hay ayuda económica disponible?
¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.
