Social Media Monitoring & Analytics Report 05-01-2016 08:49 AM - last edited 06-28-2016 15:12 PM

[Mykhael]

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)

eyJrIjoiY2UwNmZkMDItN2Y0My00Mzc4LTk2ODAtZGZlMzY5MjUxZDU0IiwidCI6ImNmNzM2YWVhLWU4ZGUtNDNiMy1hZmNmLTcxYTg1ODU1NTVmNiIsImMiOjN9

[japhilli]

first class work. Thanks for sharing!

[achinm45]

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

[Mykhael]

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.

[abadiu]

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

[Mykhael]

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

[vanessa]

@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?

[abadiu]

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

[Mykhael]

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.

[Mykhael]

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. Hope this helps you.

Best

Mykhael