Como analisar seu conjunto de dados de comércio eletrônico com SQL no Google BigQuery avaliações

Luca M. · Revisado há over 1 year

YAZID A. · Revisado há over 1 year

Nicola K. · Revisado há over 1 year

André F. · Revisado há over 1 year

Diego L. · Revisado há over 1 year

민석 한. · Revisado há over 1 year

Любомир С. · Revisado há over 1 year

Reinhart O. · Revisado há over 1 year

Сергій Щ. · Revisado há over 1 year

Andres F. · Revisado há over 1 year

Andriy B. · Revisado há over 1 year

Leonard K. · Revisado há over 1 year

Konrad F. · Revisado há over 1 year

Chaitanya S. · Revisado há over 1 year

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. · Revisado há over 1 year

Matt C. · Revisado há over 1 year

good

Ivan M. · Revisado há over 1 year

Eliud L. · Revisado há over 1 year

xenia d. · Revisado há over 1 year

Trisha C. · Revisado há over 1 year

Diego P. · Revisado há over 1 year

Ayoub L. · Revisado há over 1 year

MARCO AURELIO P. · Revisado há over 1 year

no explanation on how to write queries!!!

Inna G. · Revisado há over 1 year

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. · Revisado há over 1 year