【文章版权归作者和CNBLOG所有,转载请务必注明原始出处】

猫尾巴的狐狸

导航

Use cloud data from “Dallas” with “PowerPivot” addin for excel

利用PowerPivot for excel 可以方便的在excel中分析使用很多来源的数据。

PowerPivot下载地址:

http://www.microsoft.com/downloads/details.aspx?FamilyId=e081c894-e4ab-42df-8c87-4b99c1f3c49b&displaylang=zh-cn

32bit:

http://download.microsoft.com/download/1/E/7/1E7DF842-4142-4B3C-BCE5-1B8AF543CD32/SQL2008R2/2052/x86/PowerPivot_for_Excel_x86.MSI

image

image

 

 

什么是 “Dallas”??

官方地址:

https://www.sqlazureservices.com/Account.aspx

现在是 CTP3 都没有收费 使用windows live id注册即可使用。

来自官方的解释:

Microsoft Project Codename “Dallas” changes the way information is exchanged by offering a wide range of content from authoritative commercial & public sources in a single marketplace, making it easier to find and purchase the data that you need to power your applications and analytics.

Use Codename “Dallas” to find premium content to power next-generation killer apps for consumer and business scenarios, to discover and license valuable data to improve existing applications or reports, or to bring disparate data sets together in innovative ways to gain new insight into business performance and processes.

 

在Excel中使用 “Dallas” 的数据

image

image

image

这个是预览视图,拷贝地址 到excel备用.

https://api.sqlazureservices.com/data.ashx/AssociatedPress/News/GetBreakingNewsCategories?$format=atom10

“Dallas” 目前使用 basic 验证,UserName 使用windows live id,password 使用key验证,

key可以在这里管理:

image

在 PowerPivot中 选择 “其他源”

image

image

image

 

image

image

 

image

image

posted on 2010-08-31 11:05  GinoHuo  阅读(306)  评论(0编辑  收藏  举报