So there has been a lot of volcano and earthquakes very active over the past couple months. And just today a 5.8 hit off the Oregon coast. I thought it would be a good idea to update my earthquake visuals.
Below is the size of earthquakes over the past two months (April, May and June of 2015). Pretty cool stuff. Email me if you want the file.
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.
Click through the link to see a close up of each country. Crazy, but a great visualization of data!
Infographic creators are : http://www.fixr.com/
I took the Starbuck locations and mapped them out using Tableau. Tableau does a great job mapping them out quickly, I just wish they had other color maps. This gray scale is killing me… If you want the file, just message me and I’ll send it to you.
Here is New York
There is so much bad news about Yelp and their business model. I believe a lot of people will just TWEET their experiences good and bad. So I turned to Plus One social to harvest people tweeting about steaks in the New York area using a radius search.
Why twitter? Because it gives people instant satisfaction when it comes to posting about how much they like or dislike something. Much easier than logging into Yelp and posting a review. Why waste the time right? I found this cluster of posts right here.
When I drill down, that is Tre Dici Steak house. A few very positive comments about their food and atmosphere. This took all of 1 minute to do.
This is WHY cooler and most trusting way of finding your best steak house. Give it a shot. Download Plus One and try it for yourself!
With the riots that have been happing in Baltimore, I thought it would be interesting to use Plus One social’s radius social search. I put in the lat/long of Baltimore with a 10 mile radius search and I’m totally amazed at the results! Just look at all that location data on tweets above.
I took the data into Excel’s Power Map feature so you could see the heat blobs. Power Map represents the hot areas very well.
Then I took it over to Tableau so you could see the locations of the tweets better. Not as colorful as PlusOneSocial.com or Power Map, but it still gets the point across.
I did all this in under 15 minutes using Plus One and all these self-serve BI tools. Try it yourself.
I’ve been pulling social data using Plus One and harvesting data on popular sicknesses (english only). I have pulled over 1 million tweets which is pretty amazing in its own right. I plotted on a map color coded by sickness. Pretty crazy when you look at the density in the United States.
As you can see, most people are talking about the “flu”, but it is interesting to see a lot of chatter about the “superbug” and “measles” too.
This chart show you the sickness I’m tracking by month along with the number of tweets. You can see the spikes in the flu, measles and superbug very easily.
April had quite a peak, but it looks like the flu bug is trending down now that weather is getting a bit warmer.
I do admit, the more I use Tableau, the more I have been enjoying it for my instant analysis. I’m using over 1 million tweets and related data and Tableau is just powering through it. Nice.
Click here to download Tableau and Plus One.