😱 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:
- Click on Transform Data
- For each query go to Advanced Editor
- 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 💰
🙏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.