Search

DataChant

Chants of big data & bigger insights

Tag

Facebook

How many Facebook friends congrat me on birthdays – Find out with Excel Power Query

I know that this is not one of the most important questions to ask, but inspired by my recent birthday, I am sharing this workbook that answer the following question:

How many Facebook friends congratulate you on your birthdays? Do you increase your popularity over the years, or does age pay its toll, and your old friends feel awkward to congratulate you at this ambivalent day?

If you want to answer this question, download this workbook. Make sure you use Excel 2016, or download this Add-In if you have Excel 2010 or 2013.

Screenshot_10

To learn how to create this report, keep reading.

Continue reading “How many Facebook friends congrat me on birthdays – Find out with Excel Power Query”

Advertisements

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”

Facebook page insights with Power BI

As promised here, today I will walk you through the creation of a powerful brand analysis dashboard with Power BI Desktop which connects to Facebook page insights data.

Before we start, you can see the result here.

Recently, the Power BI team have published a tutorial that analyzes pages on Facebook. While the official tutorial showed you the basics, it didn’t drill down into Facebook page insights, which hold additional crucial data for marketers. To gain more from your Power BI and better analyze your brand, we will tap into Facebook pages’ insight information, and create a dashboard that compares between different brands. Even those you don’t manage 🙂

The dashboard that we will prepare can be accessed here (I wish I could embed it here, but this blog is hosted on wordpress.com, and embedding of Power BI iframe elements is not supported). To download the actual Power BI Desktop file click here.

Here are the main elements we will focus on this tutorial:

  1. Load dynamic country codes (You will see why we need it later)
  2. Import Facebook Insights from Power BI page
  3. Transform the query into a function that can load any brand from Facebook
  4. Combine insights from multiple brands. In our case: Power BI, Tableau & Qlik
  5. Analyze fans by county and brand

So let’s get started 🙂
Continue reading “Facebook page insights with Power BI”

Fans of Power BI vs. Tableau vs. Qlik

Finally, Power Query works with Facebook insights. I will soon blog about this topic in more details. Till then, here is a short glimpse of a dashboard that compares between the number of fans of Power BI versus Tableau & Qlik (I didn’t embed it because my blog is on wordpress.com, and the site doesn’t support yet iframe from powerbi.com).

 

The bottom line – If you are a Power BI fan, go to Power BI page on facebook and click the Like button. Tableau is leading with 95K fans, while Power BI is second with 44K.

Follow my blog to learn more on analyzing facebook page insights with Excel & Power BI.

Update: I have added a Slicer 🙂

Blog at WordPress.com.

Up ↑