Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Abhishek K. · Reviewed about 1 year 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 about 1 year ago

Easy, clear and fast

Antonio D. · Reviewed about 1 year ago

Kiran B. · Reviewed about 1 year ago

Théo H. · Reviewed about 1 year ago

Gesiane D. · Reviewed about 1 year ago

Antonio L. · Reviewed about 1 year ago

Thomas C. · Reviewed about 1 year ago

Dillibabu P. · Reviewed about 1 year ago

Karan R. · Reviewed about 1 year ago

URAIRAT J. · Reviewed about 1 year ago

Liliya C. · Reviewed about 1 year ago

Vijay P. · Reviewed about 1 year ago

Faith M. · Reviewed about 1 year ago

Jordan V. · Reviewed about 1 year ago

Leon Victor M. · Reviewed about 1 year ago

Polina P. · Reviewed about 1 year ago

Marcos C. · Reviewed about 1 year ago

Nicolas M. · Reviewed about 1 year ago

Samuel H. · Reviewed about 1 year ago

3

Adi I. · Reviewed about 1 year ago

Christian M. · Reviewed about 1 year ago

Josep C. · Reviewed about 1 year ago

Steve P. · Reviewed about 1 year ago

Alejandro R. · Reviewed about 1 year ago