SQL Server 2008 MOSS 2007 Excel 2007 jimycaosyset

超完美整合 SQL Server 2008 MOSS 2007 及 Excel 2007 打造好用又省錢的 企業商業智慧解決方案 曹祖聖 台灣微軟資深講師 jimycao@syset. com http: //teacher. syset. com MCP, MCP+I, MCSA, MCSE, MCDBA, MCAD, MCSD, MCT, MVP 1/48

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

微軟商業智慧解決方案 商業智慧運用 Share. Point Server 報表 儀表板 Excel 作簿 分析 平衡計分卡 計劃 使用 且與效能管理應用程式 Excel、Visio Performance. Point Server 商業智慧平台 SQL Server Reporting Services SQL Server Analysis Services SQL Server 資料庫管理系統 SQL Server Integration Services 4/48

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

SQL Server 2005 資料採礦增益 集 Microsoft Office Excel 2007 增益集 資料表分析 具 資料採礦用戶端 Microsoft Office Visio 2007 增益集 資料採礦範本 下載: http: //www. microsoft. com/downloads/detail s. aspx? displaylang=zhtw&Family. ID=7 c 76 e 8 df-8674 -4 c 3 b-a 99 b 55 b 17 f 3 c 4 c 51 7/48

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

Excel 整合 KPI Excel Service 12/48

Excel Services Excel Calculation Services 載入 作簿 進行計算 更新外部資料 維護連線狀態 Excel Web Access Web Part Excel Web Services ASMX 14/48

Excel Services

Excel Services的應用架構 Excel Services on Windows Server Compute Cluster Edition Excel 2007 VBA / VSTO 桌上型 16/48 Excel Services 伺服器叢集

系統架構 Web 前端伺服器 Excel Web Access Excel Web Services Web 前端伺服器 Excel Web Web 前端伺服器 Access Services Excel Web Access Excel Web Services 應用程式伺服器 UDFs Excel Calculation Services UDFs 外部資料庫 17/48 Excel 應用程式伺服器 Calculation Services Excel Calculation Services UDFs Share. Point 內容資料庫 Excel Calculation Services

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

Business Data Catalog 功能與元件 共用服務 商務資料 Web. Part s Share. Poi nt 清單 搜尋 使用者 設定匯入 自訂 解決方案 Business Data Catalog Metadata 資料庫 資料來源 22/48 ADO. NET Web Service Proxy 資料庫 Web Service

定義 BDC 應用程式 使用 XML 定義檔 將 XML 檔匯入 BDC 支援 incremental import, 可以一次匯入一個項目 方便偵錯 匯入的記錄檔 Program FilesCommon FilesMicrosoft Sharedweb server extensions12LOGS 26/48

Metadata Model 兩個目的 描述系統的 API 讓 API 有意義; 使得 API 更容易閱讀 關鍵的物件類型 System – 資料來源定義 (資料庫) Entity – 某份資料 (Customers 表格) Method – 針對 Entity 的操作 (Get. Customers. List) Association – Entities 之間的關聯 (Customers 與 Orders) 27/48

MOSS 搜尋架構 OOB Search UI/Custom Search Apps Query Object Model and Web Service 查 詢 Ranking Keywords 搜 尋 組 態 資 料 結 果 查詢引擎 Best Bets Stemmers 內容索引 Schema 協定 處理 Scopes 索引 過濾 Wordbreakers Crawl Log 索引引擎 Content Sources 外部站台 Share. Point 站台 Exchange 公用資料夾 商務資料 Information 36/48 共用資料夾 …

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

商業計分卡架構 數位儀表板、計分卡、 分析、協同運作 計分卡報表 商業決策者 Web Components Office Scorecard Web Part Office Report Viewer Web Part 2005/2000 Reporting Services Excel, TIFF, XML, PDF 授權定義 應用程式 商業分析 計分卡產生器 Metadata 計分卡應用程式 集中管理 來源系統 2005/2000 39/48 計分卡 Cubes 2005/2000 Analysis Services IT 管理人員 商業智慧平台

Share. Point KPI 清單 報表中心

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

SQL Reporting Services 整合 42/48

大綱 Microsoft Office 2007 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 Excel Service Business Data Catalog (BDC) 儀表板與關鍵效能指標 (KPI) SQL Reporting Service 整合 Office Business Application (OBA)

真實世界的應用程式 Word Excel Estimate Outlook Info. Path custom design Unstructured Office Business Applications Get specs from customer Create Lead Validate specs with Tech Sales Qualified? Office Share. Point Server Cost out the Estimate solution custom design Create Oppt’y Create Quote Decide discount strategy Closed? Assembl e propose Unstructured d response Complete Sale “傳統” 企業應用程式 Retire Lead Structured 44/48 Approve propose d response Create Invoice

強大的解決方案平台 Dynamics Duet Unified Communication & Collaboration Custom OBAs ISV OBAs Business Intelligence Content Management 2007 Office system clients • Search • Workflow • Business Data Catalog • Website & Security Framework • Excel Services LOB Apps, data warehouse, trading partners, etc 45/48 Dynamics. SAP Siebel LOB Office Communications Server 2007 Office Share. Point Server 2007 Exchange Server 2007 Microsoft Office System Open XML File Formats & Extensible Fluent Interface Visual Studio Tools for Office Business Applicatio ns

總結 Microsoft Office 2007 是使用者最友善且直 接的商業智慧用戶端 具 Excel 2007 Visio 2007 Microsoft Share. Point Server 2007 提供了一 個豐富的商業智慧平台 Excel Services 商務資料整合 數位儀表板與KPI SQL Reporting Services 整合 Office Business Application (OBA) 47/48

© 2008 Microsoft Corporation. All rights reserved. Microsoft, 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. 48/48