Derive Insights from BigQuery Data: Challenge Lab Reviews

Oleh S. · Reviewed about 1 year ago

Aleksandr B. · Reviewed about 1 year ago

Жания Т. · Reviewed about 1 year ago

Andrey G. · Reviewed about 1 year ago

Difficult but interesting...

Viacheslav T. · Reviewed about 1 year ago

Olena P. · Reviewed about 1 year ago

Олег Б. · Reviewed about 1 year ago

Viktor Z. · Reviewed about 1 year ago

1. Task3. There are different ways to complete task with exactly the same results. Nevertheless, lab accepts only nested select with clause "WHERE total_confirmed_cases > 2500" while "HAVING SUM(cumulative_confirmed) > 2500" provides the same result but not accepted by lab. 2. Task5. There is a lot of data for Italy regions in the covid19 table. My understanding is to sum up all of them. Nevertheless, there is one more value in a table which looks like sum of all regions. It is not explained anywhere the structure of data. The mistake is to sum all the data for Italy. 3. It is not clear how to calculate percentage task7, please provide more explanations on that. 4. Task8 it is not clear how to calculate recovery rate, please provide more explanations on that. 5. Having trouble to understand task8 phrase "upto the date May 10, 2020". My understanding it is all days before the date. But lab means exactly that date... 6. Overall impression: it is impossible to compete challenge lab within proposed time frame as there is a lot of topics not covered in related quest. There must be hints what to learn additionally before taking challenge lab.

Oleksii D. · Reviewed about 1 year ago

Sergey K. · Reviewed about 1 year ago

I don`t find how to create a Looker Studio Report wihout using the Explore with Looker Studio option from BigQuery with the parameters required in the task. And time for a large number of queries would need more

Alexey L. · Reviewed about 1 year ago

Dmytro D. · Reviewed about 1 year ago

Dmytro I. · Reviewed about 1 year ago

Viktor H. · Reviewed about 1 year ago

Anton A. · Reviewed about 1 year ago

Tasks have written not clearly

Влад Д. · Reviewed about 1 year ago

Денис С. · Reviewed about 1 year ago

Дмитрий К. · Reviewed about 1 year ago

Radhouane A. · Reviewed about 1 year ago

Last question doesn't count if done everything right without using "Explore with Locker Studio". However, doing all the same operations but with using "Explore with Locker Studio" somehow counts

Yevhenii R. · Reviewed about 1 year ago

The instructions are terrible. Grader expects you to use BETWEEN, country_name or certain types of queries (like not using subqueries) without any instructions. At the same time, it is possible to achieve the same exact result using, say, "country_code" or EXTRACT(HOUR FROM date) and so on. The most difficult part is to guess what the grader wants.

Vitaliy G. · Reviewed about 1 year ago

Павло К. · Reviewed about 1 year ago

Yerkeulankyzy S. · Reviewed about 1 year ago

no explanation on what's missing from the correct solution when submitting own work

Yevhenii R. · Reviewed about 1 year ago

I got different results with the same query during solving task 9. Is it something wrong with BigQuery?

Serhii L. · Reviewed about 1 year ago