Hello there.
So we have learned a lot so far in power VI that's all.
So this particular project is basically to help you gain more confidence with all the visuals and data
using power.
Along with a very important feature that is bookmarking so and by the end of this project we will be
where we will be able to make the most out of the bookmarking feature we have.
So we have this particular data of Google Analytics of our party will have ever said we basically this
is my web site which I use to run.
So I have this Bubu and on it is the office.
So I have begun these are done Xserve shoes so you will have full access to this data.
This dude is pretty interesting to work with.
So you get so you will learn a lot from this.
So without waiting are waiting for that let's continue and let's start our work so you can see that
I have a kind of GS background and the design of this particular report.
This particular part here is I made it for the buttons which I will be putting using the bookmarking
feature and this particular is our main area very really putting our visuals so we are using bookmarking
to use them as and so we will be having multiple pages up here and we will be putting buttons right
there too so that we can click on any particular button and we can directly jump onto that particular
page.
So they believe very interesting to see how that works.
So first let's add some visuals quickly here too I have already added some cards here like the balance
of my website.
My sessions average of this position and I did slice earlier.
Now let's add some visuals quickly.
I have imported some of the custom visuals here from MARKETPLACE.
These are the visuals we will be using in this particular report.
So let's start building our report.
Firstly we will be building.
Let's start with our very down dollar chart
which will consist of.
So here are our neighbors.
We will be adding users and user type
2.
This will take a couple of seconds to load the next particular reason should be.
Let's dig our column chart here.
It's a clustered column chart and we really are taking it and our sessions to so suppose we want to
see our number of sessions with the number of times that users have visited in our website or on weekdays.
So we will just simply remove the ear or the quarter and the day.
So we'll be having this by month device.
Now I suppose you could do the same for the weekdays.
We can have it by using the day Harkin we can just use them.
So this will require daver device.
So now let's use this particular column chart for the day so I have already taken this for the week
days.
I'll put simply put it on the Xs So here is my v.
My column chart on the basis of this.
I do the formatting later on.
You can see that final report at last.
We will be skipping the formatting part for Farnol because we will be seeing the important part part
of it before then.
So the next thing we will do is do a comparison.
So for example is on the chart which is quite useful I suppose to take the corner or narrow chart and
Suppose we want to compare our current users which keep on visiting our website and the new users who
have visited our website.
So let's down the users and new users based on the business of social networks so from which social
platform they have come in our website.
There we go.
Let me zoom it up to date on the particular social networks.
These are the users and these are the new you are so out of 50 to 55 40 125 are the new users who have
redirector the words our website from Facebook to does not search is particularly that is not available
here.
So we will be just removing that part.
So this looks quite good.
Let me make it a bit smaller and this will be a bit bigger.
Okay.
One more visual can be added in.
Let's say we should pick a funnel chart to find which art is also very important to art and let me show
you how this works.
So we really were digging did and sessions so
we did the final chart here
resuming this so that you can see so we're taking this month twice.
So now here is how this works.
First of all let me let me make this one the basis of what you can see on numbers.
So now you can see the numbers here right.
OK.
So this is how it works.
So then on January was the first time my website was launched in January there were four hundred and
fifty three sessions.
All right.
So now on Mars this is a dove.
When we went over this you can see that today what is the percent of us so it is just 53 percent decrease
to the number of visitors have decreased almost 50 times in two months.
Now when we see an apple you can see there's a big growth in the number of users and they have increased
over 300 interrupted person.
So the sessions of 15 per diem to converge in combating this 15:13 to my first month.
You can see there is a big growth of 2:34 person and we will when we we will be comparing this to the
previous one.
There is a big group of six hundred and 27 percent.
So this is how this works.
All right.
So generally March April May June July was up to December to each and.
Everybody here compared to the previous one and compare compared to the first one.
So this biggest Bardia all of us is 70 75 percent of the first bar and 100 percent of the previous one
so or what all this here is shows that are too broad which is 1.1 percent growth from January to December.
That is 4:52 in January to 5:51 in December so that is over 100 percent growth here already.
So this is how we use our final chart.
So this would be a good chart when it comes to our sales data.
All right.
So we will be leaving this blank as of now because we want to add some buttons here which we are doing
later on.
Now quickly add one more page up here.
So just to I be deleting this one just too big all this particular format.
I would be right clicking on it and making duplicate.
All right.
Now I have that duplicate video so I will be deleting all the visuals from your just like that so that
I can have my bed grown as I need it.
Now let's quickly add some more visuals here.
So first I will be adding these are the.
So this particular dream up will consist of number of sessions by the browser type which people are
browsing my website on.
So there we go.
That's nice little visual there.
And another one will be our map.
This here is our audio map of really great custom great visual appeal when we want to see the database
on country right or location wise.
So we're taking country sessions all day and sessions on the colors.
So this particular map Jarve takes a bit of time to learn but once it is loaded it is quite good to
go.
All right.
So in the meantime we will be adding more visual here.
There's another one which will be
in this particular I do not chart.
And in this chart we will be adding the sessions by device category to our device degree and number
of sessions.
So what it shows here is the mobile and tablets are the devices on which my website has been used or
browse.
All right.
So what we can do here is we can make this particular do on our our DON'T.
So I have already had the device.
Now I can also add the operating system here too.
Now this is this can be used as a drill down.
So when I open this in-focus more when I click on this you know when I click on mobile I can see that
I don't know what to say.
Sixty five percent users are Android for 32 percent I use and then others are different operating systems
the rest of them.
So this is another visual.
And finally we'll add a line charge line jarred Shopian has the ability to show forecasting.
So we will be adding a live chat up here.
There we go.
And it was so session by day and two sessions by date I really making it did.
All right.
So you can see there's a big degrees in the numbers.
Number of sessions in this particular couple of quarters maybe just because I've stopped using my website
and I've stopped working on my blogging thing that on this particular website.
So not much been degrees.
So if still if you want to forecast are there dire if you want to forecast we can use this particular
analogy expand on for us and if we can add to this we'll add the forecasting so you can see the upper
bound and lower bones or maximum views can we go up to 55 and lower could be anything and will be zero.
Of course with the Souchong minus 40 so somewhere in between these two.
So this is our forecasting can be forecasting then can we have it in a long chart.
This would if I wish.
As you can see the map is taking quite a bit of time to load.
So now you can see the idea is map visual has loaded go completely and now you can see it is showing
different gradients of colors based on the number of sessions we have the higher use.
So there are many features available in this particular case map.
So to make it customized to customize this all you have to do is click on the three ellipses above.
Click on edit and now you can see the base map location type map theme symbol and anality see her.
So as you've seen I have been in the UK or UK up here.
Or two particular countries I've been there so you can do that as well.
So all it will do is just click on pins as you can see two of them are already principal.
I want the United States
to go.
So when you click this you can all you can see the been taken up here just as the Google map shows.
So you can add as many pins up as you want.
You can read maps style up here by using a map team of either color type or one location only.
Another weird Bucci in the map.
Teams are using their dog Cregan was light green green was on street maps and different kinds of maps
out up here.
So there are a lot of things you can do in this particular idea is map.
So just try them out.
And as of now I think this looks quite good for our report.
So we'll be continuing this in the next lecture and then keep learning.
Thank you.