Exploring an Ecommerce Dataset using SQL in Google BigQuery avis

Luca M. · Examiné il y a plus d'un an

YAZID A. · Examiné il y a plus d'un an

Nicola K. · Examiné il y a plus d'un an

André F. · Examiné il y a plus d'un an

Diego L. · Examiné il y a plus d'un an

민석 한. · Examiné il y a plus d'un an

Любомир С. · Examiné il y a plus d'un an

Reinhart O. · Examiné il y a plus d'un an

Сергій Щ. · Examiné il y a plus d'un an

Andres F. · Examiné il y a plus d'un an

Andriy B. · Examiné il y a plus d'un an

Leonard K. · Examiné il y a plus d'un an

Konrad F. · Examiné il y a plus d'un an

Chaitanya S. · Examiné il y a plus d'un an

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. · Examiné il y a plus d'un an

Matt C. · Examiné il y a plus d'un an

good

Ivan M. · Examiné il y a plus d'un an

Eliud L. · Examiné il y a plus d'un an

xenia d. · Examiné il y a plus d'un an

Trisha C. · Examiné il y a plus d'un an

Diego P. · Examiné il y a plus d'un an

Ayoub L. · Examiné il y a plus d'un an

MARCO AURELIO P. · Examiné il y a plus d'un an

no explanation on how to write queries!!!

Inna G. · Examiné il y a plus d'un an

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. · Examiné il y a plus d'un an