HUSTING's COOLBI


Leave a comment

U.S. seen adding 230,000 jobs in January

The jobs report came out very positive the other week saying over 230 jobs added in January.  But I don’t think part-time jobs should count… Gallup CEO, Jim Clifton came out and discounted the results right away.  Basically calling the jobs number very misleading.  Good for him.

My previous company did a lot of analytics for Gallup and I trust my numbers than the government….

Looks like Marketwatch is using Microsoft Excel!

Source: http://www.marketwatch.com/story/us-seen-adding-230000-jobs-in-january-2015-02-05?mod=MW_story_latest_news&link=sfmw

Enjoy, Patrick


2 Comments

Mapping UFO Sightings in the Western United States with Microsoft Power Map and Excel.

image

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.

image

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.

image

Let’s remove the Excel shell so we can just look at the map at night.

image

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!

image

Let’s pull back and show a heatmap with the density’s of reports.  That reflects where the concentrations are.

image

I’m going to have to pull all the data and map the rest of the United States later.  This was pretty insightful.

Enjoy, Patrick

PS:  Email me any questions you may have.


Leave a comment

Using Microsoft Azure Sentiment on #SpaceX with Excel PowerQuery and @PlusOneSocial

image

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!  Smile   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.

image

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.

image

Within Power Query, I edited the query and included a custom column to call the Sentiment Score function.

image

Then I just plotted my results!  1 is Positive, 0 is Neutral and –1 is Negative

image

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.

Enjoy, Patrick

PS: Contact me if you have questions.

Microsoft Layoff news Sentiment and Insights via Twitter, @Stocktwits ($MSFT) & w/@plusonesocial #wpc14

Leave a comment

Untitled

I’m a big Microsoft fan and it pains me to see the news today about all the layoffs.  I’m not going to go into the reasons why they should do this or not, that will be done to the Nth degree by tech news sites.

Rather, I would like to show what people are saying via Twitter using some simple social media  insights!  I fired up PlusOneSocial and quickly pulled over 13,500+ tweets using the keyword “Microsoft Layoffs” this morning. 

image

 

Then quickly I used Excel 2013 to pull a lot of original tweets on this subject.  People are just begining the retweet what they are reading on the news.

image

 

What does the sentiment look like for the Microsoft Layoffs?  Overall, the messaging is pretty neutral.  17% Positive and 12% Negative on the news.

image

 

Then I searched on “$MSFT” which is a common keyword for talking about stocks.  I thought it would be interesting to see how the traders are talking about Microsoft in regards to the news and it seems to match the discussion as a whole.  That is very interesting.

image

I love the fact that I can quickly get a heartbeat on any topic via social.

Enjoy, Patrick


Leave a comment

#WPC14 Day 3 much more exciting that day 2. Can anyone tell me why? w/@plusonesocial

Capture

I updated my social stats on the Microsoft Worldwide Partner conference for day 3, the noise really picked up on the morning of the 3rd day.  I believe Satya was there for the keynote.

I used Plus One Social and Excel to create this for those of you asking.

Enjoy, Patrick


Leave a comment

Day 2 at the Microsoft #WPC14 event, here are the social insights you have been waiting for w/@plusonesocial

For years I’ve attended the Microsoft WPC conference and the last several years I’ve run instant metrics on the event.  One thing that is true for all conferences, Microsoft or other, The first few hours get all social traffic.  Then after that it basically dies out.

Check out my chart below.  The blue line is day one and the orange line is day two.  Can’t wait to see day three!  Smile

image

Enjoy, Patrick

Tools Used

Follow

Get every new post delivered to your Inbox.

Join 2,037 other followers