Your Power BI Network on Facebook

Want to surprise your Power BI colleague or friend? Get this Power BI report, and analyze your Power BI network of friends on Facebook. You can even try it on your facebook friends.

Here is the full report. Flip through the different pages to find out many hidden insights on your profile, friend, or stranger.

What is included in the report?

The report was writtend as a variation of the Facebook Page report here. In case you are interested in analying facebook pages rather than users, you can purchase that report.

The report includes 8 pages, including, a full interactive graph diagram of the Facebook friends and their friends, who use Power BI (and approved Power BI as a Facebook app when they connected to Facebook via Power BI or Power Query in Excel).

And you can also analyze the user’s engagement and impact on Facebook.

The Engaged Fans shows the most engaged friends.

And finally, the Globe enables you to explore the posts by their geo-location.

Instructions

Once purchased, download the ZIP file, and extract the .pbit file it to your computer. Ensure you installed the latest Power BI Desktop. Double click on the .pbit file, and when the Power BI template opens, type “me” or a Facebook object id. Refresh the report, and enjoy the results.

If you are interested in a report on your facebook firend, you will need to obtain his/her Facebook object ID – Go to facebook.com find your friend, and open his profile. Next, view the page source in your browser.

In the source of the Facebook page, look for the number after profile_id, and provide it in the template dialog. Note: Some users restricted their profile from prying eyes of Apps. So don’t try it on users such as Marc Zukerberg, who bloced their (whose Facebook object ID is 4).

Hope you’ll enjoy using it.

11 comments

  1. Mohan V Reply

    Hi Gil Raviv.

    I need a small favor from you regarding that usage of Social Network graph.

    I am trying to implement span of control on my data.

    Sample looks as,

    PersNo. Employee Name Supervisor ID
    101562 Mandar Marulkar
    106093 Faheem Kolhar 101562
    109968 Manoj Mone 101562
    112867 Kishor Rahigude 101562
    102741 Mahesh Pathak 106093
    106694 Sandeep Nawal 106093
    109461 Tushar Jadhav 102741
    118063 Surendra Joshi 102741
    119094 Arihant Magdum 118063
    125534 Milind Yeole 118063

    Now when i used the below dax calulated column

    SupervisorName = LOOKUPVALUE(‘HR View'[Employee Name],’HR View'[PersNo],[Supervisor ID])

    then iam able to get the supervisor name, that is only a single value.
    But i would like to get the output as

    if i choose the employee name Milind Yeole from slicer.

    then i should get output as
    Milind yeole, Surendra Joshi, Mahesh Pathak, Faheem Kolhar, Mandara Marulkar names in a single column
    so that i can use that column in a source of this visual.

    Any suggestions please.

    Thanks,
    Mohan V

    • Gil Raviv Post authorReply

      I would create a new table using Power Query with the pairs: Employee and the concatenated comma-separated chain of command from him to his CEO.

  2. Mohan V Reply

    Can you give a sample please..I got an idea what you are saying about..But if you give a little bit of hint…then
    it will be lot easier for me to move further.

    Please

    • Gil Raviv Post authorReply

      Here is a hint:. Create a function “FnGetNext” that returns the Row where the employee ID is equal to the input argument.
      Now repeat the following logic till you finish traversing all the paths: Add a custom column with the formula =FnGetNext([manager]) and expand it. employee in target.employee.

      You can even do it in a recursion or using List.Generate if you know M well. I may share it in the near future as a blog post. Let me know if you want to be the guest author 🙂

  3. Mohan V Reply

    Thanks for the hint Gil.

    But im just newbie to this M, Dax and power bi.

    One thing i can do is, please make this report for me, n i ll pay you.
    I ll share the Sample Data set, and my three main requirements,

    Is it possible?

Leave a Reply