Iron in Grisby video.
We're going to discuss in an addict stop in W..
So Daddy provides us with an analytic stop, which is just adjusting to the tab, which you see in this
stub.
You get a set of functions which can be directly applied to your graphs.
You get an option.
You get three types of analytical functions.
One is the functions which somebody is your data.
Can you get the various models school of your data and then you get some custom functions.
So these custom functions, all the fence line, the band on distribution band and box for dog events,
which we have discussed in these videos off the fence lines.
If you have to go to these functions, you have to go through the defense lines video, which I have
made.
Apart from that, these tools, if we discuss about this summarize set up.
And the key functions are the ones which are applied on majors.
And they basically find out through a bit of the constant line.
That is, if there is a realisation that you would like to see the X and Y coordinate values of that
line of a particular point in which validation you can see that using constant line, then the average
then gives you the average value on this radiation.
And then the median with gorditas box brought on the borders.
We'll all be seeing these and then we to see the various kinds of models available in W.
So first of all, let's discuss the function of magenta available in summaries.
And then we'll discuss each of these models without much ado next to a W.
Before moving to a new book.
Let me give you a brief food description of what these some of these functions do.
And basically, if we talk about the analytic stuff that provides a set of predefined functions in analytic
steps for performing a few, then it excludes the tasks within D.W. through one of them is summarize.
So some race consists of a set of functions available in Dublin that will help us in the aggregation
of data.
Basically, if you've got some continuous variable division variables, you've got data points in your
visualization.
Now, if you want to know, the values corresponding to Dr Datapoint means the x axis value, y axis
value or the average to align to the total corresponding columns that you can easily be using this summarize
function.
This is quite similar to DISSEMINATE, as we had discussed enough previously, were on the aggregation
of data.
So since we had already discussed these in the organization, videos will be normally discussing this
on base.
But we stayed away.
Come into the model.
If you guys want to know, I'll give you one example of somebody in this.
Then you can check out the other ones, because they are quite similar to the aggregation functions
we had disposed to in the education video.
So without much ado, let's move to my new rule book and let's see how to perform how to perform summarization
data.
So what if I have got this same summarise sheet and I would like to over here, here the relationship
between the profits and sales?
And then what if I see this one value, if I would like to see.
Thinking that what these three points.
One representing the furniture and the proper densities and by this category then offers a place the
proper density to say food generated by his office, a place on the daily technology.
People have often unseen images like this back.
Now, if I want to check you, somebody is to function on this date, I can do that.
First of all, I if I would like to see a constant line, if I would like to see these constant forming
first observation, I just double click on the constant line and I'll get this line.
So basically this line is it if it's anything a constant line means for this to value, I'm getting
the well, I'm getting my X accident y axis value since Florida Category 84 nature.
My profit was one eight four five one and my sales were around seventy five for Bustillo.
So here I see I'm getting these two constant lines.
One constant line is starting now the profit for office supplies and this constant line is getting out.
So is this constant line is getting out of the US.
My sales for office of late and this is cutting out my profit for furniture.
So basically this constant line, what it does is it goes straight line, either vertically or is only
at the level where you get the first observation.
So if I spoke about the profit axis, the first to a value on the profit axis was this one.
So the line got projected from this point to my appropriate axis.
And where when I talk about these sales axis, you will see that.
First of all, this point, this coming and boom, I see to Texas and then to this point.
So from the first one, which comes to I say in Texas line, this particular Woodhead, I'm getting
devalues values on these scenes and proper taxes corresponding to the first point.
So on the all to act as if I see the first two point medy minimum profit is this.
And on these same taxes, the first point with the minimum sales is this one.
So Aline's out of projected corresponding to these points on the profit and see the taxes respectively.
So this is what the constant line function does not BTD function of this line.
But before that, we'll have to double this.
So I'll use visualization, let me blow the profit and say it's a gain or what hit, which means I'm
working on now.
I would like to have subcategory values over here.
I'm predicting it use out of my subcategories.
Now, if I would like to see I go to the analysis tab now, I would like to have the average Laine's.
So corresponding to all the subcategories sales and profits, more not the obvious names that were visibility.
If I talk about the profit axis, the average profit across these subcategories of products, is it
sixteen thousand eight hundred forty seven?
So I see a vertical line already on.
If I talk about the average sales across categories such that it is, I see that the average to see
into that on one hundred thirty five point twenty nine.
This is the average sales across subcategories.
So using this average line will help me go vertical and horizontal lines corresponding to the average
value of each of my axis.
So this is what the average line function does.
Similarly, for all those you guys can work on.
I will tell you one or two more.
Because these have already been covered a bit in the aggregation, but remove it.
Now, let me take another example.
Let's take the example of four seeds being shown corresponding boutique activity of products.
Now, if I go to the end, it stop.
I see it go option over here.
The menu mouse.
Would you get this option selected?
Now, if I would like to convert this single table, automatically think to my table for much.
I would like to change it in this way.
OK.
Now if I go toe to toe with him, you will see that the grand total corresponding to my values over
here is a beating.
So this is the way you view didn't use the Google function or what hit it in the big stop.
Now, what have you been willing to do?
Daniel Boone corresponding to eat, too?
Well, you could have done that as well.
How can we do that?
Well, maybe subcategories or we're here now for each subcategory.
Now, this is giving me a grand total if you want to do a Google search for me subcategory.
You can do that as well, using the aggregation functions which are available to India, not just any
girl in India getting euthanasias or we you can see that you would like to see the program or Google
Quantum Renderos.
They aren't showing you at all.
Quantum Grandcolas.
You can see two languages as well.
If I do that, I'll get those values.
Over here.
Indeed, we have one value on this one personally.
If I let you the order data a little over here, I can go over it again.
So now you can see that corresponding to each at all.
I'm getting the grantors.
It's all here.
And God's warning to each column.
I'm getting a glance over here.
So this is how you use the somebody is a section of the analytic stuff.