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
      • 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
    • Technology Trends 2017 - Rishi Sapra

    Technology Trends 2017 - Rishi Sapra

    01-31-2018 16:40 PM - last edited 10-22-2018 01:52 AM

    rsaprano
    MVP
    16441 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    rsaprano
    rsaprano
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Technology Trends 2017 - Rishi Sapra

    ‎01-31-2018 04:40 PM

    This report shows key technology trends in 2017 through a review of the main themes mentioned across news articles from TechCrunch and VentureBeat.

     

    For a video showing the key insights of the report please see here

     

    Questions Asked for the competition entry

     

    Where did you get the data? Is there anything not explained in the report about the data that the reader should be aware of?

     

    The primary data source is a list of all TechCrunch and VentureBeat articles in 2017 (21k articles in total), a list of which have been published on data.world.

     

    This has been combined with a number of other data sources including search term scores (Google Trends), company stock price data (Alpha Vantage) and Search results (Bing API). A high level overview of how these data sources work together is detailed in the 'Context/Background' tab of the report.

     

    Tell us about one decision you made when building the report, for example why did you use certain colors, visuals or features in Power BI?

     

    I wanted to tell the story by taking the reader on a journey through the data – starting off with a high level timeline storyteller view showing an overview of keywords/companies throughout the year. This then naturally leads onto the overview page showing the actual articles where the reader can see which the most popular keywords/companies/search terms were (by various measures of popularity) and use this to filter down a selection of articles. From this page, the reader can go onto detail for a specific company or search term by use of drill-through pages.

     

    Why were you interested in telling this story? 

     

    I find this kind of insight fascinating- I've spent a fair amount of time using the report to understand what it is showing about technology trends, the major tech giants and how they are portrayed in tech media! I had only read a handful of the 21k articles myself throughout the year and without putting them into Power BI to categorise/analyse them it would be difficult to spot the trends and patterns even amongst those! 

     

    Contents

     

    (i) Timeline Storyteller-An interactive view using the custom visual showing which keywords/companies were the highest mentioned each day in 2017, viewed over time and by company.

     

     

     

     

    (ii) Overview - A dynamic detailed view of the actual articles (displayed using the stripper browser custom visual) which can be filtered by keyword/company/time, along with a dynamic measure slicer.

     

     

    (iii) Company Focus [Stock/Article Analysis] - A playable plot of the stock price each day in 2017 for a given company alongside a view of how many articles were written about the company that day (and how positive those articles were). This is for the reader to understand the potential impact the news articles are having on the stock price.

     

     

    (iv) Company Focus [Time/Search Analysis] – A view of the articles which mention the company over time (including number of articles, Avg. Mention score and Avg. Sentiment Score), the keywords which are associated with the company and related search terms by popularity over time (2016 vs 2017) and region.

     

     

    (iv) Search Term focus - A detailed view of a particular search term (which corresponds to a company/keyword combination) allowing the reader to see how popular that search term (and the associated company/keyword) is over time, as well as seeing actual Bing Search results for that search term.

     

     

     

    Data Set

     

    The original list of articles is published on data.world here

    Please see here for a link to an Excel file containing all the datasets used in the data model.

     

    Note that API Keys have been removed from the PBIX file. If you wish to refresh the data (or view it in the query editor) either provide your own API keys (as parameters) or use the Excel file dataset linked to above to bring in hardcoded values. [N.B: to connect to the dataset file linked to above within Power BI connect to Excel and set the path as 

    https://onedrive.live.com/download?resid=BF5103BF364DD69F%21148292&authkey=AOdpUS-b3y9aAtk&em=x&app=...]

     

    Contact

     

     

    For questions or to provide any feedback on the report please send me a message on this community site or e-mail me at rishi.sapra@altius.co.uk

     

     

    eyJrIjoiNWFmODNkOTItZWNkYy00MDZiLTk2NWYtOWQyNDdlYzQ2YWYxIiwidCI6IjBjNzk5ZDM4LTQ3NjQtNDJiYy1iNGZmLTIzYmViYTljN2ZlMiIsImMiOjh9

    Preview file
    79 KB
    Rishi Sapra 2017 Year InReview Submission Final.pbix
    Labels:
    • Labels:
    • Other
    Message 1 of 5
    16,441 Views
    41
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    ilyas2551
    ilyas2551 Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-08-2022 05:43 PM

    In this visualization, I was very pleased with the beautiful design and interesting topics.

    Message 5 of 5
    1,029 Views
    0
    Reply
    Amardeep100115
    Amardeep100115 Post Prodigy
    Post Prodigy
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-02-2020 01:32 AM

    Hi 

     

    Onedrive link is not working, Please help with sharing data sorce/access to that link 

     

    Thanks

     

    AB
    Message 4 of 5
    8,296 Views
    0
    Reply
    jamesdales
    jamesdales
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-05-2018 03:31 AM

    Looks great Rishi

    Message 3 of 5
    16,026 Views
    0
    Reply
    Datatouille
    Datatouille
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-05-2018 01:35 AM

    Nice one !! Congrats Rishi 🙂

    Message 2 of 5
    16,053 Views
    1
    Reply

    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