Speaker 1: So, let's say we have the expectation data of page 1 and page 2. Now, here in the sentence form, what they have to learn from the program, that expectation is given in the text form. So, there are many participants, here 31, here 30. If we remove this, then according to that, it will be 29. So, now let's take this to Power BI. So, here I will import data from the Excel. So, here our data is in sheet 1. So, I select this and here see column 1, column 2 has come. I have to convert this page 1 and page 2 into headers. So, I have to transform from here. Here we have a function, use first row as header. I will select that and then I will close and apply. So, here our data is loading. It has been loaded. So, here we will get to see both these things, page 1 and page 2. Now, we need a word cloud. So, here by default, there is no word cloud in Power BI visualization. So, we will go here and click on get more visual. If you have not signed in, it may ask to sign in you. And here I can search for the word cloud. I will take this Microsoft Corporation word cloud. Then I will add. It is totally free. We don't need to pay any amount to these people. And here you can see this word cloud is there. Let me get this. Now, we don't need this filter. So, I will minimize it. Now, I have to make word cloud of page 1. So, I will tick that. In this way, word cloud is made. Now, we can see like many of the people had mentioned data. Now, data, it was mentioned 12 times. AND also mentioned 17 times. PO2 mentioned like 20 times. But if you look at this, AND, TO, INTO, BE, AS, DO, A, FDs. These are all the words which doesn't make any sense. So, we want to filter them out. So, here in Power BI, we have that facility to exclude the words. So, here if I make a list like this. Here I have made a column like EXCLUDE. So, I will keep that in my file. Then I will be able to drag that column itself here. And that words will be excluded. But let's say what if we don't have that kind of thing. And we want to manually try that out. So, here we have to go to FORMAT YOUR VISUAL. And here we have to expand this stop word. And here by default, let's enable this stop word. So, you can see that now AND is no there. So, it is having a dictionary where they know what are the stop words. So, they have removed that. Now, apart from this default stop word. If you want to remove any of the words from this one. For example, this WAYS. So, WAYS is not going to be useful in any conclusion. Here WAY is there. Here let's say PLM. So, PLM is also like it is hardly having only one frequency. And that is also very very specific to certain situation. So, we don't want that. So, I will write down PLM. And now you see. PLM is removed. After that, I will use let's say WAYS. So, WAYS. And now you can see WAYS is also out. So, what you have to do? You have to give spaces between words. Let's say here there is a MUCH. So, I will write down after giving a space that MUCH. And now you see MUCH is also not there. Here it is SET. So, here SET. Then here it is a POST. REAL WAY AGE KNOW These are all the words which I actually don't want. So, that's why I removed it. And now what I can do is? I can just resize it as per my requirement. So, now it is resized. Apart from this, I can also rotate the text. For example, current rate is 60 degree and all. If I want to make it 90 degree. You can see ALL is there. If I want to make it straight like this. So, I will set minimum and maximum angle as 0. And you will have all readable format. That is how you can rotate it. But this is how you can create word cloud. And you can basically remove the stop words. That is by default when dictionary is there. But apart from that also you can remove the words. So, thank you. Thank you so much for watching this. Thank you. Thank you.