From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Line charts with BigQuery data - Google Cloud Tutorial
From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Line charts with BigQuery data
- [Kumaran] Let me show you how easy it is to create charts using data from the query. We already have campaign data loaded and stored in the BigQuery. We will now create a line graph that shows the number of offers and conversions for campaigns, by date of the campaign. First, we extract the conversion ratio for each offer_date from BigQuery. We do so by creating a named query called campaign_line. This query does a group by of offers and conversions for campaigns for a given offer date. Next, we use the charting command line to do the line chart. We need to indicate the fields for the line chart. The first field is the x-axis. The subsequent fields are multiple y-axis lengths. We provide offer_date, offers, and converts for these parameters. We then specify the named query through the data option. Finally, we specify the height of the chart to be 500 pixels. When this chart is executed, it in turn executes the named query. The data from the named query is then mapped to the chart…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.