Explore Public Datasets with Google BigQuery and DataStudio | by Joe T. Santhanavanich | Oct, 2020
You are able to do extra complicated question; for instance, an aggregated abstract of COVID-19 instances as confirmed, loss of life, and recovered; group by the nation degree; order by the variety of confirmed instances; could be queried with the next SQL script:
country_region, SUM(confirmed) as confirmed_sum, SUM(deaths) as deaths_sum, SUM(recovered) as recovered_sum
date = '2020-10-12'
GROUP BY country_region
ORDER BY confirmed_sum desc;
Step 3: Discover the Information with DataStudio
After you fulfill with the question outcome, you’ll be able to visualize and discover with the DataStudio service from Google. You could find this selection on high of the Question outcomes from the BigQuery internet UI.
Within the DataStudio, there’s a vary of knowledge visualization instruments reminiscent of charts, map, and so forth; which you need to use to discover your queried information from the BigQuery.
When you add the information widget to the Information Studio, it is going to robotically visualize the information out of your queried dataset. The instruments are very to make use of and versatile to regulate color or theme (mild or darkish).
Additionally, you’ll be able to simply invite anybody to work collaborate on this information report. Or, get a PDF report. And even get embed report back to your web site.