With the Web version of Atlas Insights, you can upload your data from a .CSV or .XLS, you can upload your data and refresh from Google Drive and you can also with one click Copy or download a CSV or Excel version of the data too. That’s right, you can’t do this with other cloud system.
Inline editing is very important when working your data in the cloud. But it is also very important that if you have access to data here and want to take it offline and work with the numbers in Excel you should be able too. Well, with Atlas Insights you can!
It’s your data, not the cloud vendors data…
Founder/CEO of Atlas Insights
Give it a try, we are offering a FREE 3-month Basic subscription through the of January.
I saw a post that Starbucks stopped making a Christmas cup because they didn’t want to offend anyone. So the cup is just RED now. Boring… Anyway, people take to social to either voice they are happy, mad or don’t really care. Here are the analytics.
- 9,796 Tweets harvested and analyzed
- 9,228 unique tweeters, that is a high number with very little retweets
- 18% are happy with the new RED cup
- 21% don’t like just the RED cup
- 61% are neutral, just give me $6.50 peppermint mocha
I used www.PlusOneSocial.com to harvest the tweets and Microsoft Excel to create the sentiment.
I used PowerQuery to pull a list of the S&P 500 companies and mapped them using PowerMaps in Excel. You can see a vast majority of companies are HQ’d in New York. The color codes are by Industry Sector.
Even a few in Europe
If you want a copy of the file, just direct message me and I would be happy to email you the file.
Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized.
Want to create some quick sentiment insights using Microsoft Excel? Download Plus One social harvesting tool. Enter your keywords and harvest your data. Below I’m using a standard for tweeting about stocks.
Once you have your data in Plus One, you can then use our Excel 2013 workbook to refresh your data and create sentiment insights in just minutes! Connect the Bridge database and then go into Excel and Refresh the data.
The workbook has some base charts to get started, but the data is Power Pivot enabled so you can drag and drop your own views.
One of my favorite views is sentiment over time. It maps all the records down to the second and allows you to see a heartbeat of your keywords. Great insights.
Give it a shot!, Patrick
PS. All created with Plus One and Microsoft Excel