Learn how to create Pie Charts with data from BigQuery.
- [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.…
Author
Kumaran Ponnambalam
Released
11/14/2018- Setting up Cloud DataLlb for exploratory data analytics
- Segmentation and profiling
- Reading and writing data from BigQuery
- Managing cloud storage buckets
- Creating visualizations of BigQuery data with the GCP Charting API
- Managing Datalab instances
Skill Level Intermediate
Duration
Views
-
Introduction
-
Why EDA on Datalab?1m 2s
-
Data science modules covered2m 11s
-
-
1. Exploration Options in GCP
-
BigQuery2m 32s
-
Datalab2m 14s
-
Data Studio2m 10s
-
Cloud Dataflow2m 17s
-
-
2. Cloud Datalab Basics
-
What is Datalab?1m 3s
-
Setting up the Cloud SDK3m 11s
-
Setting up Datalab3m 3s
-
Managing Datalab2m 12s
-
Using the exercise files1m 12s
-
-
3. Datalab: BigQuery
-
Setting up BigQuery3m 15s
-
BigQuery commands1m 36s
-
Reading data from BigQuery1m 13s
-
Working with DataFrames1m 29s
-
Writing data to BigQuery1m 30s
-
-
4. Datalab: Cloud Storage
-
Listing bucket contents2m 38s
-
Managing buckets1m 18s
-
Writing to buckets1m 26s
-
-
5. Datalab: Visualizations
-
6. EDA with GCP: Use Case
-
Statistics and correlations1m 37s
-
Segmentation and profiling1m 15s
-
7. Managing Datalab
-
Datalab instance management1m 13s
-
Adding new packages1m 8s
-
Managing source code1m 16s
-
Datalab best practices1m 17s
-
-
Conclusion
-
Next steps42s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Pie charts with BigQuery data