So let's get started with building up our report.
So this is the Excel sheet which we will be using in this small part of our project of ours.
This is our main table consisting of all the required columns and there are two more times in here.
This consists of some image you are at which I'll be explaining you later on as we proceed.
And this is for this and demand analysis which I'll also tell you in the lead or the Dodi's.
OK.
So let's start building our board with some of the visuals.
So first of all this is our day but I wonder how important that they are.
So for us we just see him it looks like.
So this is our day of the people which I've just shown you in the next.
Now this table looks pretty good but the other tabs just like this.
As you can see the main headers are in the first row.
So we need to move them up so far that I have to just click here and use them.
As for Stroh's the same thing goes with this as well.
Just use them as first choice and those also later on I will be needing the ear of all this order.
As you can see the order rates are in the month the date format.
So I will be needing the ears so I will just ear out.
Right now only the four that I go to transform and from that I will go to bed and I can just click on
the ear to dig the ear values out.
But before that the good thing will be to make a duplicate of this column and now I will rename this
as you.
So now I can just dig the ear of the values out.
Now I have all the ears.
So let's just close and apply it and quickly add some Jarts in hardboard.
So first will it be.
I think good hundred bars and stack bar chart.
So this will consist of our sales values with the our product name and our size.
Here we go.
So this right here shows the deal size of our products.
Okay.
So next we will add bottom line Jard
and this one here which is also called the line and clustered column chart.
Now we will be analyzing our sales data along with the quantities order over the period of years to
put CVS in the column the quantity in line and our values in our shared access just like this
you know we go so that's why I have a spitted the either way or from the it just so that we can analyze
our data.
Over year.
The date values or having the data off day by day so that one we be pretty much dead helpful in this
scenario.
So let's start out toward visual which will be scatter chart scattered Jarvi top places that this will
help us to visualize our season and find the data along the ear so of which we can also play using complex.
So let me show you how.
Let me zoom right now we will add our sales data and quantity that in the x and y axis respectively.
Now we will add our product or you know in the details and next will be our status.
The legend and finally the year in the play X is just like OK.
So here we go so the good thing about this is we have this status which is of different colors light
colors of light blue color is of this sort.
How much products we have shipped to when we will play this.
It will show you the amount of leadership over the years.
You can see in the 16 and 17.
Amount of products have been shipped so our sales have increased over the years is building.
We are visually effectively can be seen right from the start.
OK so this was our with places.
And now let's one more another chart which I have imported from the marketplace.
It is called drill down do not chart.
You can click onto the ellipsis and click on import from MARKETPLACE.
I have done this so I'll click here.
Just like this.
And of now I will be.
This is called Verdon because we can actually drill down in this particular donut jar and let me show
you how.
So I will add my product name and I will be visiting the deal size.
OK.
Do we go the category and the values the size will be in the venues.
So we have on the count of this say so this is this quite really not doesn't make sense because we have
put the values in the different fields what we need to do is we need that you say is in the category
2 hour deals will be in the IT and the product names will be in the venues.
And now to visualizes that presume that we will make it the count of the size just like that.
So this will show us that 49 percent of our lives have been of the medium size and our large size which
is of having more expensive sales are off around 5.6 and our smaller the size of 45 by 4 percent.
Now how to drill down and start for that Suppose I have now decided I want to know which types of products
are there in particular the size of medium small and large.
So I will put my product code in that category like here.
So now this chart is noble.
All I could do is click on medium and this shows that types of products.
So I have put the product or with doesn't really make sense I have to use this product line just like
this.
OK so now when I click on medium the show is done that my classic cars toys which is 28 percent venues.
They are using the medium size so this is the area where I'm having the maximum profit maximum use in
the small so our maximum Deicide having that classic car but also with big cars.
So there are lots of deals in that area and here in the small Again classic cars and vintage cars.
This is a good way to drill down we can further add more here in the categories just like that.
So now when I add currently here we can further drill down here.
So now suppose in the medium size I want to see classic cars are used and or before the end which countries.
So when we click here it will again there are now.
There we go.
We'll be able to find out that the USA is the country which is where this type of our boys up before
them.
So USA has been in France where there are many more other countries there.
So what we're doing there and it will just make our group of those maybe less than zero percent which
they are occupying.
And it will consider them as others.
This is a perfect chart or brilliant on this girdling no longer true.
And when we want to go in the first step.
We just have to be in the middle.
Just like that.
So this is how you do you can do it don't I.
So not to mention we can break down a third or three or other charts by clicking here just like this
so you can see they are dead.
Now we want to see the classic cars that are further highlighted these venues.
Medium sized So this is quite a bit of a feature rich visuals too in the next lecture.
I will add a lot of BGR is to get some more visuals.
And after that we will be learning some pretty good stuff related to combating this sales this year
versus last year's sales and how to do the sentiment analysis that blustering and some good stuff is
coming on with this one.
Just a general on general part of it.
Now we will be going further in next lectures.
Keep on learning and I'll meet you in the next lecture.
Thank you.