You can now analyze public Facebook groups in Power BI!!!
Purchase one of the two reports below, and gain new insights of any public small to mid-size Facebook group.
Note: The reports support public groups with less than 5000 members.
Here is a live version of the full report, you can explore the different pages, and find the most engaging members on Facebook Global Power BI User Group.
In the main page you can analyze the number of shares, likes and comments over time. The basic version doesn’t analyze likes and comments.
In the second page of the full version you can find the most engaging members (by number of likes they receive, comments and shares), and compare their impact over time.
In the third page of the full version, you can find the most engaged members.
In both versions you can find the most effective hour of day and day of week.
Unzip the file, and open the .pbix file using the latest Power BI Desktop (Minimal version: 2017 July update).
To use the report, you will need to find out the Facebook Group ID. The group ID is a number which can be obtained by navigating to the public group on facebook.com, and viewing the source HTML.
Inside the HTML, search for the text fb://group/ and clopy the number that follows that text. This is the Facebook Group ID.
Open the .pbix report, and click Edit Queries.
In the Queries pane, click Page Object Name, and paste the Facebook Group ID in Current Value. Click Close & Apply.
If this is the first time you are connecting to Facebook using Power BI, follow the sign-in steps with your Facebook account.
That’s it you are ready to go.
Contact me at [email protected], if you have any questions.
Hope you’ll enjoy using this report.