HUSTING's COOLBI

MAKING DATA COOL, ONE BYTE AT A TIME


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


Leave a comment

Mapped! All the Tweets for the 1st day at the Microsoft #WPC14 conference kickoff w/@plusonesocial

Capture

Since I’m an old-time Microsoft guy, the yearly Worldwide Partner Conference is going on.  I used Plus One Social to pull all the tweets on the hashtag #WPC14 and plot them on the map!

Check it out!   Is the convention being held at two locations?  Well, they are in DC so Big Brother is probably watching too…

image

Enjoy, Patrick


Leave a comment

Retail #SocialMedia dashboard utilizing Microsoft #Excel and #PowerPivot. #bigdata

image

I’ve been helping out a buddy create a social media dashboard for a bunch of retailers he visits.  Since the Twitter Analytics for Excel ran out of support, he needed another option and asked for some help.

I utilized Plus One Social to pull the data.  This program allows you to search on keywords and then places the data into a desktop database.

image

Then using PowerPivot, I created a self-serve BI model for the end-user to create their own dashboards.

image

Then I just easily created some pretty cool looking dashboards.  I think the hardest part of doing it in Excel is just getting everything to line up and look appropriate.  But I think I nailed it.  Comments?

image

Email should you have any questions.

 

Enjoy, Patrick


Leave a comment

Working great with Windows Phone 8, Spotfire Metrics #MobileBI refresh. Taking your business on your Windows Phone. @TIBCO

image

If you are using Windows Phone 8, we have a new update available for Spotfire Metrics.  It should automatically download if you have it already installed.  If you don’t have it installed, you can download and install here.

If you are not familiar with Spotfire Metrics, you should be for your business.  Turn it on and know what is going on in your business within just a couple of minutes!  Browse on over to http://spotfire.tibco.com to find out more and to get a personalized demo for your organization.

New updates included in this release:

  • Support for the new server release: TIBCO Spotfire Metrics Services 6.5.0
  • Integrated first-run tips to help users get started faster
  • Updated branding with new TIBCO logo
  • Quality improvements

Enjoy, Patrick


Leave a comment

Working great with Windows 8, Spotfire Metrics #MobileBI refresh. Making your business mobile. @TIBCO

image

If you are using Windows 8, we have a new update available for Spotfire Metrics.  It should automatically download if you have it already installed.  If you don’t have it installed, you can download and install here.

If you are not familiar with Spotfire Metrics, you should be for your business.  Turn it on and know what is going on in your business within just a couple of minutes!  Browse on over to http://spotfire.tibco.com to find out more and to get a personalized demo for your organization.

New updates included in this release:

  • Support for the new server release: TIBCO Spotfire Metrics Services 6.5.0
  • Encryption of local data
  • Integrated first-run tips to help users get started faster
  • Updated branding with new TIBCO logo
  • Quality improvements

image

image

Enjoy, Patrick


1 Comment

I feel like a stock broker but with FREE access to real-time quotes in #Excel using Yahoo. #analytics #bigdata

image

Boy, does it free great writing code again and quickly producing some insights that I didn’t have before.  What do I mean by that, hasn’t stock data always been available?  Yes, but it is more of a pain to copy and past in Excel.

I can type in a stock ticker into a cell and using Yahoo Finance, I can call their API and get a table set in return that I can throw into Excel and use for some analysis.

image

Once I get this working has my data harvesting tool, then I’m moving the data into one of the predictive analytics tools to see if we can predict some stock movements.

The possibilities are endless, email me if you have any questions.

Enjoy, Patrick

Follow

Get every new post delivered to your Inbox.

Join 2,037 other followers