skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Robot Wars - Social Media Analysis

    Robot Wars - Social Media Analysis

    09-09-2016 04:59 AM - last edited 11-07-2016 16:13 PM

    Anonymous
    Not applicable
    2306 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Robot Wars - Social Media Analysis

    ‎09-09-2016 04:59 AM

    This Social Media Analysis Report captures data from the official Robot Wars Facebook page.

     

    As a long-standing fan of the UK TV show “Robot Wars”, I was very excited when it came back on the air on BBC Two in the summer of 2016.

     

    Since I am unlikely to ever build a robot myself, I thought the best way I could contribute to this momentous event was by using my expertise in data visualisation. I thought it would be interesting to analyse public reaction to the show. To do this, I decided to track activity on the show’s official Facebook page by capturing the community interactions (Likes, Comments and Shares) that stemmed from official posts made on this page.

     

    Community Interactions

    The first page shows an in-depth analysis of community interactions. This can be filtered by Episode, allowing users to track how the level of interactions changes over time (please note that deselecting all Episodes from the menu will display outcomes for the full period from 1st June 2016).

     

    The right-hand section of this page analyses the sentiment of the comments, using the Text Analytics API available from Microsoft Cognitive Services. This tool analyses text and returns a % score based on the sentiment expressed (i.e. whether it is a positive, negative or neutral reaction).

     

    I need to credit DataChant here for his excellent tutorial on using the Text Analytics API to enable sentiment analysis of social media posts. If you're keen to replicate the kind of analytics I've used in this report,  I strongly recommend reading his blog post.

     

    Just a couple of things to note about this API.

     

    Firstly, it needs to be able to identify sentiment-applicable content in order to derive a rating. Therefore, any comments that have no applicable content (e.g. those which are tagged to a Facebook user with no additional text) are ignored. This is why the number of comments in the chart on the right doesn’t always align with the number shown in the ‘Comments’ metric.

     

    Secondly, the API can only process a maximum of 1,000 comments in a single run. Since there are more than 1,000 comments included in this report, we’ve directed it to process the most recent comments, to ensure that the data reflects all comments made during and after the air dates of the series. Some comments in the pre-season are therefore not analysed for sentiment.

     

    Page Activity

    The second page shows all official posts made on the site, along with a chart that tracks Likes and Comments against these posts over time.

     

    There are three noticeable peaks on the top left chart showing the number of Comments. The first peak, on 23rd June, coincides with the official revealing of the new House Robots. The second, on 13th July, coincides with the official announcement about the air date of the first episode. And the third peak, on 24th July, coincides with the airing of Episode 1.

     

    The number of Likes peaks on the 27th – 28th August, which was the weekend of the Grand Final.

    This report is a simple but effective demonstration of how Microsoft Power BI can be used to derive intelligence from social media data.

     

     

     

     

     

    eyJrIjoiMzc5ZDcxNmMtMzEyZC00NjM0LWI5YzYtODE5YTJlYTcxNWYxIiwidCI6IjMyMTY2YzE2LWJiMDItNGNlZi04OTEyLTFmNTE3MDQ1Yjc5YSIsImMiOjh9

    Preview file
    746 KB
    Robot Wars Data Visualisation.pbix
    Labels:
    • Labels:
    • Entertainment
    • Social Media
    Message 1 of 1
    2,306 Views
    1
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks