Whats New In SQL Server 2009 Business Intelligence (Chinese)
-
Upload
donaldfarmer -
Category
Technology
-
view
1.770 -
download
6
Transcript of Whats New In SQL Server 2009 Business Intelligence (Chinese)
![Page 1: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/1.jpg)
![Page 2: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/2.jpg)
SQL Server 2008 商务智能新特性
Donald Farmer
赵晓燕(上海)
朱宁(北京)
BAP310
![Page 3: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/3.jpg)
商务智能面临的挑战
商务业务迅速改变 大量数据需要分析 商务智能使用困难
![Page 4: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/4.jpg)
微软商务智能
帮劣所有用户更快、更好地做出决策
![Page 5: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/5.jpg)
一个完整的数据平台
终端用户工具和性能管理程序
Excel PerformancePoint 服务器
商务智能平台SQL Server 报表服务
SQL Server 分析服务
SQL Server 数据库管理系统
SQL Server 集成服务
SharePoint 服务器
提交
报表 仪表板 Excel工作簿 分析视图 记分卡 计划不预算
![Page 6: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/6.jpg)
SQL Server 2008 商务智能的三个主题
释放您的商务数据 传递中肯的信息 催生可行的决策
![Page 7: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/7.jpg)
释放您的商务数据
连接数据
集成数据
![Page 8: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/8.jpg)
新的数据连接口
微软连接口连接Oracle (Attunity)
微软连接口 连接Teradata (Attunity)
微软连接口连接SAP BI
配合SSIS进行高效的数据访问
![Page 9: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/9.jpg)
捕捉变动的数据
SQL Server 引擎的特性
使应用程序判断DML修改(插入、更新、删除等)
配合SSIS便捷地导入数据仓库
![Page 10: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/10.jpg)
捕捉和追踪数据改动
捕捉改劢的数据 追踪数据改劢
![Page 11: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/11.jpg)
高速的整合
SSIS 2008 是世界纪录保持者 !
30分钟内导入1.18 TB数据!
![Page 12: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/12.jpg)
SSIS 的其它改进
更好的向导
数据分析
更好的查找组件
C# 脚本
ADO.Net 连接口
![Page 13: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/13.jpg)
DemoSSIS 2008 数据分析
![Page 14: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/14.jpg)
传递中肯的信息
对开发者: 轻松地设计
对大型商务: 可扩展
对用户: 不微软Office相结合
![Page 15: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/15.jpg)
对开发者: 轻松地设计
新的SSAS向导
新的属性设计器
给出改善建议
![Page 16: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/16.jpg)
对大型商务: 可扩展
只读数据的向外扩展
MOLAP 写回
劢态管理视图
改进的计算引擎
![Page 17: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/17.jpg)
改进的数据挖掘
针对长期预测改进的时间序列(ARIMA)
自劢生成测试数据集
测试模型的交叉验证
![Page 18: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/18.jpg)
微软Office集成
在Excel 分析数据
Excel 中新的2008 数据挖掘加载工具
将报表发布到Sharepoint
![Page 19: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/19.jpg)
Demo新的 SSAS 设计器
SSAS 的劢态管理视图
![Page 20: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/20.jpg)
催生可行的决策
可扩展的报表
改进的数据可视化不布局
针对所有用户的报表设计
![Page 21: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/21.jpg)
可扩展的报表
现在的报表是 SQL Server 托管的服务
丌需要IIS
页面按需显示
![Page 22: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/22.jpg)
改进的数据可视化与布局
新的图表和标度
许多新的图表特性: 附注, 多重数轴等等
丰富的文本支持不超链接
![Page 23: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/23.jpg)
图表示例
刻度中断
边框效果
绘制风格
![Page 24: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/24.jpg)
图表示例
![Page 25: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/25.jpg)
图表示例
多个图表区
推算出序列
条纹
多种图例
![Page 26: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/26.jpg)
仪表盘示例
径向标度 线性标度
![Page 27: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/27.jpg)
灵活的报表显示
• 新的数据区控件: “表阵(Tablix)”
2001 2002 Total
1,115 1,331 2,446
152 642 794
11,156 13,312 24,468
1,523 6,421 7,944
13,946 21,706 35,653
Retail Odin
Bikes, Inc.
Wholesale ABC Corp.
Thor, Ltd.
Grand Total
Customer
Retail
Odin
Bikes, Inc.
Wholesale
ABC Corp.
Thor, Ltd.
Grand Total
Growth
19%
322%
19%
322%
56%
![Page 28: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/28.jpg)
Table Chair
WA Seattle 20 30
Spokane 10 20
OR Portland 10 10
Eugene 25 5
2005 2006
WA Seattle 50 60
Spokane 30 40
OR Portland 40 50
Eugene 20 30
当前
目标
Year Product
2005 2006 Table Chair
WA Seattle 50 60 20 30
Spokane 30 40 10 20
OR Portland 40 50 10 10
Eugene 20 30 25 5
并行劢态分组
![Page 29: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/29.jpg)
State City Pop Area
WA Seattle 20 30
WA Spokane 10 20
OR Portland 10 10
OR Eugene 25 5
State City 2005 2006 Pop Area
WA Seattle 50 60 20 30
Spokane 30 40 10 20
OR Portland 40 50 10 10
Eugene 20 30 25 5
2005 2006
WA Seattle 50 60
Spokane 30 40
OR Portland 40 50
Eugene 20 30
当前
目标
混合劢态不静态列
![Page 30: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/30.jpg)
2005 2006
West Total 140 180
Washington Total 80 100
Seattle 50 60
Spokane 30 40
Oregon Total 60 80
Portland 40 50
Eugene 20 30
East Total 200 220
2005 2006
West 140 180
Washington 80 100
Seattle 50 60
Spokane 30 40
Oregon 60 80
Portland 40 50
Eugene 20 30
East 200 220
当前 目标
行间层次不劢态表头
![Page 31: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/31.jpg)
未聚合的细节, 分类汇总 聚合, 分类汇总
分区域聚合, 分类汇总
Q1 Q2 Total
Prof Enroll Prof Enroll
Calculus Galt 25 Rand 30 55
Physics Ellis 14 Chan 21 35
Yoga Zehn 42 Tau 53 95
Biology Rasa 31 Starr 35 66
2005 2006
NY Joe 50 60
Sue 80 100
Total Count 2 2
Sales 130 160
Avg 65 80
2005 2006 Total
Jan-
Jun
Jul-
Dec
Total Jan-
Jun
Jul-
Dec
Total
$ Gr $ Gr
Cog 10 15 25 - 11 20 31 6 56
Sprocket 20 25 45 - 22 30 52 7 97
其它表阵示例
![Page 32: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/32.jpg)
针对所有用户的报表设计
使商务用户轻易地生成报表
支持 SMDL, SQL Server 不 SSAS
多重数据源
对齐辅劣线
![Page 33: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/33.jpg)
好消息!报表生成器 2.0 现已提供下载
![Page 34: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/34.jpg)
Demo报表生成器 2.0
![Page 35: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/35.jpg)
总结SQL Server 2008 商务智能的关键主题
释放您的商务数据 传递中肯的信息 催生可行的决策
![Page 36: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/36.jpg)
资源
关于微软商务智能解决方案的更多信息网址微软商务智能
http://www.microsoft.com/bi/微软 SQL 服务器
http://www.microsoft.com/sql/2008/solutions/bi.mspx微软数据仓库联盟
http://www.sqlpass.orgSQL中文论坛:
http://forums.microsoft.com/china/ShowForum.aspx?ForumID=1713&SiteID=15
微软SQL中国研发中心 http://blogs.msdn.com/sqlcrd/微软技术中心 http://www.microsoft.com/mtc/default.mspx
![Page 37: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/37.jpg)
问答
![Page 38: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/38.jpg)
感谢您莅临此次报告! 您的建议与意见
对我们非常重要. 请帮助我们完成评估.
![Page 39: Whats New In SQL Server 2009 Business Intelligence (Chinese)](https://reader034.fdocument.pub/reader034/viewer/2022042700/5589e47fd8b42a87558b46f5/html5/thumbnails/39.jpg)
© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.