SQLServer2008商业智能开发全视角2.ppt

SQL Server 2008 ——商业智能开发全视角 韩亮 BI培训讲师 lianghan@ 北京迈思奇科技有限公司 使用Office访问UDM 重视 Excel 投资 Microsoft Excel 是访问OLAP和UDM的本地客户端 不需要客户端组件的部署 Excel: 人人拥有、日常应用、无需培训 基本切片和切块 Office 2007 demo 使用 SharePoint 作为BI 门户 demo 使用OFFICE访问UDM: Excel Pivot Tables、 Excel Service Business Scenarios MS Integrated BI Capabilities End User Reporting Analysis Corporate Performance Management Project Monitoring Reporting Flexible BI Microsoft Office System Windows Server System Office系统之上的BI解决方案 Business Scorecard Accelerator Excel Add-in for SQL Server EPM Solution Custom BI Solutions Solution Enabler Excel 数据挖掘插件 Microsoft Office Excel 数据挖掘插件 数据挖掘客户端 连接SQL Server：数据清理、算法继承、报表呈现、预测运算 demo Excel 数据挖掘插件 Excel数据挖掘插件: 需求 先决条件 服务器 Windows Server 2000 or 2003 SQL Server 2008 SQL Server Analysis Services 客户端 Excel 2007 / Excel 2003 记分卡 商业智能提供 对业务战略的定义、可视化管理视图和平衡记分卡指标 Microsoft 产品 技术 一套软件产品 集成 SharePoint Portal Server 2007, Office 2007, Visio 2007, SQL Server 2008, 以及 Analysis Services 关于平衡记分卡 战略目标? 绩效监控? 达标要求? 行动程序? Increase customerconfidence in our advice % of customers surveyed who rate us as their topsource of advice 65% #190% #1 or #2 Website Resource Center Consultative SellingTraining Program Objectives KPIs Targets Initiatives KPIs = Key Performance Indicators Quantifiable measurements that reflect the critical success factors of an organization 平衡记分卡的业务价值 关键BI功能 创建战略地图 记分卡设计器 仪表盘Web部件: KPIs BI 平台: 上钻、下钻、切片、分析 数据管理: SQL Server 2008, Analysis Services OLAP 部署 关键收益 将业务战略转化为一系列平衡记分卡指标 关注在实现整个战略业务目标组织的重点工作 主动在公司的所有层面上监测，对目标进行绩效考核 快速原型 平衡记分卡 Financial … financially, how should we appear to our stakeholders? Return on Assets Cash flow Project Profitability Sales Forecasts … Financial Indicators Sales … in our vision, how should we appear to our customers? Customer Survey Customer Ranking Market Share On-time delivery … Customer Indicators Operational Excellence …with customers and shareholders, what business processes must we excel at? Time spent with prospective customer