Social Media Monitoring & Analytics Report 05-25-2016 10:17 AM

[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

[skaranam]

Hello,

Thanks for sharing the report. This is really cool.

In report number 1, i see there are small donut graphs on the right bottom side and are they quesiton mark symbols inside the donut chart. What is the use of them.

Thanks,

Sai

[Anonymous]

Hi @Mykhael may I ask how you plot user mentions detect by day and hour please?

[alexSPY]

Hi @Mykhael. I'm still new to using Power BI, though I have built several models and reports. I'm trying to understand how you got the navigation arrows for moving through your report? See below.

Thanks for your help, and great reports!

[JazminMarquez]

Hello, When you publish your report automatically the sheets put them as the browser you are pointing. It is something that intervenes powerbi to navigate between the sheets of your report.

Hope u helpfully..

[SanderK]

Hello Mykhael,

This really looks very nice.

Is this Report free to experiment with and downloadable?

If Yes, can you point me to how and where i can retrieve it?

Best regards,

Sander

[csteinberg]

I’d be interested as well in a PBIX file if available...?

[rlkalves]

@Mykhael is possible??

[musicbydannyd]

VERY SLICK!!! Any chance you can share the dektop (.pbix) file? Thanks...

[ankita]

Hi,

Thats a wonderful report. So interactive and such a stunning look. I would be grateful if you can somewhat explain how did you create this especially the left side bar that represents different pages. A little explanation will do.

Regards,

Ankita

[vineeli]

Hi, 

Also interested in knowing how the left side navigator was created.

Thanks, 

Vineeli

[Ashish483501]

Hi @Mykhael. Fantastic report presented here.. Just one question.. When any month is selected in month slicer, it also gets displayed in the top right corner. How did you do that??

[EdEvetts]

HI Mykhael this looks really good, how are you using the left hand filters to bring up different charts?

thanks Ed

[levankup777]

wow. perfect.

Miguel You really friendly and good person    

[Mykhael]

Hello @levankup777,

It is a pleasure to help. 😄

[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

[Anonymous]

did you find out the name of the visual? i am also interested in implementing in my report. 

[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

[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]

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

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

[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. 🙂