Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team.
Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in Excel 2013! For all the details, including a Quick Start Guide and some details about the Twitter Search Query Syntax, see the “Analytics for Twitter 2013” page on Microsoft TechNet.
The new Twitter Analytics for Excel tool provides a number of improved features, including:
Note that you might run into an installation issue because the Analytics for Twitter 2013 installer expects to find an Office15 folder in your Program Files (x86) directory. If such a folder doesn’t exist (and most likely it doesn’t because it is called Microsoft Office 15 or you have installed the 64bit version of Office), the installation will fail with an error that “Microsoft Office 2013 or greater needs to be installed for this installation to continue.”
This issue is easily fixed. Just create an empty Office15 folder under Program Files (x86). For completeness, here’s the download link for Twitter Analytics for Excel 2013. Happy Tweeting and Analyzing!
This is a really cool app. Love that it is free, but it is worth paying for.
Was just trying to install it, and ran into the problem described above with 64bit Office 2013. Thanks for the quick solution!
I am getting below error during the install
The operating system is not adequate for running Analytics for Twitter 2013
OS - Windows Server 2008 R2
Office 2013 Professional Plus 2013
Thanks! This is awesome.
The twitter analytics ribbon has dissapeared and i can't get it to reappear?????????????
This is a great tool :)
Can we load tweets older than 7 days? can we control the search period?
That's great. Exactly what I've been looking for. Thank you Microsoft.
Has this been looked at as a SharePoint add-in, and if so, what are the licensing implications with Extended Results?
Check out extendedresults.com/.../twitteranalytics. There is a Contact Us link at the bottom of the page to reach Extended Results.
the www.extendedresults.com/.../ertwitterforexcel2013.zip link is a broken link
Download link is broken. Please fix it. Thanks
I love this tool! however powerview analysis didn't show up! really want to figure what's the reason?!
Whoa! I love this tool. I was wondering how to build something like this in Tableau but why bother when all the heavy lifting has been done for me? Sheesh!?! Way to go Microsoft! Now can you do the same for facebook and all the other social media sites? ahhahaha
You're link is unfortunately broken...