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
961 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:

101 - 125 of 390 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Ana M

Jul 12, 2023

This course is not on par with the first one on this certification. The video explanations for the exercises are confusing, unengaging, and outright boring. The code on the PDF with the exercises can't be copied, you have to type everything by hand.

By Heiko B

May 5, 2023

I couldn't complete course because SQL web application needed to do exercises expired trial period and I didn't get any response to my question how to resolve that problem. I had to abandon course.

By Kiley G

Mar 28, 2023

if you do not have credentials already for program do not enroll

By i a I

Jul 23, 2022

full of mistakes

By Alvaro H M M

Apr 11, 2023

el peor curso

By Ahmet G

Jul 19, 2023

First of all, I would like to express my sincere thanks. I learned many things from you. Please don't see it as arrogance but; As a data analyst, I now see myself at a higher level in SQL. I can even say that I am at the advanced SQL level according to mode.com. Thanks to you, my data analysis mind map with SQL has been shaped much more clearly. This is a great feeling for me. I think it would be much better if we could only do 1-2 different sample studies like the A/B test Final Exam. I am grateful to you ( COURSERA and UCDAVIS ) for giving me this opportunity.

But in addition I have to say;

Throughout the course, I encountered numerous challenges and struggled considerably. The exercises provided were often vague and lacked clarity, making it difficult to understand the intended objectives. The overall experience of completing this course was excessively stressful. I believe that this course requires a some overhaul. It is also worth mentioning that while the first course utilized SQLite, the sudden transition to PostgreSQL.

By Robert A

Jan 15, 2023

This was a great learning experience. I saw some folks registered concern about some topics not clear, some topics addressed without introduction in the earlier course (e.g., windows). Frankly, this kind of learning is what I am used to, walking into a real class on a university campus. I am expected to dig in on my own where I don't quite get it. The advantage here is that I can just keep replaying the video, until I finally grasp the concepts completely. It took me twice to pass the final assignment. On the first round I was graded by two fellow students; one guy had no mercy, and the other one was reasonable, but the combination resulted in a score less than 80%. First time failure for me. But I went back and reworked the assignment and developed a much more firm understanding of the concepts and skills. Key point is that I am confident that I can use the skills practically and successfully in my work. Thanks!

By Silvia V V F

Nov 6, 2021

Un excelente curso , que requiere un nivel intermedio de conocimiento en SQL , como mejorar y optimizar las consultas siguiendo buenas practicas, aprender y aplicar SQL para realizar análisis de los resultados de las pruebas ab, como construir métricas adecuadas para la toma de decisiones en base a la naturaleza de los datos. Sería mejor si el instructor mejorara un poco su didáctica, hay partes que resultaron algo tediosas sobre todo en algunos ejemplos prácticos y si pudiera proporcionar más información sobre cómo diseñar y aplicar pruebas AB

By Tina

Mar 21, 2023

It is a well thought our course that focuses on practical exercises and gives a glimpse into analyzing an e-commerce site, using subqueries to combine aggregate functions sum and count. It is a glitch to have to write anything to see the video, as everyone should be given access to the solution videos. However, very clear explanations of coding and solutions as this is somewhat intermediate course.

By Jumrus R

Mar 13, 2022

This course provides us a good SQL practice and exploration in the uses of various syntax. All this while showing us the imperfect picture of a professional. My complaints here would be some typos and that it's not very active - resulting in slow assignment peer-grading. If you look past those, however, I think this is a great course!

By Karina S

Jan 19, 2020

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!

By Obira D

Apr 30, 2022

Very hand in detailed SQL analysis (tables, views, long sub-querries, goog intro to mode analytics platform, cleaning data, basic analysis and the fundamentals of A/B experiment tests at user, item level and results intepretaion).

Hihly recommended.

By Olabode A

Apr 23, 2021

The information in this course is very great as well as the practical part of the course. The instructor was very great and knowledgeable. Thus, I recommend this program to anyone who is interested in learning SQL queries.

By Ajith S R

Nov 25, 2021

It's perfect. The course starts from Nuts & Bolts and gradually reach the hype i.e., A/B Testing. It triggers us to explore lot about the content and resources given were astonishing. Keep up the great work.

By Endong T

Nov 8, 2020

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.

By LiuYang

Apr 22, 2022

The course is really beneficial. However, I couldn't comprehensively understand some points of it. I'll review it later. Thanks, teachers and coursera.

By Viviana R

Nov 25, 2020

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

By Ilja H

Oct 9, 2022

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.

By Zul I M R

May 9, 2023

I have been following this specialized course for a year now. They really teach things greatly and makes stuff easily understandable.

By Anne C

Mar 26, 2023

Just the right level to be challenging but doable so I learned a lot. The practice questions and learning to use Mode were useful.

By Luis R R L

Nov 7, 2021

Has a lot of knowledge about analizing, even when you don't have a direct career to computer science it is really helpful

By Nathaniel M

Jun 5, 2021

Overall great course, really get's you into data wrangling and exploring data in SQL with in almost real life situations.

By Isaias D C A

Sep 21, 2021

The best module helped us understand how to improve the analysis and testing tools to create the better final queries.

By Jose L O T

Feb 12, 2021

Bien practico el cuso me encanto esta parte. También me ayudo a saber que tengo que reforzar en estadística .

By Aatish R

Jun 30, 2021

Meticoulosly designed course and equally well delivery. Exercises were challenging and fun!