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 comment

  1. 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