Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Abhishek K. · Reviewed yaklaşık 1 yıl 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 yaklaşık 1 yıl ago

Easy, clear and fast

Antonio D. · Reviewed yaklaşık 1 yıl ago

Kiran B. · Reviewed yaklaşık 1 yıl ago

Théo H. · Reviewed yaklaşık 1 yıl ago

Gesiane D. · Reviewed yaklaşık 1 yıl ago

Antonio L. · Reviewed yaklaşık 1 yıl ago

Thomas C. · Reviewed yaklaşık 1 yıl ago

Dillibabu P. · Reviewed yaklaşık 1 yıl ago

Karan R. · Reviewed yaklaşık 1 yıl ago

URAIRAT J. · Reviewed yaklaşık 1 yıl ago

Liliya C. · Reviewed yaklaşık 1 yıl ago

Vijay P. · Reviewed yaklaşık 1 yıl ago

Faith M. · Reviewed yaklaşık 1 yıl ago

Jordan V. · Reviewed yaklaşık 1 yıl ago

Leon Victor M. · Reviewed yaklaşık 1 yıl ago

Polina P. · Reviewed yaklaşık 1 yıl ago

Marcos C. · Reviewed yaklaşık 1 yıl ago

Nicolas M. · Reviewed yaklaşık 1 yıl ago

Samuel H. · Reviewed yaklaşık 1 yıl ago

3

Adi I. · Reviewed yaklaşık 1 yıl ago

Christian M. · Reviewed yaklaşık 1 yıl ago

Josep C. · Reviewed yaklaşık 1 yıl ago

Steve P. · Reviewed yaklaşık 1 yıl ago

Alejandro R. · Reviewed yaklaşık 1 yıl ago