1 / 22

利用 2007 Microsoft Office system 提升企业商业洞察力

利用 2007 Microsoft Office system 提升企业商业洞察力. 议程. Microsoft BI 策略 BI 客户端 Excel Visio BI 服务器产品 SharePoint Excel Services BSM 数据整合 BDC 总结. Microsoft 的商业智能. 客户的利益 提升组织的商业性能 提高信息工作者的影响力. 我们的愿景 触及每个员工 为决策增加价值 将 BI 带入协作和商业流程 增加 Office 在战略方面的吸引力. Business Scorecard Mgr

xaviera-camacho
Download Presentation

利用 2007 Microsoft Office system 提升企业商业洞察力

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 利用 2007 Microsoft Office system 提升企业商业洞察力

  2. 议程 • Microsoft BI 策略 • BI 客户端 • Excel • Visio • BI 服务器产品 • SharePoint • ExcelServices • BSM • 数据整合 • BDC • 总结

  3. Microsoft的商业智能 客户的利益 • 提升组织的商业性能 • 提高信息工作者的影响力 我们的愿景 • 触及每个员工 • 为决策增加价值 • 将BI带入协作和商业流程 • 增加Office在战略方面的吸引力

  4. Business Scorecard Mgr Scorecarding and Performance Mgt 分析 应用程序 Portal (SharePoint) 最终用户 工具 End-user Analysis (Excel) Integrate (SSIS) Analyze (SSAS) Report (SSRS) BI 平台 Data Warehouse (SQL RDBMS) SQL Office Microsoft的商业智能

  5. Microsoft的商业智能传递到桌面

  6. Office 2007 中涉及商业智能的产品 • Microsoft Office Excel 12 和 Excel Services 12 • 使用强大的、熟悉的、易用工具分析信息数据 • 从SQL Server Analysis Services实事的搜索数据并进行交换 • 将工作表保存在Server上，通过丰富的交互体验与其他人在Web上进行共享，确保工作表生命周期管理。 • Office SharePoint Server 2007 • 安全的、可管理的业务数据，托管文档 • 将BI集成进门户、企业内容管理、协作 • 记分卡战点模版、过滤Web组件、KPI web组件、报表中心、业务数据目录 • Business Scorecard Manager • 为所有分析内容提供托管的应用程序 (报告、分析、文档) • 瘦客户和丰富的上下文分析能力 • 集中式的管理，可扩展的应用程序 • 审计、版本控制和版本恢复的能力 • 与门户、企业内容管理和协作集成 The Microsoft foundation for ubiquitous Business Intelligenceis now in place. - AMR research, October 2005

  7. Best with SQL Server 2005 Excel 和 SharePoint Server Knowledge, Discovery & Insight Excel “12” offers complete support for SQL Server 2005 Analysis Services Easily find trends in dataExcel Conditional Formatting Report CenterCentralize storage of business reports Dashboards and Web PartsEasily create powerful BI portals

  8. 数据透视表 KPIs from SQL 图表和图形 Excel Services 表格格式

  9. Office BI Tools

  10. 商业智能 协作 Windows SharePoint 平台 业务流程 门户 内容管理 搜索 SharePoint 技术更新 核心增强 任意地点的访问 社区和沟通 通过SharePoint Designer设计工作流，用户界面和数据视图 Excel Services 仪表板和Web组件 报告中心 Websites 让更多的用户可以更好的利用表单 表单驱动的业务流程自动 在企业内部快速的开发和部署表单解决方案 门户站点 人员和企业内容搜索 我的站点增强 配置文件存储增强 最重要的结果在第一页 企业搜索不同于Internet搜索 人员社会关系 文档管理 工作流和审批 策略和Compliance

  11. Excel ServicesOverview High quality web rending Zero-footprint Interactive: Set parameters, sort, filter, explore Limit to browser access Browser Excel 2007 View and Interact Publish Spreadsheets Design and author Export/Snapshot into Excel Excel 2007 Programmatic Access Open in Excel for rich exploration and analysis Open snapshots SharePoint platform and Excel services Spreadsheets stored in document libraries Spreadsheet calculation and rendering External data retrieval and caching 100% calculation fidelity Customapplications Set values, perform calculations, get updated values via web services Retrieve full workbook file

  12. Office system BI

  13. 议程 • Microsoft BI 策略 • BI 客户端 • Excel • Visio • BI 服务器产品 • SharePoint • ExcelServices • BSM • 数据整合 • BDC • 总结

  14. Web Capture Data Cache Web Part Web Part Web Part Web Part Web Part Web Part Data Warehouse HTML / XML App App App App App App Point-to-Point Application/Integration Server Web Part Web Part Web Part Web Part Web Part Web Part Application Server SOAP, ADO.NET, App. APIs App App App App App App 在 SPS03 中的数据整合方法 Infrastructure-Intensive Code Code-Intensive Code Code

  15. Business Data Catalog (BDC)连接 OfficeServer 和业务数据 Web Parts Lists Search User Profiles Custom Apps List store Search Index Profile Store Metadata Business Data Catalog WS Proxy ADO.NET Web Service Database BizTalk, SAP, Siebel, Legacy, … SQL Server, Oracle, OLEDB, ODBC

  16. Business Data Web PartsRoutine business apps with no code Scenario 360-degree view of customer Today Clipping, custom Web Parts, DataViews Office 2007: Reusable biz data Web Parts Show new data with no new code or binaries Master-detail applications with no code Integrated with dashboards and filters Customizable in FrontPage

  17. Business Data SearchSearch data, not just documents Scenario: Find an account manager in Siebel Today Vertical applications lack full-text search Most users can’t locate or access vertical apps Hard to have an index gatherer “see” business data Office 2007: Search any database/Web service No need to write IFilters or protocol handlers for biz data No need to create HTML representations of data Highly customizable results Integrated with scopes and Search Center

  18. Development LifecycleKey shift: From code to metadata Analyst defines business requirements IT Pro/developer writes and tests application definition (metadata) IT Pro uploads application definition Analyst builds solution using businessdata features

  19. BDC

  20. 议程 • Microsoft BI 策略 • BI 客户端 • Excel • Visio • BI 服务器产品 • SharePoint • ExcelServices • BSM • 数据整合 • BDC • 总结

  21. Demo Title

More Related