Como analisar seu conjunto de dados de comércio eletrônico com SQL no Google BigQuery avaliações

Florencia M. · Revisado há about 1 year

Abhishek K. · Revisado há about 1 year

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. · Revisado há about 1 year

Easy, clear and fast

Antonio D. · Revisado há about 1 year

Kiran B. · Revisado há about 1 year

Théo H. · Revisado há about 1 year

Gesiane D. · Revisado há about 1 year

Antonio L. · Revisado há about 1 year

Thomas C. · Revisado há about 1 year

Dillibabu P. · Revisado há about 1 year

Karan R. · Revisado há about 1 year

URAIRAT J. · Revisado há about 1 year

Liliya C. · Revisado há about 1 year

Vijay P. · Revisado há about 1 year

Faith M. · Revisado há about 1 year

Jordan V. · Revisado há about 1 year

Leon Victor M. · Revisado há about 1 year

Polina P. · Revisado há about 1 year

Marcos C. · Revisado há about 1 year

Nicolas M. · Revisado há about 1 year

Samuel H. · Revisado há about 1 year

3

Adi I. · Revisado há about 1 year

Christian M. · Revisado há about 1 year

Josep C. · Revisado há about 1 year

Steve P. · Revisado há about 1 year