How to Analyze your Facebook Data with Power BI

Update 2015-07-30: Facebook changed their API a few months ago. It is now only possible to connect with Power Query to pages you own.  Power Query must be approved by the page owner, and once completed, the steps below can be followed. Update 2015-11-08: The diagram of the Microsoft BI platform has been updated following…

Facebook Data Analytics with Power BI

Can you analyze social network data in Excel? The answer might surprise you, but yes! The key is Power Query’s Facebook connector! Scenario Now let’s consider an actual scenario! Let’s do the analysis of Microsoft Canada’s Facebook page. The file is available for download below. First let’s look at the post trend Power View sheet….