Chevron Left
Back to Data Wrangling, Analysis and AB Testing with SQL

Learner Reviews & Feedback for Data Wrangling, Analysis and AB Testing with SQL by University of California, Davis

3.3
stars
922 ratings

About the Course

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

Top reviews

MF

Sep 22, 2020

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

Jul 29, 2019

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!

Filter by:

151 - 175 of 370 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Chen M

Aug 17, 2020

useful course

By Wahab A

Feb 26, 2023

Best course.

By Sachin W

Jan 21, 2021

nice course

By Thao N

Jun 19, 2020

Excellent!

By Anthony B L C

Feb 5, 2024

Todo bien

By Nelson T A

Oct 12, 2023

very good

By FELIX I A L N

Jul 1, 2022

EXCELENTE

By Luis B P T

Oct 21, 2021

VERY GOOD

By Namanpreet K

Jul 6, 2020

excellent

By Saman S

Jan 27, 2020

fantastic

By Nataly C R G

Sep 28, 2022

graciAS

By Hector G

Sep 5, 2020

perfect

By James N N

May 24, 2022

Awsome

By JHONNY M F

Nov 23, 2021

all ok

By Edoh A

Oct 28, 2021

superb

By Cesar J L R

Jun 13, 2022

bueno

By César V C

May 5, 2022

done

By Karen K

Jul 2, 2021

Nice!

By Thuận N H

May 19, 2023

Good

By Muhammad S

May 10, 2023

good

By Weizmann G B

Nov 12, 2022

good

By chen c

Sep 21, 2021

good

By Brian

Dec 20, 2022

Tough call on where to rate this: 5 stars for planning and ambition, choice of use case and data; 4 stars for quality of instruction and videos, 2-3 stars for clarity of assignment questions and checking to make sure things are up to date.

I think most people will come out of this course with a deeper understanding of how databases for online stores actually work (not some "toy version" but closer to the real thing) but it can be a frustrating journey as you will have to hack around in Mode to try different things plus use other resources to figure out what's going on. That's a bit more like being a working professional, but maybe you don't want that lesson to be wrapped up with your efforts to acquire some SQL skills and tricks of the trade.

By Kartik D

Oct 15, 2021

The course is good. You will get to learn a lot from this course, as compared to previous Course(which is just the basic). The exercises are somewhat hard. Half of the time, it is due to ambiguity of the questions itself. You will feel frustrated on not knowing what to do. So, if this ambiguity is removed, the quality of the course can be improved. Further, the instructor should provide more videos/content on teaching SQL concepts which are neither taught in this course nor in the previous one but are used in the course.

By Philippe T

Jun 17, 2021

The course was good and the curriculum was well constructed. My only issues are with the clarity of some of the questions, which I sometimes felt was lacking. A diagram showing the schema of the database used in the course would make things a lot clearer. Also, the peer-grading process is a bit of a mess. Instructions on how to make the final submissions accessible to peers should be made clear. I only got it right because it is a common question in the discussion forum.