0:02 today we are going to learn how to work
0:06 on looker Studio looker Studio formally
0:08 Google data studio is an online tool for
0:11 converting data into customizable uh
0:15 reports or even into dashboard uh which
0:18 is introduced by Google company in
0:21 2016 it's the working principles are
0:24 similar with powerbi so let's start
0:26 working on it this is the main interface
0:28 of look your studio here we can see the
0:32 templates of uh some dashboards in our
0:34 case uh we going to start from blank
0:37 report let's click it okay in order to
0:39 create a report of course we have to
0:42 show what is the data source or data set
0:43 here we can upload the data from
0:45 different resources such as Google
0:48 analytics Google advertisements bqy or
0:51 even you can upload your CSV files from
0:54 your device uh in our practice work uh
0:57 we're going to upload a data set from
0:59 Google shets if you open up your seven
1:01 practice work here I already provided
1:03 you a data set which looks like this
1:05 this data set in the format of Excel
1:08 file uh however we're going to import
1:10 Google sheet file that's why your task
1:13 is to go to the file and save as Google
1:15 Sheets file on your Google drive when
1:17 you will save it on your Google Drive
1:19 click this Google Sheets after that from
1:22 this list try to find out your own
1:24 document and click the add button one
1:28 more time add button add to report right
1:32 panel side we can see all data from our
1:34 data set let's have a look what kind of
1:37 data set we have so we have a data set about
1:38 about
1:42 consumers uh they orders how they have
1:44 ordered when they have ordered what they
1:47 have ordered like categories like
1:49 Furniture office supplies
1:51 subcategories uh what is the product
1:55 name right when they have Shi this order
1:58 so what was the profit what was the
2:01 sales there are a lot of data
2:05 approximately 500 rows okay so our task
2:08 is to visualize all Excel data in the
2:11 format of this report just have a look
2:14 different Maps different charts also
2:17 cards so first let's start doing from
2:20 the title of our dashboard I'm going to
2:23 delete this one from my template let's
2:26 add the title uh on the top side here we
2:28 have our main toolbox uh which we're
2:31 going to use while filling out our Das
2:34 dashboard let's go to shape select the
2:37 rectangle shape and draw in your area to
2:40 change the color of this rectangle click
2:43 the background color select the one
2:45 color you prefer to use and I highly
2:47 recommend you to use this color on other
2:50 part of your dashboard okay and then
2:53 click the text and name your uh report
2:57 file let's say super
3:01 store sales report
3:04 it's too small let's resize it pixel for
3:08 example 30 pixels color white let's say
3:11 let's move on next now we have to put
3:13 down the card which will illustrate us
3:16 the profit sales and quantity part let's
3:19 go to add the chart part select here
3:23 scorec card and put on inside of your
3:27 dashboard when you will insert some data
3:29 here on the right panel side you have
3:32 some options to manage so basically
3:34 you're going to manage the metrix part
3:37 and dimensions part so first I need a
3:40 profit that's why inside of metrix I'm
3:43 going to find out the profit this
3:47 one okay here we are my next task is to
3:50 compact this number which means round
3:53 the number let's go to inside styling
3:56 here we have a compact numbers TI on
3:58 let's say I would like to apply the
4:01 color which I have used before and let
4:05 me resize it let's say 48
4:09 pixels okay next we have to show The
4:12 Profit has increased or decreased okay
4:14 we have to compare the value based on
4:17 our date okay see the uh the profit has
4:20 increased by 21% according to our
4:23 comparation data in the same way we have
4:25 to illustrate sales and
4:27 quantity okay you have to do the same
4:30 design part you have to do work with the
4:33 styling with setup sections in order to
4:35 save your time I recommend you to copy
4:38 and paste this profit one more time and
4:42 inside of setup change your profit into
4:47 sales okay here we are 2.3 Millions one
4:50 more time crl c contrl v and let's put
4:53 it next to sales and name this profit
4:55 into quantity
4:59 now okay perfect next we have to manage
5:02 our whole dashboard or whole report by
5:04 drop- down list let's say you can just
5:07 manage them by categories by segment or
5:10 even by I don't know subt I don't know
5:13 maybe by states of USA right I'm going
5:16 to select here the add a control select
5:20 dropdown and put it here on my dashboard
5:23 let me reiz a bit by default it says me
5:26 order idid however I would like to
5:30 manage my report by uh category so let's
5:33 go to control field select here the
5:36 category let's go to style let's style
5:41 our drop down text uh let's say 24
5:44 pixels change the background color and
5:48 change the text color good so now if I
5:52 will select only category technology The
5:57 Profit sale datas has also changed let's
6:01 say Only Furniture data has updated too
6:03 okay it means you can anytime select
6:05 only one category which you prefer you
6:06 can change this category into
6:09 subcategories to get more datas okay I'm
6:12 going to tick on all items and continue
6:15 working with my other uh
6:18 charts so next my task is to
6:23 show uh discount by categories so it is
6:26 pie chart let's go back to add a chart
6:29 part let's select the P Donal chart put
6:31 it after to my sales
6:34 card let me resize a
6:37 bit okay by default it shows me only
6:40 three categories technology office
6:42 supplies and Furnitures but I would like
6:44 to change these categories into
6:47 subcategories let's go to Dimension
6:48 select the
6:51 subcategory and next part that I have to
6:54 fix is the metrix part uh my task is to
6:57 illustrate discount not a profit that's
7:00 why let's go to profit and find out here
7:03 the discount rate
7:04 rate
7:08 okay next part we have to style our pie
7:11 chart uh let's say I would like to
7:14 demonstrate only five slices 10 is two
7:16 there are a lot of slices which is
7:18 really complicated to manage so I'm
7:26 slices next I would like to color my pie
7:30 chart based on my design um so let's s h
7:33 the single color and apply the color
7:36 that you're using all time like
7:39 this okay and the last step for this pie
7:42 chart is to give a title let's select a
7:48 text name for example their rate of discount
7:50 discount by
7:58 subcategories okay let's make it
8:08 text uh we have to illustrate what are
8:11 the 10 top states by segment profit we
8:14 have to show here the G chart uh on the
8:16 below side we have to show the table of
8:19 this chart again go to add the chart
8:22 part let's say here chart located next
8:25 to our pie chart let me a little bit
8:30 resize it okay so uh if you insert the
8:34 map it highlights only United States why
8:36 because in our data set you can check
8:39 the country only United States if you
8:42 add here some Asia countries your report
8:45 will highlight also Asia
8:47 countries everything based on your data
8:50 source okay let's say as the dimensions
8:52 I would like to show not only country I
8:55 would like to show the
8:59 cities to see in the closer mode
9:01 uh and also in the metrix part I'm not
9:03 going to show the discount now I would
9:12 it uh if you'd like to add one more
9:14 metric like segment according to your
9:17 task just uh turn on optional metrics
9:20 and add here the segment it's optional
9:22 to do you can also show them on the
9:25 table without mentioning them on your
9:28 map exactly okay so uh how we can add a
9:31 te table now the table should illustrate
9:35 the map table is the another part of our
9:37 map so that's what we have to get here
9:39 the table and if you look carefully your
9:42 table has a progress bar that's why you
9:44 have to select the table with the bar
9:48 like it under your map now as you see on
9:49 the bottom side I don't have enough
9:52 space to add either chart or control
9:55 datas so that's why I need to expand my
9:57 page size to do it we have to go for
10:05 let's scroll it okay now it's good so I
10:07 already have a table let me resize it
10:10 make it bigger so let's have a look it
10:13 consists of State segment and profit
10:15 profit also should illustrate your
10:19 progress bar so here let's say instead
10:22 of subcategory let me illustrate the
10:26 states next has to be segment I need
10:28 another column so which means inside of
10:31 dimension you have to insert one more
10:32 time your
10:36 segment and the third column it will be
10:45 profit and the metric which illustrat
10:47 your bar progress I'm going to mention
10:50 one more time profit according to your
10:52 task it has to be
10:56 profit okay good so now uh just try to
10:59 apply again to your map and to your t
11:02 the same style as you have applied on
11:05 the top part again start working with your
11:25 title okay I think everything is clear
11:27 it's really easy to use you can easily
11:29 manage everything with the help of this
11:31 tool boxes in your setup section on the
11:35 right panel side now your task is to
11:38 finish this dashboard finish your report
11:41 so you have to now create another part
11:43 chart which will illustrate your sales
11:45 by product categories with their
11:47 quantities just have a look here you
11:49 have a subcategories here you have a
11:51 sales and quantity ship mode here you
11:53 have a four ship mode like standard
11:55 class first class second class T sales
11:58 and profit and the last table is about
12:02 top five cities by the sales and Profit
12:05 just illustrate only five
12:07 cities okay this is the way how you can
12:11 easily create your dashboard with the
12:13 help of look your studio even if you
12:16 have a lot of complicated data on your
12:18 Excel file you can easily manage and
12:20 easily illustrate all your data in
12:23 attractive way um when you will finish
12:26 just go to share button so it has to be
12:28 public make sure it's the editor option
12:30 call copy this link and submit your link
12:33 to the model to get your points okay
