TechNet 技術講座 <SLIDETITLE INCLUDE=0>Entry Slide</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT></SLIDESCRIPT> <SLIDETRANSITION> </SLIDETRANSITION> <COMMENT></COMMENT> <ADDITIONALINFORMATION> <ITEM></ITEM> </ADDITIONALINFORMATION> Welcome

Microsoft 商業智慧功能及整體架構介紹 <SLIDETITLE INCLUDE=7>Title Slide</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT> Hello and Welcome to this Microsoft TechNet session on {insert session title}. My name is {insert name} </SLIDESCRIPT> <SLIDETRANSITION> <TRANSITION LENGTH=7>Let us start this session by going into more detail on exactly what we will be covering.</TRANSITION> </SLIDETRANSITION> <COMMENT></COMMENT> <ADDITIONALINFORMATION> <ITEM></ITEM> </ADDITIONALINFORMATION> Kevin Yang 楊振嘉 台灣微軟技術經理

摘要 Microsoft 商業智慧平台建議架構 Microsoft 商業智慧平台各產品對應關係及簡介 <SLIDETITLE INCLUDE=7>What we will Cover</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT> [When writing the script for this slide, expand a bit on the list on the slide, do not simply list the slides items here. Think of this as the advert for the session, explain a bit more what will be covered and how.] </SLIDESCRIPT> <SLIDETRANSITION> <TRANSITION LENGTH=7>As with most TechNet sessions, some prior experience of Microsoft technologies or similar technologies is always helpful, the next slide provides a brief overview of what would be helpful, but not essential, for this session.</TRANSITION> </SLIDETRANSITION> <COMMENT></COMMENT> <ADDITIONALINFORMATION> <ITEM></ITEM> </ADDITIONALINFORMATION>

BI Platform Arch. 實體資料庫 可以從不同來源端匯入資料 如 oracle, txt file, ... Oracle or DB2 … 分析資料庫 OLAP Server 使用者可以自行選擇前端工具 暫存資料庫 Staging Db KPIs Cubes UI SSIS OLEDB for OLAP SSIS Subject Matter Db EXCEL, OWC(HTML) Proclarity Performance Point Server

微軟完整商業智慧解決方案 SharePoint Server Excel PerformancePoint Server Excel SEARCH 商業智慧入口網站 CONTENT MANAGEMENT COLLABORATION 報表 Excel 工作表 儀表板 計分卡 分析 圖表 規劃 前端使用者工具 Excel 前端使用者工具及績效管理解決方案 Excel PerformancePoint Server 微軟商業智慧平台 報表 SQL Server Reporting Services 線上及時分析、資料採礦 SQL Server Analysis Services 資料庫、資料倉儲 SQL Server DBMS 資料整合 SQL Server Integration Services SQL Server

SQL 2005 Integration Service 全新的 SQL Server 商業智慧應用程式 Data Transformation Services 的接續版本 高效能的資料整合平台 1GB/10 mins in FET DW(Trans data from Teradata to SQL 2005) 全新用 .NET 撰寫的架構，更豐富的功能 完善的資料檢視、單步除錯與錯誤處理 透過 pipeline 可以更豐富地加值資料，且全部在記憶體內完成，不需要中介資料表 以封裝(Package)為執行單位，而非專案(Project)

SQL 2005 Reporting Service –SSRS Traditional Solutions TXT file, Excel (.csv) Output Features of the Microsoft SQL Server 2005 UDM that solve the problem Reporting VS Analysis

Reporting Results are garnered from predefined queries Highly formatted Support multiple output formats (MHTML, PDF, CSV, etc…) Include all of the detail required for the user requirement Published to Web and Distributed to Email

Analysis Results are garnered from multiple interactive queries Data is initially presented at a high level (often summary level) that provides a starting mechanism for the user Data is pre aggregated to provide fast interaction through the data set. Data layout should be flexible and provide different types of visualization (grids, charts, quadrant analysis, timelines, etc…)

SQL 2005 Analysis Service – SSAS 全視覺化的開發方式 UDM Support 後端可以連接多種資料來源 OLE DB Provider .Net Provider (Teradata, Oracle, SQL Server) 維度和事實資料表可以來自不同來源 沒有限制維度成員大小 須有前端工具的配合, 如 Excel 2007, Proclarity… 多國語言的支援 自由的建立或合併 Cube Partition 利用多CPU的處理能力

