[MUSIC PLAYING]
SPEAKER: Now let's do some
analysis using Sheets Charts.
To get started with Charts,
I'll click on the Charts button
at the top of the
Connected Sheets preview.
Let's now insert the
chart on a new sheet.
Here, I see my chart
editor, and I can
get started building my chart.
First, I'd like to see what
forms of payment people
are using for their rides.
I can choose whatever
chart type I like.
In this case, I'd like
to see a pie chart.
So let me select that.
Then on the right, I can see the
various columns in my dataset.
I can drag them over into
the different inputs.
So let's drag Payment
Type over into Label,
and then drag Fare
over into Value.
Let's turn Sum into Count,
and then let's click Apply.
We have now created this chart
against the 191 million rows
in BigQuery.
And we see here that the
results look like cash beats out
credit cards 60% to 40%.
However, if we instead
change from Count to Sum,
we can weight the
chart by fare amount.
And then we see that cash just
slightly edges credit cards,
implying credit cards have
higher fares on average.
So you can see it's pretty
easy to create a chart.
Again, no SQL required.
Now, let's say I'm curious about
Chicago taxi rides over time.
Let's go back to my preview.
I'll click the
Chart button again,
and let's insert this
chart on another new sheet.
Instead of a pie chart, let's
change it into a line chart.
For my x-axis, I'll drag
over trip_start_timestamp,
and we'll see a new option
here called Group By.
With Group By, I can roll
dates into higher level units.
For example, I have the option
of rolling up by hour, by day
of week, by month, et cetera.
So let's do a rollup
by year and month
to see how taxi revenue
is changing over time.
Let's drag in fare into
Series and then hit Apply.
Now I should get
back a time series
for how taxi ridership
has changed over time.
Interesting.
Looks like overall,
revenue peaked in 2015
and has been on
the decline since.
What if I want to filter
my results to focus
on a particular payment type?
For example, how has mobile
payments changed over time?
To do that, let's add
a filter, choose Text
contains, and then input Mobile.
Now when I hit Apply, I can see
that mobile payments in taxis
is on a steady increase.
[MUSIC PLAYING]
