Facebook Power BI Report

5007 Views
Highlighted
Member
Posts: 54
Registered: ‎01-28-2016

Facebook Power BI Report

[ Edited ]

Facebook is one of the most important channels on social media for to many companies. But handle all the Data that Facebook give you by its API is very hard and sometimes confusing, but in this interactive report I will show you another way to see Facebook Insights using a clear and simple but strong design to help you see if your marketing efforts are going well. This is just one of another 7 reports I designed for Facebook, Twitter, Pinterest, Youtube and Instagram on Power BI. But Colors, Shapes and Charts is just one part of this report, behind you will see Power query data modeling, DAX formulas, relationships etc. I hope you enjoy it.

 

Learn more about this report from the author by watching this video: https://www.youtube.com/watch?v=C2z-hj3J_Bs

 

 PARTICIPANT.PNG

 

Attachment
Frequent Visitor
Posts: 4
Registered: ‎03-28-2016

Re: Facebook Power BI Report

Hey Mykhael

 

great work - how do you get he rounded edges on your charts and cards?

 

Best - tanckc@hotmail.com

Member
Posts: 54
Registered: ‎01-28-2016

Re: Facebook Power BI Report

Hi @tanckc,
The trick is very simple, those rounded squares are just that.... 1. Select shapes from the top panel. 2. Choose the square shape. 3. Select edit from the right panel (the icon is a little yellow pencil) 4. Go to General. 5. Change the rounded number. And that's it. You can change the line and shape color as well. Then you can overlay a chart or card to create the effect... If this answer helped you please give me a like and mark this answer as solution to help others. If you are interested in more tricks like this I invite you to check my posts here into the showcases, or you can email me and I can invite you in one of the conferences I speak about designing Power Bi reports. mmyers@redwaves.onmicrosoft.com
Best
Frequent Visitor
Posts: 3
Registered: ‎03-29-2016

Re: Facebook Power BI Report

Hi Mykhael, congrats on that spectacular FB report!

Iam assuming that you are not using the FB connector on the power bi sources, right? Are you using fb page stats and loading it to a Database? Is it possible using power bi connector to build a report similar to yours?

 

Thanks! 

Member
Posts: 54
Registered: ‎01-28-2016

Re: Facebook Power BI Report

Hello @chonox,

What you are assuming is correct!!! This particular report is connected directly to the Facebook API, and works LIVE, that means the information always change and get refreshed... The API send the data to my server in different tables (I use Azure) and then I use Power BI to manipulate and enhance my queries. About the Facebook connector you are talking about... In my experience is terrible, I don't think you can get a good report from that one... Maybe in the future they will improve it but right now it is very hard to use it.

Best
Frequent Visitor
Posts: 4
Registered: ‎03-28-2016

Re: Facebook Power BI Report

great stuff

 

how do you get everything to line up/align so well....?

for example your page insights table page (in facebook demo)

 

Best

Member
Posts: 54
Registered: ‎01-28-2016

Re: Facebook Power BI Report

Hello @tanckc,

 

I designed this report in November 2015, in that moment I used an horizontal line as reference, but now you can align easyly from the visual tools "Format". Smiley Happy

 

Greetings

Frequent Visitor
Posts: 4
Registered: ‎03-28-2016

Re: Facebook Power BI Report

Great stuff

 

2 questions:

 

1. How did you create the StoryTellers by city bar chart wih labels to the right of the bars? I tried using the legend, but my legend line items do not line up as well as yours to the bars in chart.

 

2. My tooltip on bar chart seems to only show 2 values. The [Vakue] field and only one of my items in the Axis list (the first item) Your tooltip shows items. 

 

thoughts? Thanks again as always for your contributions and quick repsonses. Best

 

 

 

 

Member
Posts: 54
Registered: ‎01-28-2016

Re: Facebook Power BI Report

Hello @tanckc,

 

aswering your questions:

 

1. Select your Horizontal Bar Chart, then go to "Edit" (the yellow pencil located into the right panel), expand Y-Axis, and change the "Position" from left to right.

 

2. Can you show me a screenshot to understand quite better what you are talking about?

 

Sorry to replied you until now. Best

Frequent Visitor
Posts: 12
Registered: ‎10-29-2015

Re: Facebook Power BI Report

Hi Mykhael, I was fortunate to attend your demonstration on the webinar 'How to Design Visually Stunning Reports in Power BI' on Tuesday. I must say I am impressed with your work! I noticed that you seemed to be using links within a report using objects in the left-hand menu -

2016-04-21_16-52-35.png

 

if so; could you describe how you would relate the menu to the report-sheets?

 

 

Thanks and kudos to you! Smiley Happy