From the course: Learning BigQuery

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Geographic points in BigQuery

Geographic points in BigQuery - BigQuery Tutorial

From the course: Learning BigQuery

Geographic points in BigQuery

- [Instructor] Having explored the use of basic visualizations, such as bar charts and line charts, we will now play around with and visualize geographical data. For this, we will create a new table in the loony_university data set, and we will create this out of the contents of a CSV file which we will upload from our file systems. We have covered the steps towards creating such a table earlier on in this course. So I will not delve too much into the details. The source needs to point to Upload. Then we will browse our file systems and navigate over to a file containing geographical information. This housing data CSV file is available in the course materials or can be downloaded from this location on kaggle.com. It contains statistics with regards to homes in various regions in the state of California in the United States. We can choose to open this file. Sure enough, the file format has been automatically set to CSV.…

Contents