In this article you can learn how to install, explore and setup the Template App Facebook Pages – Basic Analysis.
This Template App will soon be available on Microsoft AppSource and can be installed on your Power BI tenant as a Template App (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.
Find the Template App (I will release the link soon) and click Get It Now to install the Template App. 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.
Now you are ready to modify the report and analyze any four pages. But before you do, I wanted to warn you of a specific error in the service when you try to connect via the Connect Data button. There is a workaround, that I will show you in Video #8.
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:
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.