Chants of big data & bigger insights


US Election Candidates

Watch our webcast at PASS Excel BI Virtual Chapter

Hi everyone,

If you missed our post here, or want to refresh your skills on Excel, Power Query and analysis of Facebook Page Insights, check out our recorded webcast at PASS Excel BI Virtual Chapter, which walk you through the creation of an Excel report that measures the engagement level of Facebook Pages.

In the demo we compare all US Election Candidates by their storytellers on Facebook.

Enjoy the movie 🙂


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.


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”

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”

Analyze US Election Candidates in Excel and #PowerQuery

As promised here, today we will build a dashboard that analyzes Facebook Insights on US election candidates.

As a teaser, here is a screenshot of a 3D Map you will be able to create when we are done:


Continue reading “Analyze US Election Candidates in Excel and #PowerQuery”

Analyze the Popularity of US Election Candidates with Power BI

Here is the Power BI version of US Election Candidates’ popularity according to their Facebook Page Insights.

To create this report follow my blogs here.



Analyze US Election Candidates in Excel using Facebook Page Insights

If you read my recent blog posts on Facebook Page Insights, by now you may already know how to create a dashboard on Excel or Power BI that compares different brands by their storytellers on Facebook.

In this Excel workbook you can analyze the Facebook pages of the US election candidates, and see who is more popular by time and country.

On my next blog post, I will walk you through the creation of the dashboard, and we will hopefully drill down into some of the interesting insights.

Till then, check out how the democrats are doing vs. the republicans and which candidates beat the rest, well, at least according to the number of people talking about him/her on Facebook.

If you have interesting findings, please share in the comments (For example, on a certain day the democrats reached the same level of Facebook shares as the republicans. Do you know why?) 

Enjoy the analysis.



Blog at

Up ↑