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.
Ce cours fait partie de la Spécialisation Learn SQL Basics for Data Science
Offert par
Spécialisation Learn SQL Basics for Data ScienceUniversité de Californie à DavisÀ propos de ce cours
Some statistics is recommended and at least 2-years business experience.
Votre entreprise pourrait-elle bénéficier de la formation des employés à des compétences recherchées ?
Essayez Coursera pour les affairesCe que vous allez apprendre
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
Compétences que vous acquerrez
- A/B Testing
- Query String
- Data Analysis
- Predictive Analytics
- SQL
Some statistics is recommended and at least 2-years business experience.
Votre entreprise pourrait-elle bénéficier de la formation des employés à des compétences recherchées ?
Essayez Coursera pour les affaires
Offert par
Programme de cours : ce que vous apprendrez dans ce cours
Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing
Avis
- 5 stars34,35 %
- 4 stars18,43 %
- 3 stars16,06 %
- 2 stars14,66 %
- 1 star16,48 %
Meilleurs avis pour DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL
The course was very informative but honestly, it was very difficult to do some assignments because I can't find the necessary tables or colums. But, anyway thank you for this course)
This challenging course demonstrates the power of integrating SQL, creative thinking and analytics.
the solution is not accurate enough with the real answer, it may cause some confusions
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.
À propos du Spécialisation Learn SQL Basics for Data Science
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.
