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
    • Microsoft 365 + Power BI
    • Dynamics 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
    • Events
    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
    • Data storytelling: Stock market value predictablit...

    Data storytelling: Stock market value predictablity with social media sentiment

    06-21-2018 02:15 AM - last edited 06-21-2018 02:59 AM

    VictorM
    Advocate I
    7875 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    VictorM
    VictorM Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Data storytelling: Stock market value predictablity with social media sentiment

    ‎06-21-2018 02:15 AM
    Summary:
    The story behind of this report is an attempt to answer the "million dollar question": Is it possible to predict the stock market value of a company?" @PauSempere, with the data scientist hat, did the experiment gathering data from different sources:
    - History of the stock market value metrics of the selected tickers (close value, max, min, volume, moving averages, etc..)
    - Financial news (from https://intrinio.com/)
    - Company related Twitter updates
    We used R Server, looking for the best approach to to get the best fit to predict tomorrow’s value and trend.

    But all this was experimental, the main purpose of this report is implement the Power BI features focused to data storytelling. We used the following:
    • Drillthrough
    • Bookmarks
    • Tooltip pages
    • Q&A
    • Insights
    • Actionable images / buttons
    • DAX (calcs, dynamic text)
    • Filters
    • Visibility

     

    How to use it:
    This report is designed to be narrated by a speaker, so you may need few indications to follow the same flow:
    1) The first page is a lading page where you can click on the company image to start the analysis
    2) The company overview page shows a "navigation bar" on the left side where the images will browse to other company (using bookmarks,). Also, there are buttons to change between the charts "Different last closing" and "Social media contributions". Right-clicking on these charts will show the drillthrough options, to get deeper insights
    3) Almost all charts have linked tooltip pages
     

    This report has been used couple of times to present sessions to the community. The most relevant in the Power BI User Group event hosted in Dublin this year, 2018.

     

    Feel free to provide any feedback, it would be apreciated.

     

     

     

    eyJrIjoiZDZmM2FiYjEtNDZkNC00NjU4LTgyMDYtOWY4MzFiMTZmN2E5IiwidCI6IjM1MDY5ZDc0LTE0ODktNDE5NC04MGM3LTNhODEzODVlYWQ1YiIsImMiOjh9

    Preview file
    115 KB
    Labels:
    • Labels:
    • Economics
    • How To
    • Social Media
    Message 1 of 1
    7,875 Views
    13
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • 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

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices