My second Power BI Template App – Facebook Pages – Basic Analysis is out and available on Azure AppSource. In this article you can learn all about it.
UPDATE: Due to an issue in the Facebook connector in Power BI, the Template App is currently only supporting loading pages for which you have Adminstrator rights. Read more here.
To contact me for support questions go here.
This Template App can be installed on your Power BI tenant (Read more about Template Apps here). Make sure you have permissions to install Template App on Power BI and that you have a Power BI Pro license.
To install the Template App, login to your PowerBI.com account and click this link. Follow the steps in this video to explore the Dashboard and Report.
The report analyzes up to four Facebook pages by posts and shares. You will not be able to analyze Facebook comments, likes or other reactions with this template (To buy a solution that analyze comments, likes and reactions and apply sentiment analysis and extraction of key phrases go here).
The next video will show you the key slice & dice experience in the main report page.
In the next video, you can see how to trigger Q&A, ask questions and receive answers via new visualizations in Power BI
The second page of the report includes a Word Cloud visual which allows you to identify popular topics in posts. The size of the font in the Word Cloud is defined by the number of shares. Check out this video to learn how to slice and dice the Word Cloud and navigate to relevant Facebook pages.
To purchase the pbix file and be able to make changes in the queries and model via Power BI Desktop, go here and select the Premium edition.
The third report page analyzes the most effective hour of the day and day of the week.
Before I show you how to connect to any Facebook pages, in this video you will see how you can edit the report. While you will not be able to download the Power BI report file (pbix) from the template app, you can still edit it in the service and share it via the Power BI App with your audience.
To connect your Facebook pages to this template, you will need to edit the Data Source settings. This video will show you how.
Not sure how to edit the parameters to analyze different Facebook pages? This video will show you how. Go to Facebook. Search for the pages you want to analyze and copy and paste their root folder name (aka Facebook object name). Here is how I extracted Power BI and Excel Facebook pages:
Note: Unlike the video above, some public facebook pages don’t have a username. Their Facebook object name is their ID – A long number which can be extracted from the URL. If you follow the instructions in the video above, and your Facebook object name includes a suffix of a dash, followed by a long number, you may better use the long number as the parameter. Otherwise, you may get the following error:
Once you provide the right parameters, you can set up a schedule refresh and trigger a manual refresh. In the following video, I modified my Template App to analyze Tableau, Qlik, Power BI and Excel Facebook pages:
I hope you will like this Template App. Looking forward to hearing from you. Check out the known limitations and workarounds page here, and share your comments below.