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

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

  1. Cristurean Gabriel May 21, 2015 / 12:35 pm

    Hi Patrick, You remember me I’ve always loved Power Map (GeoFlow at that time)…Could you send me the file so I do a more interactive analysis? Here is an interesting analysis on reported Vaccines Reactions I’ve done using the latest version of the Power BI Designer. Enjoy if you are interested. 🙂  

    Warm regards, Gabriel CristureanCell: (425)894-4483

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s