Facebook Dashboard – Analyze ANY Two Pages in Excel

Analyze and compare the performance of your brand and/or any competitor on Facebook, or just use this report for learning purposes. This is a great workbook to learn Power Query and Power Pivot in Excel.

You can easily modify this Excel workbook to analyze ANY two Facebook pages. You don’t need to be the page administrator – Just pick any page you wish to analyze (More instructions below).

Analyze ANY two Facebook pages in Excel

Instructions

Minimal Excel Requirements: Excel 2013 Pro Plus or Standalone with Power Query Add-In installed, or Excel 2016 Standalone or Pro Plus, or Office 365 E3 or E5.

Download the Excel workbook. Click Refresh All in Data tab, and login to Facebook to approve Excel to connect to Facebook with your account (Learn more here). Once the refresh will finish, you can see how Microsoft Power BI Facebook Page is performing in comparison to Tableau’s.

How to analyze ANY other Facebook pages

Select the Pages worksheet and change the highlighted First Page and Second Page cells, with the actual Facebook page objects you would like to analyze.

Click Refresh All in Data tab, and wait for the refresh to complete.

Here is a screenshot of the first worksheet. It contains the following 8 PivotCharts that compare between the two pages:

  1. Annual Number of Posts by Page over time
  2. Annual Number of Shares by Page over time
  3. Monthly Number of Posts by Page (Current Year)
  4. Monthly Number of Shares by Page (Current Year)
  5. Monthly Average of Shares per Post
  6. Monthly Average of Shares per Fan
  7. Monthly Average of Posts by Hour of Day
  8. Monthly Average of shares by Hour of Day

Analyze ANY two Facebook pages in Excel

The Posts worksheet will be loaded with the actual posts.

The Excel workbook includes Get & Transform (Power Query) queries that connect to Facebook to extract all posts, and additional information per page.

The Facebook data is loaded to Excel Data Model (Power Pivot). If you are a Power Pivot practitioner, you can extend this report, and add new measures and calculated columns.