Combine data from the cloud with local data using PowerPivot and Dallas

Today I got a long awaited message in my mailbox, i had been accepted to the project Dallas CTP.

Microsoft® Codename “Dallas” is a new service allowing developers and information workers to easily discover, purchase and manage premium data subscriptions in the Windows Azure platform. Dallas is an information marketplace that brings data, imagery, and real-time web services from leading commercial data providers and authoritative public data sources together into a single location, under a unified provisioning and billing framework. Additionally, Dallas APIs allow developers and information workers to consume this premium content with virtually any platform, application or business workflow.

When i read about Dallas a few week ago my first thought was PowerPivot (it’s never far from my mind these days i must admit). I decided to create a mashup between a local SSAS cube data and data i pull from the cloud. Since my previous movie got such great reactions i decided to do a new one: