You can see that the words вЂњforвЂќ and вЂњBestвЂќ occurred in the largest number of review titles as they appear as they are bigger and bolder than any of the other words. In the output, you will see the following. The вЂњreviews.titleвЂќ column contains titles of text reviews in the dataset. In your visualisations panel, click the вЂњ Word CloudвЂќ visual icon.Дrag and drop the вЂњreviews.titleвЂќ column from the dataset into the вЂњCategoryвЂќ data field.

You will see your data displayed, as below, including the column names from your dataset.Д¬lick the вЂњ LoadвЂќ button to load the dataset. In your Power BI dashboard, click the вЂњ Get dataвЂќ option from the top menu and then select the вЂњ Text/CSVвЂќ option from the dropdown list.Д«rowse to your downloaded CSV file and open it. The dataset contains Amazon reviews in the form of texts for various products along with other information such as integer rating (from 1 to 5) etc.Дownload the CSV file for the dataset from the above link. The dataset we will be using can be downloaded from Kaggle. LetвЂ™s import a dataset to create a word cloud. Once Power BI has downloaded the Word Cloud visual it will appear in the Visualizations pane as shown below: You will see the вЂњ Word CloudвЂќ visual developed by Microsoft Corporation appear. The Power BI marketplace for visuals will open. To do this, go to the Power BI dashboard in Power BI desktop and then click on three dots just below the list of icons for different visualizations you can use. To access it, you need to import the word cloud visual from MicrosoftвЂ™s online marketplace. Importing The Word Cloud Visual In Power BIД«y default, Power BI doesnвЂ™t contain the word cloud visualization, it is a custom visual. Just as a Gantt chart is great for projects and a decomposition tree is great for root cause analysis. Including a word cloud visual in a Power BI dashboard is a great way to summarise data for people. Word clouds are extremely fast to plot and pleasing to the eye and so useful for presentations.A word cloud is an excellent way to visualise text insights to an audience with no technical knowledge.A word cloud of product names from a product sales dataset can reveal a relative comparison of the products with the highest number of sales.Plotting a word cloud of positive or negative customer reviews to see what the common words used are when customers do or donвЂ™t like your product.For more details, we have written an on Power BI licences.ДЄ word cloud is commonly used in text analysis to get a very high-level overview of the vocabulary using in a text.Д®xamples of how they can be used to include: For very advanced text analysis you still need to use these tools as Power BI can not match their capabilities unless you have an enterprise licence. Historically if you wanted this type of text analysis you have to use advanced text analytics libraries such as Microsoft Azure Text Analytics, or IBM Watson. Words that appear more frequently appear in larger, bolder text. The sizes of the words in a word cloud usually depends on how often that word occurs in the chosen text. Importing The Word Cloud Visual In Power BIДЄ word cloud is a diagram that displays a collection of words in various sizes, colours, and orientations.

How to create word cloud in powerpoint