Chevron Left
返回到 Data Wrangling, Analysis and AB Testing with SQL

學生對 加州大学戴维斯分校 提供的 Data Wrangling, Analysis and AB Testing with SQL 的評價和反饋

3.5
286 個評分
109 條評論

課程概述

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....

熱門審閱

MF
2020年9月22日

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

SP
2019年7月29日

The instructor is very smart and her syllabus is very easy to follow. The real life examples are great and helps put ideas in perspective! I would definitely recommend this course and already have!

篩選依據:

26 - Data Wrangling, Analysis and AB Testing with SQL 的 50 個評論(共 109 個)

創建者 Marcos d C

2020年11月24日

The worst course I've ever done in Coursera. Videos and exercises felt very low quality and put together in a rush. Half the course is trivial and brings nothing new. The other half introduces new concepts without any context and makes it very easy to get lost.

I am also unhappy with how little attention the discussion forums receive, so good luck if you need one of the organizers to solve an issue with the assignment.

創建者 Karan B

2020年3月21日

Course was ok overall. I learned the basics and the SQL was good. I learned a lot about the basics of SQL through the course. However, the video could have been better edited and the prompts/questions (especially in the final project) were difficult to understand.

創建者 Ayomide O

2020年11月17日

I'll give it a 5 mostly because this is one of the few in-depth SQL courses on the site, plus it actually goes beyond Joins and all that other pre-advanced stuff. I actually learnt new methods such as using windowing functions and using AB Testing. It could be better yes but we need more practical courses like this one.

創建者 Karina S

2020年1月19日

Great course!! I have learned a lot about how to evaluate the quality of the data received, how to problem solve with SQL when asked ambiguous business requirements, tips to do multiple selection editing in text editor (that was a great discovery!), metrics and AB testing. Highly recommended!

創建者 Endong T

2020年11月8日

The assignments are pretty difficult, and I think this course suits those who have advanced SQL skills and wanna use SQL to solve higher level problems. The lecturer are pretty interesting, and I enjoy that.

創建者 Mike F

2020年9月23日

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

創建者 Soprano R

2020年7月12日

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.

創建者 Jennifer B

2019年12月30日

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!

創建者 Viviana R

2020年11月25日

Gracias por impartir conocimientos online y darnos la posibilidad, a quienes trabajamos seguir perfeccionándonos, organizando los tiempos personles

創建者 Abhinav A

2020年5月8日

Good course but a little more challenging for me as a beginner and new to SQL. Overall Good

創建者 Steven K C W

2019年11月1日

Amazing work guys! I enjoyed the coding part a lot. Thank you!

創建者 Gary T

2019年12月6日

SQL, Data Wrangling. Challenging and fun course.

創建者 Monish P

2020年6月23日

Well executed and scripted for learning

創建者 Mahedi M

2020年4月18日

Challenging, but I learned quite a lot.

創建者 David M G

2020年5月1日

Very complete course! Thank you!

創建者 Samuel E

2020年11月11日

Really professional!!

創建者 Aditya S

2020年10月30日

Interesting Course

創建者 Chen M

2020年8月17日

useful course

創建者 Thao N

2020年6月19日

Excellent!

創建者 Namanpreet K

2020年7月6日

excellent

創建者 Saman S

2020年1月27日

fantastic

創建者 Hector G

2020年9月5日

perfect

創建者 Christos V

2019年12月16日

I recommend the course in general. It has a combination of theoretical principles and hands on exercises in order to familiarize with the concepts behind the course.

On the other hand, I believe that instructions in order to perform and complete the exercises were not always clear which resulted in losing lots of time in order to try to decode what the actual expectations were.

But once again, a good course, giving insight in data wrangling and AB testing.

創建者 Gisella B

2020年4月17日

I had read comments about the instructors reviews that were distracting. But I actually liked a lot to see the construction of real queries in real team. However they were getting increaslingly complex and it was hard for me to keep up. You need a lot of practice on SQL before or during this course. Also, some of the instructions of the assignments were not clear at all. You can learn a lot with this course, but it will not be easy.

創建者 Oscar F

2020年11月24日

La profesora es agradable. Las primeros módulos son la continuación del anterior curso, se aprenden algunos comandos más. Algunos ejercicios requieren comandos que no se han visto pero en los videos de solución los muestran. Recomiendo leer bien la página de ABBA (ellos te dan el link) para entender mejor en qué consiste el AB testing. Me gustó la plataforma de Mode Analytics.