Just found this video through Twitter (thanks @explainnation!)...  While it doesn't go into much detail on how Appirio works, it does a great job at explaining what Appirio does...  I loved the animation and it's funny to boot (the "plumbers" are classic).  

Also, in case you'd like to learn more about Appirio and the issues they address, here's a piece we did with Narinder Singh, CMO and Co-founder of Appirio, at the All About the Cloud event earlier this year: