Powerball insights with Microsoft Excel 2013 – Could you be a winner?

With the launch of Microsoft Office 365, we felt we needed to update a previous blog entry and show off some new stuff.  A while ago, we posted about the Powerball lottery when it was up to several hundred million dollars.  It was really interesting to see the amount of traffic driven to our blog, as we showed how you could mash-up some data using Microsoft Excel and PowerPivot.  It was a quick example and probably not our best work.

image

Recently, I had a young smart financial person in the office for an interview. I decided to give him a test to see what he could do with the tools.  He was coming from an equity finance position into the technology consulting world.  Well, I was impressed.

image

After he got all the data mashed up from the Powerball site, he created great looking Power View.  It is all interactive and you have the ability to slice and filter the data.  But wait!  There’s more!

image

Then, using GEO, he was able to plot the winners based on their voting records and winning year!   Ok, that is just crazy, but still kind of cool.

image

Then he just went nuts.  He produced analytics on the weather for the days those drawings were won, where the winners were located throughout the country and more.  Just fantastic.

And best of all, he spent just a few hours doing it.  That is some pretty solid analytical skill he has, utilizing Microsoft Excel 2013 with PowerPivot and Power View functionality.

If you would like to get a copy of the spreadsheet, please contact us.

Enjoy, Patrick

One thought on “Powerball insights with Microsoft Excel 2013 – Could you be a winner?

  1. Jimmy June 13, 2014 / 5:17 am

    Patrick,
    I stumbled across this and interested to put it through the test. I have been an avid lotto player for the last 10 years. If you can pm me that would be great.
    Regards,
    Jimmy

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