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.
Well, it’s Friday again and it is always fun to take different datasets and see what we can do with them. This time I found a database of UFO sightings from the National UFO Reporting Center (www.ufocenter.com).
I used Microsoft Excel 2013 and the Power Query add-in to pull in data from the UFO database. I selected the western states because I didn’t want to spend all the time setting up the queries even though it is just a cut and paste of a URL.
Once the data was imported, I could quickly insert a Power Map via Excel. Since I’m dealing with UFO’s, I thought it would be best to create a dark theme.
Let’s remove the Excel shell so we can just look at the map at night.
Let’s drill down a little more into the Seattle area where I live. I live in a city called Sammamish and sure enough, someone right near me reported seeing a UFO!
Let’s pull back and show a heatmap with the density’s of reports. That reflects where the concentrations are.
I’m going to have to pull all the data and map the rest of the United States later. This was pretty insightful.
PS: Email me any questions you may have.
Measuring and analyzing sentiment for social media can be tough. Oh sure, you can pay several thousand dollars a month for one of the big social services providers, but who has that budget? Well, using Microsoft Excel 2013 Power Query and The Azure Marketplace function for sentiment, I was able to apply big budget machine learning algorithms for nearly NOTHING! How did I do it, just follow along.
First, I used PlusOneSocial to pull my topical tweet data. You can use it FREE for under 10,000 tweets. Just type in your keywords and you’re off and running.
I used Microsoft Excel 2013 with Power Query installed to pull data from the PlusOneSocial database. I then used the Azure Marketplace and added the Bing Machine Learning Sentiment function.
Within Power Query, I edited the query and included a custom column to call the Sentiment Score function.
Then I just plotted my results! 1 is Positive, 0 is Neutral and –1 is Negative
So for less than your Starbucks coffee habit for the month, I have a full blown Social Media Analyze platform on my desktop without some annoying sales person calling me, fixed length contracts and spending thousands a dollars a month. And, with Microsoft Power BI, I’m not limited to what someone else thinks I should see.
PS: Contact me if you have questions.