Mykhael's avatar
Mykhael
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Online Sentiment Analysis

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

 

 

 

 

Social Media

36 Replies

  • Niels_NL's avatar
    Niels_NL
    Icon for Advocate I rankAdvocate I
    10 years ago

    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.

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago
      Hello Niels_NL,

      I am sorry to offend you, I was planing to change that. Thanks so much for your feedback.
  • WillT's avatar
    WillT
    Icon for Community Admin rankCommunity Admin
    10 years ago

    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.

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago
      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
  • SMsynoptek's avatar
    SMsynoptek
    Frequent Visitor
    7 years ago
    On clicking it says
    You do not have sufficient privileges for this resource or its parent to perform this action.

    Click your browser's Back button to continue.

    Return to my original page
  • Niels_NL's avatar
    Niels_NL
    Icon for Advocate I rankAdvocate I
    10 years ago

    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. 

  • leonardmurphy's avatar
    leonardmurphy
    Icon for Skilled Sharer rankSkilled Sharer
    10 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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: 

     

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago
      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
      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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?

         

         

  • khamus's avatar
    khamus
    Icon for Advocate I rankAdvocate I
    10 years ago

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

     

    thanks!

    • Mykhael's avatar
      Mykhael
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago

      Hi khamus,

       

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

       

      Best

      Miguel

      • vanessa's avatar
        vanessa
        Icon for Post Patron rankPost Patron
        10 years ago

        Mykhael

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

         

         

  • Sohail's avatar
    Sohail
    Icon for Advocate IV rankAdvocate IV
    9 years ago
    Hi, Where can I download the .pbix file? Thanks in advance! Regards Sohail