topic Re: Online Sentiment Analysis in Data Stories Gallery

Online Sentiment Analysis

Mykhael — Tue, 09 Aug 2016 23:18:50 GMT

Hello Power BI Community,

========== If you want to play with the report follow this link ===========

https://app.powerbi.com/view?r=eyJrIjoiM2ExYTlkY2EtOGM4Yy00YWRiLTkzYmEtMGYwMmNjNjc0NDUyIiwidCI6ImNmNzM2YWVhLWU4ZGUtNDNiMy1hZmNmLTcxYTg1ODU1NTVmNiIsImMiOjN9

Today I will bring you another Power BI design. This is one of 8 pages about Online Brand Monitoring, Sentiment analysis and Social Media traffic. I am preparing a full tutorial in order to teach you how to create this kind of reports by your own, following very simple rules.

You don't need to know anything about R or another programing language, and you will use only visualizations gave them by default into Power BI Desktop (I never use other kind). The only knowledge you need to have is:

Power Query Skills (Low)
Power Pivot Skills (Medium)
Excel Skills (Medium)
Photoshop (Very Low)
Paint (Very Low)
Power BI Desktop (High)

I invite you to attend this meeting to see how I designed this report, and I will teach the basic rules creating reports in Power BI if you can't assist I will record it and post it in YouTube.

http://community.powerbi.com/t5/Community-Events/April-MSBIWI-Meeting-How-to-Design-Visually-Stunning-Reports-in/m-p/26932#M158

eyJrIjoiM2ExYTlkY2EtOGM4Yy00YWRiLTkzYmEtMGYwMmNjNjc0NDUyIiwidCI6ImNmNzM2YWVhLWU4ZGUtNDNiMy1hZmNmLTcxYTg1ODU1NTVmNiIsImMiOjN9

Re: Online Sentiment Analysis

Niels_NL — Mon, 21 Mar 2016 09:08:37 GMT

Great, this is looking wonderful!

Can't wait to see how you can create such a high-end visualisation on the dashboard. Currently, I just know how to create a dull, basic set of charts and slicers, which looks really unprofessional.

Re: Online Sentiment Analysis

WillT — Thu, 24 Mar 2016 20:47:28 GMT

Hey Miguel - awesome to meet you in the Community lounge at the Summit. This report is fantastic! Sorry I didn't get a chance to plug you in my session (ran out of time!) but I'm really impressed by what you've done. Looking forward to seeing what else people can come up with after being inspired by this.

Re: Online Sentiment Analysis

Mykhael — Thu, 24 Mar 2016 21:00:35 GMT

Hi Will,

Thanks for your feedback, I hope one day we can work together designing and creating solutions. It was a honor to meet a person so talented as you are. Best

Re: Online Sentiment Analysis

leonardmurphy — Tue, 29 Mar 2016 17:03:25 GMT

Out of curiosity, what is it that breaks when Power BI Desktop updates? Is it the positioning/layering that gets thrown off? Or a particular technique you're using that breaks?

I ask because you only use the standard functionality of Power BI Desktop, so I would expect the report to be relatively stable across Power BI Desktop updates.

Re: Online Sentiment Analysis

Mykhael — Wed, 30 Mar 2016 00:07:45 GMT

Re: Online Sentiment Analysis

Niels_NL — Wed, 06 Apr 2016 08:08:14 GMT

I like your work and I'm really interested in the techniques you are using to create such a report, however, if you're turning it into a competition of who gives you the most kudo's, then I'm out.

In the private message you sent me, you said that you want as many people to see your report (understandable), but you also said you want as many people to learn and grow from your work. If you really want people to learn and grow, you can also just publically share your tutorial/dashboard instead of giving it to the guy who gives you the most kudo's.

Sorry, but that's my point of view.

I'll look for a different place to learn new things concerning dashboard visualisations.

~ Niels.

Re: Online Sentiment Analysis

Mykhael — Wed, 06 Apr 2016 14:36:47 GMT

Hello Niels_NL,

I am sorry to offend you, I was planing to change that. Thanks so much for your feedback.

Re: Online Sentiment Analysis

Anonymous — Wed, 27 Apr 2016 18:50:49 GMT

Hello Mykhael

I enjoyed your application, and I need to create a graph that uses infrmando arrows if the value has increased or decreased from one period to another as your application does, I read that you're creating a tutorial teaching you how to create this application, you could help me in creating this chart?

Here is an example of what I'm trying to create:

Re: Online Sentiment Analysis

Mykhael — Thu, 28 Apr 2016 03:30:42 GMT

Hi Anonymous,

I will help you to do what you are looking for, the trick is very simple. I sent you a message, because I need to see part of you tables in order to help you.

Best
Miguel

Re: Online Sentiment Analysis

Anonymous — Thu, 28 Apr 2016 15:11:54 GMT

thank's Mykhael

I'm working with a star model is a BI application is a simple star model, follows a picture of my model, you will need what details?

Re: Online Sentiment Analysis

DAN — Fri, 29 Apr 2016 12:52:19 GMT

just AWESOME work. Thanks :-)

Re: Online Sentiment Analysis

khamus — Fri, 29 Apr 2016 18:23:16 GMT

Hi Miguel, did you upload the youtube video? i was unable to locate it.

thanks!

Re: Online Sentiment Analysis

Mykhael — Sun, 01 May 2016 15:33:43 GMT

Hi khamus,

The video still there. But is not a big deal, I just show ASAP how it looks.

Best

Miguel

Re: Online Sentiment Analysis

vanessa — Thu, 19 May 2016 13:47:42 GMT

Mykhael

Where can I find the video on How to design visually stunning Reports in Power BI?

Re: Online Sentiment Analysis

Mykhael — Mon, 23 May 2016 05:36:49 GMT

Hello vanessa,

The link is this one, https://info.microsoft.com/CO-PowerBI-WBNR-FY16-04Apr-19-Design-Reports-in-PowerBI-Registration.html

Let me know if everything goes well.

Re: Online Sentiment Analysis

vanessa — Mon, 23 May 2016 06:22:43 GMT

Hi Mykhael

I registered on the link you provided, but haven't received any link for the webinar yet.

Re: Online Sentiment Analysis

Mykhael — Mon, 23 May 2016 09:25:41 GMT

No idea why... maybe Sandy can help you. Actually you are not the first one who is telling me the same issue. Maybe Power BI team removed the webinar forever. I don't know. Sandy... Do you know the reason?

Re: Online Sentiment Analysis

Mykhael — Mon, 23 May 2016 09:28:27 GMT

vanessa

Try this one.

http://event.on24.com/eventRegistration/console/EventConsoleNG.jsp?uimode=nextgeneration&eventid=1172550&sessionid=1&username=&partnerref=&format=fhaudio&mobile=false&flashsupportedmobiledevice=false&helpcenter=false&key=7FA0385035517755A336F1FCC62B04D6&text_language_id=en&playerwidth=1000&playerheight=650&overwritelobby=y&eventuserid=140254151&contenttype=A&mediametricsessionid=112900694&mediametricid=1714107&usercd=140254151&mode=launch#

Let me know if it works please

Re: Online Sentiment Analysis

vanessa — Mon, 23 May 2016 11:22:00 GMT

Mykhael

It worked. Thank You.