Exploring an Ecommerce Dataset using SQL in Google BigQuery Reviews

Katarzyna G. · Reviewed about 3 years ago

Instructions to find and access a project are very unclear and don't match current functionality in BigQuery with regards to options to add a dataset/project. This miscommunication unnecessarily wasted limited time allocated to the Lab. Question regarding duplicate records is misleading as the question is actually asking for 'how many records CONTAIN duplicate records' as opposed to the interpreted question of 'How many duplicate records 'TOTAL' exist in all_sessions_raw?' Wrong interpretation led to confusion as to what the question is asking and why the answer is different than expected. Very confused as to the purpose of querying the data (in Task 4) set with this question and answer format. Unsure if this is meant to get someone's feet wet in how they might query answers to sample questions of if the intent is to ask the user to figure out the answer (with little to no documentation on the dataset being explored) and then provide a potential Query to answer the question.

Reuben G. · Reviewed about 3 years ago

Some names on the big query platform where not the same as stated on the training (i.e. the pin project was replaced for star project, which took me a lot of time to figure out)

Felipe V. · Reviewed about 3 years ago

Jules P. · Reviewed about 3 years ago

I had already completed this lab

Ahmad R. · Reviewed about 3 years ago

Jakub B. · Reviewed about 3 years ago

Pins are now stars and the instructions need to be updated, that was confusing starting the lab

Derek C. · Reviewed about 3 years ago

Satisfied

Sathish Kumar S. · Reviewed about 3 years ago

Jennifer L. · Reviewed about 3 years ago

Very comprehensive for the first experience.

Marco Aurélio G. · Reviewed about 3 years ago

Below steps were little challenging. These were not self explanatory... Click + Add Data. Select Pin project > Enter project name. For Project name, enter data-to-insights.

Ravi G. · Reviewed about 3 years ago

Good

Keerthi K. · Reviewed about 3 years ago

Mahfuz A. · Reviewed about 3 years ago

Simon E. · Reviewed about 3 years ago

Madhur K. · Reviewed about 3 years ago

Sritama R. · Reviewed about 3 years ago

I could not find the data-to-insights project, but the team assisted me. Great SQL examples and got a good opportunity to interact with BigQuery editor.

Hector H. · Reviewed about 3 years ago

Srikanth M. · Reviewed about 3 years ago

Vijayan S. · Reviewed about 3 years ago

Steven S. · Reviewed about 3 years ago

Sofiia B. · Reviewed about 3 years ago

Ahmad R. · Reviewed about 3 years ago

Jenny H. · Reviewed about 3 years ago

Jazmine R. · Reviewed about 3 years ago

Nice

Mark C. · Reviewed about 3 years ago