Friday 20 June 2014

Analyzing Facebook Data using Power BI

 1. We will be using Excel 2013 with Power Query installed. From other sources option click 'From Facebook' to import your Facebook data

 2. You will be prompted to enter your Facebook credentials. Then specify an object ('me') and connection (Feeds, comments, likes, posts, notifications, etc.)


3. After you import, you will get a query editor as shown above with different fields (here it shows the pages which i have liked) & related data

 4. We perform some ETL(Extraction, Transformation & Loading) operations to filter out the data which is required

 5. Here we keep only those fields which we are going to work with

 6. Final table will be as shown with different operations applied(refer Applied Steps at extreme right)


7. Give this query editor a name(My Facebook Like here) & click 'Apply & Close' at top left corner


8. You will see a window where it is waiting for data to be loaded from Facebook.com using internet connectivity


9. Total of 147 rows loaded as i have liked this many number of different pages on Facebook


10. After loading is done, click on insert tab and then Power View as shown for analyzing data


11. Select the fields which you want to put it on different axis for analyzing and then select you visualization type(pie chart, bar graph, etc). This view shows different personalities & their like hits on Facebook. Even PM Narendra Modi has likes(approx 19 Million) lesser then hollywood singers :)

 
12. In a similar way you can perform analysis of your friends in your Facebook list by selecting 'Friends'

 13. This view shows analysis for count of number of Facebook friends with their same name greater then or equals to 5

14. This last view shows analysis of my 'Feeds' from the date I started using Facebook i.e. status updates, links, photo updates, videos, etc on my Facebook wall

      Thank you !!!

4 comments:

  1. Really helpful ,Thanks Mr.Ashish -Dhanesh

    ReplyDelete
  2. Thnx 4 sharing bro... awesum !!!

    ReplyDelete
  3. thnx 4 sharing info bro... awesum !!!

    ReplyDelete
  4. Will there be any data which says Likes based on geographical location? Sorry if this question is a dumb one

    ReplyDelete