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.
Dieser Kurs ist Teil der Spezialisierung Spezialisierung Learn SQL Basics for Data Science
von
Spezialisierung Learn SQL Basics for Data ScienceUniversity of California, DavisÜber diesen Kurs
Some statistics is recommended and at least 2-years business experience.
Könnte Ihr Unternehmen von Mitarbeiterweiterbildungen für gefragte Kompetenzen profitieren?
Probieren Sie Coursera for Business ausWas Sie lernen werden
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
Kompetenzen, die Sie erwerben
- A/B Testing
- Query String
- Data Analysis
- Predictive Analytics
- SQL
Some statistics is recommended and at least 2-years business experience.
Könnte Ihr Unternehmen von Mitarbeiterweiterbildungen für gefragte Kompetenzen profitieren?
Probieren Sie Coursera for Business aus
Lehrplan - Was Sie in diesem Kurs lernen werden
Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing
Bewertungen
- 5 stars33,84 %
- 4 stars17,81 %
- 3 stars16,41 %
- 2 stars14,75 %
- 1 star17,17 %
Top-Bewertungen von DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL
the solution is not accurate enough with the real answer, it may cause some confusions
Good course but a little more challenging for me as a beginner and new to SQL. Overall Good
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.
Overall great course, really get's you into data wrangling and exploring data in SQL with in almost real life situations.
Über den Spezialisierung Learn SQL Basics for Data Science
Häufig gestellte Fragen
Wann erhalte ich Zugang zu den Vorträgen und Aufgaben?
Was bekomme ich, wenn ich diese Spezialisierung abonniere?
Ist finanzielle Unterstützung möglich?
Haben Sie weitere Fragen? Besuchen Sie das Learner Help Center.
