Facebook Insights Demo (using QlikView)

Welcome to Facebook Insights demo Purpose Facebook Insights application provides Facebook Page owners and Facebook Platform developers with metrics around their content. This data helps to understand and analyze trends related to user growth, demographics, consumption of content and creation of content. Armed with these insights, Page Owners are better equipped to improve their business with Facebook. Data The Facebook Insights application uses a connector and Facebook API to retrieve data from the Facebook Page. One needs to have administrator Username and Password of the Facebook Page to retrieve data using the Facebook page. For the purpose of demo, we are using data from Facebook page of BSchoolMentors for analysis and permission has been sought from the owners of the page for using the page data for demonstration purpose. The data in the Facebook Insight application is from 1 Aug 2013 to 6 Sep 2013. A word of caution here: given the amount of tables and data that Facebook API provides, it takes considerable amount of time for QlikView to retrieve and load the data. Hence, it is advisable to use Incremental load by creating a .qvd file. Analysis The Dashboard sheet lists out information collected by Facebook and categorized under various tables such as • Page_fans • Page_admin_num_posts_by_type • Page_fans_country • Page_fans_gender_age • Page_view_external_referrals • Page_consumptions_by_consumption_type This information is further qualified by other fields -- Time Period, Value, Title and Count Distribution. Page Owner may deep delve into each of these tables for further detailed analysis. However, the scope of this application we have limited ourselves to just demonstrate the varied amount of data that Facebook collects and makes available through API which can be used by Analytics and BI tools such as QlikView to draw meaningful insights. Conclusion In Conclusion, Facebook Insights application can be used by Facebook Page Owners to get complete picture of not only what is being posted or commented upon their Facebook page but also help in accessing its impact and reach. The application can be further advanced to add Twitter Data and analyze both Twitter and Facebook activity to do Unstructured Data analysis and Sentiment analysis. BSchoolMentor, company that was used in this demonstration can compare their Twitter and Facebook statistics to five other companies in their industry. I hope you have enjoyed Facebook Insights demo. Thank you for taking time to watch this demo. Please also have a look at other demos as well.