Derive Insights from BigQuery Data: チャレンジラボ のレビュー

D Narendra · 6ヶ月前にレビュー済み

Singla Riya · 6ヶ月前にレビュー済み

Sari Ghony Mutiara · 6ヶ月前にレビュー済み

fushiguro Toji · 6ヶ月前にレビュー済み

This lab is overly-specific in how the problems are addressed. For example, in task 7, it is incorrect to filter WHERE (net_new_cases/previous_day) > 0.10 but it is correct to state WHERE (net_new_cases/previous_day) * 100 > 10.0, which is an equivalent expression. There is also inconsistency in how "cumulative" is used. In task 4, cumulative is summed across days, while in tasks 1, 2, 3 and 5 it is restricted to single days. This shows two differing interpretations - is cumulative for all time forward as a monotonically increasing series, or is cumulative across all entities for a given date, and therefore not monotonically increasing? The introduction of CDGR is a bit cagey because the formula provided doesn't actually work in BQ (the carat is a bitwise indicator, not an exponent) and isn't syntactically valid (unmatched parentheses). We ought to be able to research and find POWER(), and that's on the user ,but I think the explanation is lacking.

Loscheider Jeremy · 6ヶ月前にレビュー済み

M Ridwan Ricky · 6ヶ月前にレビュー済み

Nursaidillah Aditya · 6ヶ月前にレビュー済み

Baruna Harahap Baren · 6ヶ月前にレビュー済み

Abdul Izzan · 6ヶ月前にレビュー済み

Gupta Radhika · 6ヶ月前にレビュー済み

Della Dea Ramos Giovanni · 6ヶ月前にレビュー済み

Perfect!

Gonçalves Dias Gustavo · 6ヶ月前にレビュー済み

Safitri Oktavia · 6ヶ月前にレビュー済み

Nur Rachman Nidhi Suryono Muhammad · 6ヶ月前にレビュー済み

da Costa Rafael · 6ヶ月前にレビュー済み

Nikky Gung · 6ヶ月前にレビュー済み

sharma yash · 6ヶ月前にレビュー済み

Cahyakusuma Arya Baskara · 6ヶ月前にレビュー済み

. Ishu · 6ヶ月前にレビュー済み

Sidqi Hafiza · 6ヶ月前にレビュー済み

Sachdania Mayz Kirana Zea · 6ヶ月前にレビュー済み

Barat Orang · 6ヶ月前にレビュー済み

Rahma Wijaya Willy · 6ヶ月前にレビュー済み

Crystian Dita Ary · 6ヶ月前にレビュー済み

Syaifuddin zuhri Mochammad · 6ヶ月前にレビュー済み