Try this with your cloud business intelligence solution. You can’t!

cloudbusinessintelligenceediting.PNG

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…

Enjoy, Patrick
Founder/CEO of Atlas Insights

Give it a try, we are offering a FREE 3-month Basic subscription through the of January.

Sentiment on @Starbucks Red Cup Christmas issues using PlusOneSocial.com and @MSExcel

image

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

image

I used www.PlusOneSocial.com to harvest the tweets and Microsoft Excel to create the sentiment.

Enjoy, Patrick

MAPPED: Great visual where the S&P500 companies are headquarters using @mspowermap #vis

image

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.

Northeast

image

Midwest

image

South

image

Southwest

image

Pacific Northwest

image

Even a few in Europe

image

If you want a copy of the file, just direct message me and I would be happy to email you the file.

Enjoy, Patrick

Creating your own sentiment insights with @PlusOneSocial and @MSExcel on $YELP

yelp

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. 

image

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.

image

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.

image

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.

yelp2

Give it a shot!, Patrick

PS.  All created with Plus One and Microsoft Excel