Chants of big data & bigger insights


Facebook Insights

Analyze Facebook Reactions with Power BI

Earlier this year, Facebook introduced the new reactions Love, Haha, Wow, Sad and Angry.


In my blog post here, I shared with you the implications of the new reactions on your Excel/Power BI reports. The good news: On April this year Facebook released version 2.6 of their Graph API here, which allows you to read all the Facebook reactions from personal, page or app posts.

I have uploaded a Power BI dashboard here with an analysis of the reactions to my Facebook posts.


So here is a step-by-step tutorial for loading your profile post reactions to Power BI (You can perform the same steps with Excel using Power Query add-in in versions 2010 and 2013, or using the Get & Transform section in Data tab of Excel 2016).

Continue reading “Analyze Facebook Reactions with Power BI”


Facebook Insights Bug

If you use Excel and Power BI Facebook connector to read page insights, you should be aware of this recent bug.

Till it gets fixed, you cannot read most of the metrics for your page using Excel and Power BI.
Thank you Tessa from Power BI team for pointing me to this bug, and to you, Borut for discovering it.

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.



Analyze Facebook Insights with Excel

Update 6/6/2016: Due to a Facebook bug here, it is not possible to read private Insights from your page, luckily the public metrics are still available. So this tutorial is still relevant.

Finally!!! I have waited 9 months for this feature to work in Excel (here is the proof). If you have the latest Excel on Office 365 version 16.0.6568.2036, or the latest Power Query Add-In on earlier version of Excel, you can now create amazing Facebook Insights reports and dashboards on Excel.

Recently I have shown you here and here how to create such reports using Power BI Desktop. There are also some Facebook API bugs here and here that are not fixed yet by Facebook, but after waiting 9 months, I will not let minor obstacles to stop me.

In today’s tutorial, I will show you the basic steps to create your first Facebook Insights report. We will assume that you have Facebook permissions to read the Page Insights, but this blog is also relevant for (partially) analyzing pages you don’t own.

Before we begin, here is a short teaser and a proof that this tutorial can help you. The following screenshot shows the number of shares for the official Microsoft Excel facebook page by top countries and date. As both of us don’t own this page, but can retrieve such data for analysis, must be a strong enough incentive to continue reading, right?


Continue reading “Analyze Facebook Insights with Excel”

Create a free website or blog at

Up ↑