Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

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

Kiran B. · Reviewed حوالي سنة ago

Théo H. · Reviewed حوالي سنة ago

Gesiane D. · Reviewed حوالي سنة ago

Antonio L. · Reviewed حوالي سنة ago

Thomas C. · Reviewed حوالي سنة ago

Dillibabu P. · Reviewed حوالي سنة ago

Karan R. · Reviewed حوالي سنة ago

URAIRAT J. · Reviewed حوالي سنة ago

Liliya C. · Reviewed حوالي سنة ago