From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Pie charts with BigQuery data

Pie charts with BigQuery data - Google Cloud Tutorial

From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics

Start my 1-month free trial

Pie charts with BigQuery data

- [Instructor] In this video, I will show you how to create a pie chart with data from BigQuery. We are going to do a pie chart to show the number of offers by day of the week. We first create a BigQuery named query called WeekDay. We count the number of offers by offer week, based on the offer week column of the campaigns table. We then use the charting APA command to specify a pie chart. We provide two fields. The first field is the segment of the pie. In this case, it is the offer week, which is used to show the pie. The second field is the actual value of the pie. In this the case, it is the number of offers. We also provide a title for the pie chart, and also its height and width. Once we execute the query, the pie chart shows up with the configured fields and dimensions.

Contents