Social Media Monitoring & Analytics Report

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

Social Media Monitoring & Analytics Report

[ Edited ]

Hello Community,

 

This month I bring you a new Power BI Report. It is a 100% interactive Power BI for beginers users. I hope @marcr and @JamesMPhillips like Cheetos because this report shows you how powerful can be Power BI when companies like Cheetos uses it as main Social Media Monitoring & Analytic tool, to improve Sales, Product's Quality, Crisis Control and understand the Audience opinion about the Product. If you want to play and see the report in action just click the link.

 

Enjoy it.

 

You can follow me in twitter @myersmiguel

Or by mail if you want to get in touch (mmyers@redwaves.onmicrosoft.com)

 

 

Attachment
Power BI Team
Posts: 5
Registered: ‎06-24-2015

Re: Social Media Monitoring & Analytics Report

first class work. Thanks for sharing!

Member
Posts: 66
Registered: ‎04-21-2016

Re: Social Media Monitoring & Analytics Report

Very Nice Dashboard.

Is the underlying data available for public or is it proprietary ?

 

Please also suggest how can we get free data to mock the one you have presented.

Thanks,

Achin

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

Re: Social Media Monitoring & Analytics Report

hello @achinm45,

 

This data is "Public" (anyone can get access, you don't need any special credential, token or permission). There are many FREE services out there where you can get this information, but if you want to pay, the rates starts from 100 US Dollars to 2,000 per month, all depends how bast (or big) you want the information be collected. Some services only give you mentions per specific social channel, other ones only tweets, hashtags or facebook comments; some of them are flexible and give you the chance to create groups or categories, and they have Sentiment analysis as well. The market is big. But if you use Power BI to create your own dashboards and reports usind the data from any service you choose, you can make rich and interactive the anlysis like never before.

 

Chek this link

http://60secondmarketer.com/blog/2014/03/10/5-best-brand-monitoring-tools-marketers/

 

Let me know if this information helped you.

 

Frequent Visitor
Posts: 2
Registered: ‎05-18-2016

Re: Social Media Monitoring & Analytics Report

Great job!

One question. What type of graph are you using in the sentiment analysis to show User Mentions Detected by day and hours?

Best regards

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

Re: Social Media Monitoring & Analytics Report

Hi @abadiu,

 

How is it going?. I used scatter Charts aplying few filters in them. Remember... I don't use any custom visualization. If you want to see more details about that trick I sugest you to check this webinar (at the end I speak about it).

 

How to Design Visually Stunning Reports in Power BI

 

I hope you like it, but if you need anything else let me know... will be a pleasure to help you.

 

Best

Miguel

Member
Posts: 105
Registered: ‎04-21-2016

Re: Social Media Monitoring & Analytics Report

@Mykhael

How have you created those tabs on the left? like "Discussion Intensity", "Web Sources" etc. Is it a slicer you have used?

Also, this is a Power BI Report and not a dashboard right?

Frequent Visitor
Posts: 2
Registered: ‎05-18-2016

Re: Social Media Monitoring & Analytics Report

Thank you very much Mykhael! Great video, and nice out of the box thinking!

I don't know if here is the right place to ask, but do you know if there is a way in Power Bi to create relantioships between data and photos? I would like to add geographical data to the photos, time of the day, etc and based on my slicer choice to visualise the photos...

 

Best regards

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

Re: Social Media Monitoring & Analytics Report

Hello @vanessa,

 

 

Those tabs are not a slicer, are just shapes and texts together... the idea it was to design a original way to show the page title... like a Website... and I think I did it VERY WELL because everybody thinks are a Menu Panel or a Slicer. Smiley Happy

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

Re: Social Media Monitoring & Analytics Report

Hi @abadiu,

 

Of course is possible to create relationships between data and photos!!! and you can do that in Power BI, the key is "the conector" between those photos and your data, once you have it, you can do wonderfuls. I did that in one of my reports here is the link.

 

http://community.powerbi.com/t5/Power-BI-Showcase/Online-Sentiment-Analysis/m-p/24092#M152

 

as you can see everytime you select a sentiment the face will change as well. Smiley Happy Hope this helps you.

 

Best

Mykhael