Hi I'm Darren and in this video we're
gonna have a look at how to create a
report in Google Data Studio now we've
already added our data source
to this particular report and I'm going to
start adding some charts to get some
more information out of my data so first
of all I've got a blank screen here and
down on the right hand side you've got
some layer options that you can have a
look through and change the way that
your canvas size is seen but what I'm
gonna do first of all is going to go to
an "add a chart" and I'm going to select
first of all a table okay and this is
where we then start to see some
different terminology that you may not
be used to before and we've got a date
range so it's already found my timestamp
so it's put that in there it's gone
that's what you need in there and it's
also already for here's a dimension so a
dimension is anything which is
really sort text based but they can also
work as a metric as well and so my
dimension here is the first names but I
can change that let's say two initials
instead and that's then going to show me
just the initials of people and it's
already populated this very first one
here which says I know how to switch on
a computer and open different programs
at the moment it's using as a sum and I
can change that to say an average or I
can count for instance how many people
have said that so let's go for just a
sum on there I can change the name of
this as well so if I don't want it to be
this really long title I'll go for let's
say B1 because it's our first basic
skill and then down here I can then sort
so at the moment it's being sorted by
this particular metric and I want to
actually sort it by the initials field
so I can just type in initials there we
go and I can add that into there and it
will now sort it by descending order or
I can change that to be ascending order
if I wanted to okay so that's to add a
table and I can add more elements to
there so if I wanted to add this one in
here it would then just add another
column for me automatically and if I go
to the style tab over the right-hand
side I can change how that particular
one's gonna look so if I didn't want to
have the numbers down the side I could
just turn that off by clicking row
numbers and now I just have initials the
first thing and the second
thing on there okay now I'm gonna add a
scorecard now a scorecard allows you to
see one particular metric and at the
moment this is showing me I know how to
switch from computer and it's showing me
it's gonna be a sum so it's adding up
all of those numbers that we had in our
form where staff graded themselves
either a 1 or a 4 and it's come up with
618 now that's not going to be very
helpful so let's change that to an
average instead so now I can see an
average for the whole of the college I
can see that it's almost 4 for all the
all the staff members that gave
themselves the grade for that particular
element and again I can change to this
to be B1 as well if I wanted to the name
so it's not got the really long name but
obviously it all depends on your column
titles and you might want to keep those
and then finally what I want to add on
here is a pie chart so I'm going to go
to add pie chart and I'm going to select
a range different things on here so at
the moment it's trying to find what it
thinks I need which is a dimension
around sort of first names what I'm
going to actually select on here is what
they are working towards so level
working towards and that's going to
change on here about what level they're
working towards and again it's looking
at this metric here so I want that to be
exactly the same so level working
towards for my metric as well so I can
then see across my staff who is working
towards what and currently that's
counting distinct but I just want to
count everybody rather than distinct
versions of those and I can then see
about 60% of the College of working
towards intermediate on there and
finally what I want to do is add a
filter control so a filter control
allows you to filter the data that makes
sense for you so I've just added the
filter control and automatically found
the first name now what I want to do is
filter by programme area so I'm
going to select our program area we got
all our staff members to say which
programme area they came from and I'm
going to leave off the metric as well
because I don't want that on there so
I'm just gonna use that dimension there
as programme area I can switch between
what it's going to look like from my
edit mode to actually what it looks like
to view if someone was going to view
this report just at the top
right I'm gonna click view and then I
can then see okay these are all my
particular programme areas and I can
select let's see performing arts media
and music and see what they have then
got and it's all updated so it's now
showing me the average for just this
team that's in this program area I can
see the members of staff which would be
in this programme area and again I can see
what they are for they're working
towards grades as well based on all this
form report so we'll update
automatically depending on the
information that I've got and I can
select back to see the whole college
again if I want to and it automatically
does that update for you I'm gonna go
click back onto edit and you can
obviously add a title on the top here
I'm just going to add this box at the
top and I'm going to use this as a title
page and I'm then going to use a text
box and change what that looks like so
I'm going to change my colour on those
and I'm gonna go for a larger font and
there we go that's our first report obviously
you can play around and make it look
a lot more prettier than I just have in
here and there's lots of different ways
to play around with the style of each of
these boxes of how you want it to look
so for this one I can compact the
numbers to show me three point nine rather
than three point nine four so you can
then decide how many decimal places you
want it to go to finally you might want
to share this with your colleagues or
somebody who wants to view the report
you can have the share option at the top
here you can obvious type in your
colleagues email address and it will
then come up with some options or you
can get a shareable link and it will
then give you an option so I locked it
down to your domain if you're an
education account or I can then say I
would like anybody to who has a link to
this who can then be able to view it and
I can copy that link and then send it to
the people that I'd like to view the
report they then get a unique view of
the report so they won't be able to see
anybody else
editing the report and they can then
also filter it themselves as well we can
expand our report by adding an extra
page over the left-hand side so we can
then add multiple pages which will then
have more information and you can then
keep information across into different
pages as well
so once one filter applies to one
particular thing it can filter and apply
to the whole report rather than just
that single page so that is the basics
of creating a report in Google Data
studio and we'll get you started with
the basics and you can then experiment
and try different options out for
yourself
