Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Luca M. · Reviewed أكثر من سنة ago

YAZID A. · Reviewed أكثر من سنة ago

Nicola K. · Reviewed أكثر من سنة ago

André F. · Reviewed أكثر من سنة ago

Diego L. · Reviewed أكثر من سنة ago

민석 한. · Reviewed أكثر من سنة ago

Любомир С. · Reviewed أكثر من سنة ago

Reinhart O. · Reviewed أكثر من سنة ago

Сергій Щ. · Reviewed أكثر من سنة ago

Andres F. · Reviewed أكثر من سنة ago

Andriy B. · Reviewed أكثر من سنة ago

Leonard K. · Reviewed أكثر من سنة ago

Konrad F. · Reviewed أكثر من سنة ago

Chaitanya S. · Reviewed أكثر من سنة ago

This was a good lab (although not beginner-friendly) for using SQL. I think there should be more explanation on some exercises. For example, the 3rd challenge asks for "unique visit id". I know SQL enough to be familiar with CONCAT function, but there's nothing in this exercise that points to the use of this function, since I had no idea I was supposed to fuse two different IDs. I don't work with sales, and I don't know if this is common for this area or not, but I think there should be a fine print explaining what "unique visit id" is. If this was a real life situation, I'd probably ask my senior what each column stands for and what does this mean. Another example is conversion rate. I had a vague idea, but I don't think everyone that takes this course might know it. I had to look it up to understand what it meant. It's nice to propose an answer, but every time I came to check the answer I realized there was something in it that I couldn't possibly have known in factual terms (in SQL terms, everything was doable).

Marina M. · Reviewed أكثر من سنة ago

Matt C. · Reviewed أكثر من سنة ago

good

Ivan M. · Reviewed أكثر من سنة ago

Eliud L. · Reviewed أكثر من سنة ago

xenia d. · Reviewed أكثر من سنة ago

Trisha C. · Reviewed أكثر من سنة ago

Diego P. · Reviewed أكثر من سنة ago

Ayoub L. · Reviewed أكثر من سنة ago

MARCO AURELIO P. · Reviewed أكثر من سنة ago

no explanation on how to write queries!!!

Inna G. · Reviewed أكثر من سنة ago

This needs more explanation and people who are new to SQL will need additional support to understand what is being asked. The timer doesn't help as one feels anxious they will run out of time before completion

Miriam M. · Reviewed أكثر من سنة ago