Read come again.
So so far we have learned some of the very good stuff like sales analysis this year previous and blistering
analysis.
So in this letter we will be learning how to do the sentiment analysis.
So we are having our sales data.
We are having customers here and we need to find out how much of those customers are really happy with
our services.
So for that we have this particular column in our table called Reading which consists of reading from
our customers on the scale of 0 200.
And also we have this table for sentiment which we have taken from Maxell which consisted of sentiment
positive or negative and associated images with it.
So how do you use this.
Right now there is no relationship from sentiment and so is down.
So if you create a relationship first we need to create a calculated column.
Let me show how this works.
All right click on it.
Click on your column last name.
This is in demand and that list is really clear if condition if were being is less than a hundred an
hour rating is greater than let's say so would it be you are reading lies between seventy two hundred
then would call it positive.
OK so this will be a nested IF condition.
We will use another if if our rating is
let's see less than 70 So earlier we have used greater than 70 so we shouldn't make it less than or
equal to 70
and our rating is greater than suppose 40.
So this condition will be 40 to 70 then we will call it neutral routine.
And if both of them are not correct we would call it as negative.
So this is how our formula works.
If our reading is between hundred to someone be positive if not if it is of between 40 to 70 the neutral
or if that is also not true then negative.
So now we can we have this formula click and we will have this column of sentiment analysis.
Let me just quickly put this on the table to let you understand this.
I will add the customer name the product that we have the customer name we.
I will add those two doses which they have succeeded in our business let me make this much more visible
to all guys.
Who
OK we have customer name we have sales no what I need is our sentiment analysis.
You know I'll drag it here.
We have this negative positive news to all of you as our.
That's But our formula do just to make this all clear.
I will quickly put this thing in here just to make sure our inbox right gave so I don't want some of
it.
I just want to read things.
You can see here the 6:56 is neutral 48 is neutral over 70.
This is I want to do is positive positive neutral.
So this thing is really working fine.
We have created a formula.
Now we want to do the sentiment analysis.
So now we have this stay with us and demand.
We can now link them using our the latest All of which we have just created.
Let me expand this.
There we go and create a relationship between them.
There you go.
We have no.
This thing was definitely a negative comment with in-door.
Both of them.
And one thing we do have to make sure before we this that this image column is of the right format for
that.
Just click on the column local modeling and did a degree make this the doctorate degree image you are
in.
That's all true.
Here is how the magic works.
So we have this and do an analysis.
We don't need this.
We will be having a better version of.
Click on sentiment demand and now would image right here.
There we go.
But now we can see if the customer is really happy with us or not.
We again adjust the size of this image
you know from the I think Ben.
But right now let's skip this as it does too.
As you can see this is just a new tool.
This is very happy neutral customer happy customers.
This is a site customer who are negative on that.
So that's all we can really do the sentiment analysis of our customers.
So this is this is a in our stable format.
Now we want to use them I suppose.
I want to see all the happy customers or are all the customers who have given us the negative reviews
together.
So I'll use this declared slicer.
I have I have imported it from the market place where I have this booklet slicer just put it here
with the image in the image.
You're right that and the sentiment here in the degree that we go now we have this good little slice
in here which shows negative neutral and positive.
So I want to see how many of the customers are really not very happy with us or just click on this and
this is our customers which are not pretty much happy with us.
So we can kind of work with them or analyze them why they are not really happy with our services.
So one thing to make sure that this display is not really visible because we have created this area
this year and last year comparison what it is not working with this.
So to us why this why this ad.
What I need to do is I have to work or remove the interaction of my filter with this table for this
I have to click on this will go to Pharmac and click on edit and directions.
Now I just need to click on this non value and Knol when I click on the negative pause or do this will
only affect this value.
This particular table that's how you can do the sentiment analysis.
Of course this is just a rough way of showing it.
You have to do the formatting stuff like making the image size small.
Or you can use your own images from internet which you have but just all of which are freely available
right there and you can do all this sentiment analysis looks pretty good.
So that was all for our sentiment analysis.
I hope you understood.
We have done so much of the analysis work in this project.
In the next lecture I will show you how to use the filters in our report
Well I hope you guys are enjoying the power we are learning.
I would really appreciate if you have an Please go and put your valuable review and feedback for this
course and help this cause to grow.
So thank you again and we'll meet in the next lecture by.