Earthquakes are very active all over the world. using @tableau and @msexcel

image

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.

image

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.

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

Using @Tableau and @Starbucks locations to create an interesting geospatial #viz

tableau

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

image

 

Washington DC

image

 

Chicago

image

Want the best steak in New York? Don’t turn to Yelp, turn to Twitter and PlusOneSocial.com

image

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.

image

 

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.

image

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!

Enjoy, Patrick

Mapping the Baltimore Riots with @PlusOneSocial. Instance insights through social media data. plusonesocial.com

image

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.

image

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.

image

I did all this in under 15 minutes using Plus One and all these self-serve BI tools.  Try it yourself.

Enjoy, Patrick

Mapped! The whole world as the flu or a virus. #viz using @Tableau @plusonesocial

image

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.

image

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.

image

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.

image

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.

Enjoy, Patrick

Click here to download Tableau and Plus One.