Search

DataChant

Chants of big data & bigger insights

Tag

Word Cloud

Presidential Word Cloud in Power BI – Part 2

As promised, today we will continue working on our Presidential Word Cloud that we have started here, and will focus on two important and useful techniques which are not only relevant for Facebook analysis in Power BI:

  1. We will learn how to extract words from textual columns without splitting the column to many columns.
  2. By splitting messages to single words, our Word Cloud visual in Power BI will work better, we will be able to resize it, and drill down from a single word to its original message.

Oh, and the relation to Ghostbusters will be revealed at the end.

To recap our current challenge – In our last tutorial we have created a Word Cloud which is not resizable.

Screenshot_1

To fix this limitation, we will need to create a new column in our query for the individual words, and feed this column to the Word Cloud visual.

Let’s start.

Continue reading “Presidential Word Cloud in Power BI – Part 2”

Advertisements

Presidential Word Cloud in Power BI

One of the visualizations that I really love is tag cloud, or Word Cloud as it is called in Power BI. It usually grabs the viewer’s attention and provokes emotional reactions that can help you to touch your audience. I have used it fervently in key presentations in the past (Here is a great website to create tagclouds for ad hoc presentations), and was eager to find a good excuse to use it, when Power BI announced the Word Cloud custom visual.

So today we will build a Word Cloud 🙂

To make it interesting, I thought it would be cool to continue our Facebook series and build a Power BI report with a Word Count of the Facebook posts of all the US Election Candidates. The tutorial will have two parts. Today we will focus on the first one that builds a quick and dirty word cloud report. To see what you can get after we go through the second part go here and enjoy the finished dashboard on Power BI.

In this tutorial you will learn how to extract your posts from your brand’s Facebook Page and load the words into Power BI (Or Excel, if you are familiar with the Power Query / Get & Transform user interfaces). You will also learn some cool tricks that will help you to extract multiple offsets from Facebook Graph API, and to load multiple pages (using the query function technique).

Continue reading “Presidential Word Cloud in Power BI”

Create a free website or blog at WordPress.com.

Up ↑