Skip to Content

I wasn’t really in the mood to talk/blog about hockey or my favourite NHL (National Hockey League) team, the Vancouver Canucks, these past couple of weeks. That’s because after winning the first 3 games in the playoff series, they went on to lose the next 3. Luckily this was a best out of seven-game series. Last night, the Vancouver Canucks won their last and final game of the series, beating the defending Stanley Cup champs, the Chicago Black Hawks, in a nerve-racking, over-time game to win the series! The playoffs are not over yet. Go Canucks Go! #bandwagonjustgotheavier

Maybe you’re not interested in being a Vancouver Canucks fan (like maybe you support the Black Hawks)? Or maybe you’re just getting to know about the game of hockey? Either way, I have a feeling you’re interested in SAP and how to tame that data-beast. I think you’ll agree with me that sports can generate some of the most data and statistics available. Whether this information is valuable or not will depend on your interests or profession.

It’s my pleasure to introduce you to another way to experience SAP. And guess what – there’s hockey involved! Whether you’re a hockey fan or not, the folks from “Experience SAP” bring you the Hockey Experience to let you slice and dice, sort and compare, visualize and reflect on how to get useful information out of seemingly random data.

The Experience SAP team took massive amounts of data (supplied by the National Hockey League Players Association), of players, teams, and games over the years, and put this into SAP BusinessObjects Explorer and SAP BusinessObjects Dashboard. The result is a fun and easy way to look at all the statistics.

I create a head-to-head comparison of some Vancouver Canucks player in the Player Comparison model below:

 

Once you’ve gotten new-found knowledge from analyzing players and teams, you can then play a game and determine who you think will gain the most points in tonight’s game!

Want dig a little deeper? Click on “Launch Explorer” and do the slice and dice, and all the drill down you need with the entire data set. If you have trouble accessing this set of data, please be patient. I had to try a couple of times myself. (I have a feeling there are a lot of folks hittng this site to update their own hockey Playoff Pool.)

Interested in what the Experience SAP team is up to? Check out the Experience SAP wiki on SCN.

Have fun!

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. Jason Cao Post author
      Hi Tammy,
      The Capitals sure have a talented team, and did a good job against the Rangers. Good luck against the Lightnings!
      Cheers,
      Jason
      (0) 
  1. Jamie Wiseman
    Hi Jason.

    Here’s how we are bringing you this experience…just in case anyone out there is trying to do anything similar. There is a tip below on how to scale up your Xcelsius / Crystal Dashboard models.

    For the data, we are uploading xml files courtesy of the NHLPA using FeedFetcher (3rd party) and then it is extracted into SportsDB’s (3rd party) schema db. This is run live during games. Go xmlteam.com if you need to purchase xml feeds for sports. The people at xmteam are very helpful.

    Every morning, Data Services extracts all of the stats that we need for the experience tools into a flat table. This is done using an incremental extraction so that only the new data for each day is appended to the flat table.

    Here’s the scaling tip – Every morning Publisher runs a Crystal Report which exports the data (that Xcelsius/Crystal Dashboards needs) into a large number of csv files on a bunch of different web servers. We use the csv connector from Centigon Solutions (3rd party). We do this as we found the best way to scale swf files is to replicate the file to multiple web servers. Perhaps some of the community have other ways that they want to share.

    We have data from 2009 season and up to date. And yes, we are aware that the whole procedure above seems to have a lot of components 🙂

    (0) 

Leave a Reply