From the course: Creating Dashboards in Google Cloud Platform for Small Businesses

Unlock this course with a free trial

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

BigQuery learning: Solution

BigQuery learning: Solution - Google Cloud Platform Tutorial

From the course: Creating Dashboards in Google Cloud Platform for Small Businesses

Start my 1-month free trial Buy for my team

BigQuery learning: Solution

“

(upbeat music) - Let's take a look at my solution. You may have achieved the same result in a different way, so no worries if you see a method that's not exactly how you created your queries. Similar to the first challenge, I imported the data source from the spa survey results into a new BigQuery table in the spa data set. If you haven't done this already, you can click on create table, right next to spa data. Create table from drive. Enter your drive URI, the file format for Google Sheet, and then name the table spa survey responses. You can also add each field name and its data type or choose auto detect under schema. Under advanced options, be sure to skip header rows. So you can change this to one, and click on create table. Now that we have our table, let's create our views. In the first view, we'll create our rating by location view. In the editor, I've written the create view syntax directly into the editor window. We can run this query just as it is with the SQL syntax. That…

Contents