Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Valeriia D. · Reviewed أكثر من سنة ago

Włodzimierz L. · Reviewed أكثر من سنة ago

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

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

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

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

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

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

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

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

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

Beatrice R. · Reviewed أكثر من سنة ago

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

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

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

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

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

Radhika D. · Reviewed أكثر من سنة ago

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

Daniel V. · Reviewed أكثر من سنة ago

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

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

Abhishek K. · Reviewed أكثر من سنة 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 أكثر من سنة ago

Easy, clear and fast

Antonio D. · Reviewed أكثر من سنة ago