Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Valeriia D. · Reviewed 1 yıldan fazla ago

Włodzimierz L. · Reviewed 1 yıldan fazla ago

DIlson C. · Reviewed 1 yıldan fazla ago

Hernaldo C. · Reviewed 1 yıldan fazla ago

Jorge S. · Reviewed 1 yıldan fazla ago

Sai S. · Reviewed 1 yıldan fazla ago

Eric S. · Reviewed 1 yıldan fazla ago

Benjamin S. · Reviewed 1 yıldan fazla ago

Benjamin C. · Reviewed 1 yıldan fazla ago

Dixika P. · Reviewed 1 yıldan fazla ago

Giorgia B. · Reviewed 1 yıldan fazla ago

Beatrice R. · Reviewed 1 yıldan fazla ago

Sevilay G. · Reviewed 1 yıldan fazla ago

Adam M. · Reviewed 1 yıldan fazla ago

Sulogna S. · Reviewed 1 yıldan fazla ago

Shailendra K. · Reviewed 1 yıldan fazla ago

Harry K. · Reviewed 1 yıldan fazla ago

Radhika D. · Reviewed 1 yıldan fazla ago

Viviane M. · Reviewed 1 yıldan fazla ago

Daniel V. · Reviewed 1 yıldan fazla ago

Mohamed M. · Reviewed 1 yıldan fazla ago

Florencia M. · Reviewed 1 yıldan fazla ago

Abhishek K. · Reviewed 1 yıldan fazla ago

Three are a several issues. 1. it asks is the highest visited product also the highest number of orders. the answer is YES, but i was marked wrong because it meant to ask is the product with the highest visitors the most ordered units of a product. 2. practice question 1. uses, productQuantity as a count for add to carts and sum for orders. however that was never defined. Additionally it doesn't call out that ecommerceAction_type =3 is add to cart until way after that question is asked. Same for question number 2, the answer is part of 2b. The practice questions omit information that should be part of the question so that we have a fighting chance of answering it. asking for add to carts and then hiding the data in a type = 3 is just wrong.

Eric L. · Reviewed 1 yıldan fazla ago

Easy, clear and fast

Antonio D. · Reviewed 1 yıldan fazla ago