Data Mining in SQL 2005 SSAS Relative Business Value Easy Difficult Business Knowledge Relative Business Value SQL-Server 2005 Data Mining OLAP Reports (Adhoc) Reports (Static) Easy Difficult

9種演算法 Decision Trees Clustering Time Series Association Naïve Bayes Sequence Clustering Logistic Regression Neural Net Linear Regression

最常使用的資料採礦演算法

決策樹瀏覽器

迴歸樹瀏覽器

PerformancePoint Server 2007 提供企業更好的策略執行力 8/3/2019 7:48 PM Monitor What happened? What is happening? Analyze Why? Strategy Point of Slide Customers use Performance Management in order to better execute on strategy. Being ‘world-class’ in enabling MAP is to give customers a consistent tie to their corporate strategy across all 3 activities. In addition, PerformancePoint is about providing the integration necessary to provide customers with a way to apply performance management continuously throughout the year. One of the limitation of the space is that MAP is calendar-driven, preventing businesses from being agile. Flow Monitor – using reports, dashboards, scorecards, business users monitor past information. Monitor answers the ‘What’ of customer questions. “What happened, What is happening”. Analyze – customers use visualization tools and analytics to understand complex information faster. Analyze answers the ‘Why’ of customer questions. ‘Why did this happen”, ‘Why is this happening’. Often customers use their knowledge of present business conditions to ask better questions. Plan – business users need to take past information, present business conditions and make plans for their future. Plan answers the ‘How’ of customer questions. How they can modify the course of action, how can I make the situation better. Customers need integrated application to be able to plan the future more accurately. Sound bites The ability of an organization to get the right information at the right time in order to make timely decisions should be an indicator of the company’s flexibility, however 92% of all management reporting is available only one predetermined calendar basis, typically monthly while only 8% of management reporting is available on demand. Plan What will happen? What do I want to happen? 持續性的成長與改進,不只是例行性的改進 Continuous business improvement, not just an annual exercise 18 18

PerformancePoint Server 2007 監控與分析功能 讓商務使用者快速查看並瞭解績效問題，藉此 更快速做出更佳決策，而無需技術協助 This is the vision of PPS M v1. Key words: Combine – bring together BSM and ProClarity Dashboard into one build and consume experience Formal – align strategy across the enterprise- centralized build, deploy, manage Optimized Rapid visibility monitor variance against plan (corporate performance) – key theme of performance management

二○一九年八月三日 Microsoft Office PerformancePoint Server 2007 Planning 讓所有的使用者皆能持續投入和參與規劃、預算和預測流程 高度可設定性的績效管理應用程式 透過模型的建立，實作績效管理 整合企業的商業規則與邏輯 協助企業製訂目標與計劃 藉由 Excel 設計輸入的表單與報表 將使企業和IT間的溝通變得更加容易 © 2006 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.

PerformancePoint 模型設計師 二○一九年八月三日 PerformancePoint 模型設計師 財務 Entity 方案 時間 產品 人事 維度 模型 年度預算 匯整 其它假設 商業規則 輸入表單和報表 核准 分析員 1 分析員 2 工作角色 (Excel) 分派任務 週期 © 2006 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.

建構在微軟商業智慧平台之上 SQL Server 2005 商業智慧平台 提高 Office System 2007 的商業應用價值 市場 NO.1 OLAP 伺服器 整合 ETL/OLAP/Reporting 等工具 提高 Office System 2007 的商業應用價值 數據的存取與分析 整合 SharePoint 與商業智慧解決方案進行協同運作 使商業智慧解決方案廣泛應用 整合容易上手的Office以及SQL Server的安全性 降低 IT 和商務複雜性 比傳統解決方案易於上手，部署成本低 應用模型增加企業靈活性，降低開發時間

<SLIDETITLE INCLUDE=0>Tag line</SLIDETITLE> <KEYWORDS></KEYWORDS> <KEYMESSAGE></KEYMESSAGE> <SLIDEBUILDS>0</SLIDEBUILDS> <SLIDESCRIPT></SLIDESCRIPT> <SLIDETRANSITION> </SLIDETRANSITION> <COMMENT></COMMENT> <ADDITIONALINFORMATION> <ITEM></ITEM> </ADDITIONALINFORMATION>