๐Ÿ˜ฑ Facebook and Data ๐Ÿ˜ฑ

These two words in the same sentence sound quite scary, I know… However, if you have a Facebook profile, visualizing data based on your social media presence is easy.

I am not going to talk about ๐Ÿ‘†

or any other ways to influence others. Today is all about exploring data from our Facebook profile and having some fun with the data.

Speaking of data from Facebook. It is actually pretty simple to export our profile information from Facebook – and this is what we are going to use today in Power BI.

Watch the video below ๐Ÿ‘‡ and scroll down to find downloadable materials and answers to those questions asked in the video.



Q1: Custom Calendar table ๐Ÿ“† and Emoji table (๐Ÿ‘, ๐Ÿ’–, etc) are available in the materials you can download. Feel free to check out those files.

Q2: Piece of M code to transform JSON timeformat to regular date/time field – =datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [JSON timestamp field])

Q3: To personalize this report (ie import your data) follow these steps:

  1. Click on Transform Data
  2. For each query go to Advanced Editor
  3. In the first line of code change the folder location where you saved your data

Subscribe below ๐Ÿ‘‡ to get full access to BI-Lingual Analytics Materials

๐Ÿ’ฐ It’s free ๐Ÿ’ฐ


* indicates required

๐Ÿ™Thanks for watching and if you liked this video please hit the ๐Ÿ‘ button.

๐Ÿ“ข Also be sure to subscribe to the channel so you never miss a new video.

Categories: Visualisation


Leave a Reply

Your email address will not be published. Required fields are marked *