In this article you can learn how to install, explore and setup the Template App Facebook Pages – Basic Analysis.
This Template App is 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.
You can find the Template App on AppSource here. Click Get It Now to install the Template App and 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.
The third report page analyzes the most effective hour of the day and day of the week.
In this video you will see how you can edit the report. You will not be able to download the Power BI report file (pbix) from the template app, but you can still edit it in the service and share it with your audience via the Power BI App.
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.
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.