Chants of big data & bigger insights


March 2016

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”

An update for the brave analysts of Facebook Insights and #PowerQuery

Update: 6/6/2016: This blog post provided a workaround to a Facebook bug which had been recently fixed.

If you tried my last Power BI tutorials here and here, and you are authoring reports that require the extraction of Facebook Page Insights, you may find today’s update useful.

So recently Facebook introduced the new reaction buttons. Unfortunately as it seems, the new features introduced new bugs in Facebook Graph APIs. On my last post I mentioned a bug in the counting of the new reactions (e.g. Love, Sad & Angry). But today I would like to focus on a new painful bug that makes my previous dashboards nonoperational.

The bug here, which was confirmed by Facebook, causes the insights/page_fans_country entry point to return no data (And my gut feeling tells me that there are probably dozens more related bugs).

Luckily, there is a simple workaround for my Facebook dashboards (the workaround is already implemented and is available here. Please don’t download the main file. Scroll down till you see the link at the Update section).  You should note that for some typical Facebook API issue, the data will be limited in its time span, and for certain pages (e.g. Tableau) data will only start showing from a specific date (See the following screenshot).


Continue reading “An update for the brave analysts of Facebook Insights and #PowerQuery”

Create a free website or blog at

Up ↑