Derive Insights from BigQuery Data: Challenge Lab avis

Narendra D. · Examiné il y a 6 mois

Riya S. · Examiné il y a 6 mois

Ghony Mutiara S. · Examiné il y a 6 mois

Toji f. · Examiné il y a 6 mois

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.

Jeremy L. · Examiné il y a 6 mois

Ricky M. · Examiné il y a 6 mois

Aditya N. · Examiné il y a 6 mois

Baren B. · Examiné il y a 6 mois

Izzan A. · Examiné il y a 6 mois

Radhika G. · Examiné il y a 6 mois

Giovanni D. · Examiné il y a 6 mois

Perfect!

Gustavo G. · Examiné il y a 6 mois

Oktavia S. · Examiné il y a 6 mois

Muhammad N. · Examiné il y a 6 mois

Rafael d. · Examiné il y a 6 mois

Gung N. · Examiné il y a 6 mois

yash s. · Examiné il y a 6 mois

Arya Baskara C. · Examiné il y a 6 mois

Ishu .. · Examiné il y a 6 mois

Hafiza S. · Examiné il y a 6 mois

Kirana Zea S. · Examiné il y a 6 mois

Orang B. · Examiné il y a 6 mois

Willy R. · Examiné il y a 6 mois

Dita Ary C. · Examiné il y a 6 mois

Mochammad S. · Examiné il y a 6 mois