Explore Public Datasets with Google BigQuery and DataStudio | by Joe T. Santhanavanich | Oct, 2020

[ad_1]

SELECT
country_region, SUM(confirmed) as confirmed_sum, SUM(deaths) as deaths_sum, SUM(recovered) as recovered_sum
FROM
`bigquery-public-data.covid19_jhu_csse.abstract`
WHERE
date = '2020-10-12'
GROUP BY country_region
ORDER BY confirmed_sum desc;
Instance, Question Aggregated COVID-19 (JHU-CSSE) Dataset with BigQuery. (by Writer)

Step 3: Discover the Information with DataStudio

Discover information with Information Studio. (by Writer)
Information Studio Visualization Instrument. (by Writer)
Instance chart and map visualization of COVID-19 information within the DataStudio (mild theme). (by Writer)
Instance chart and map visualization of COVID-19 information within the DataStudio (darkish theme). (by Writer)
Sharing DataStudio Report. (by Writer)

[ad_2]

Source link

Write a comment