Results 1 to 4 of 4

Thread: PowerPivot to Analyze Tweets

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14

    PowerPivot to Analyze Tweets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Thought this was kind of interesting... Microsoft's solution for analyzing tweets.

    It's a shame that they can only pull in a few days though... I'd prefer to see a few months of data personally, but I guess that's a Twitter limitation.

    http://blogs.msdn.com/b/bi/archive/2...r-twitter.aspx
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Hi Ken,

    Yes, this is tool is very interesting and cool and I also think, the limitation may
    be from Twitter :-)

    However, users who are not using an English (US) date and system format on
    their Windows will encounter a problem when updating the tables due to a
    PowerPivot Bug.

    So, these users (like me) may firstly change the system date and time format
    to English (US) before starting Excel and running Twitter Analyzer data Updates.

    Best regards :-)

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Ouch. That's not good!

    I saw the following comment on Twitter this morning regarding this one: "Tried out MS' Analytics for twitter. Cool idea, but takes way too many steps to refresh with new search results. #powerpivot"

    While not specifically an issue with this add-in, I couldn't agree more. We need a VBA interface to kick off automatic refresh.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4

    Post

    Hi Ken...

    We need a VBA interface to kick off automatic refresh.
    Yes, full agree, can't wait for it

    Best regards :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •