8- SQL-BI-SkillTransfer(内部资料)

Click to edit Title Slide,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,BI/BSC,行易,SQL,技術轉移,楊志強,台灣微軟特約資深講師,MCT/MCSD/MCDBA,Microsoft BI,架構,Management Tools,Dev Tools,Visual Studio.Net,Excel,Visio,Project,OWC,SharePoint,Portal Server,Project Server,Data Analyzer,Windows Server,Windows Client,Microsoft Business Solutions BI Applications,Business Scorecards,BI Portal 2003,Excel OLAP Reporting,Solution Accelerators,SQL Server,Relational Engine,Reporting Services,Analysis Services,OLAP&Data Mining,Office System,微軟商業智慧平台市場佔有率,Source:OLAP Report(August 18,2003),by Nigel Pendse,Business Intelligence Platforms,Magic Quadrant(August 2002),NO.1,SQL Server 2000 Reporting Services,報表服務,SQL Server 2000,完整的企業資料庫解決方案,Analysis Services,Data Transformation Services,XML support,32/64 bit,開發,工具,管理,工具,OLAP&Data Mining,商業智慧,資料轉換服務,資料庫,報表服務,Reporting Services,報表服務,-,完整的三個階段,SQL Server Catalog,Report Server,報表服務架構,Delivery,Delivery Targets,(E-mail,File share,Custom),Security Services,(NT,Passport,Custom),Security,Data Sources,(SQL,OLE DB,ODBC,Oracle,Custom),Output Formats,(HTML,Excel,PDF,Custom),Report Processing,Browser,Management,Custom App,URL,WMI,Web Service,Data Retrieval,Rendering,報表製作,使用,Microsoft VS.NET 2003,或任何支援,RDL,的,3rd party tools,單一報表可支援同時使用多種資料來源,(Access,OLE DB,ODBC,Oracle,and.NET data providers),多樣化報表,多樣化工具,Freeform/Table/Matrix/Chart,參數化報表,(Dynamic,Hierarchical),Sorting/Filtering/Grouping/Aggregates,互動化報表,(Drill-down,Drill-through),在報表製作環境中可直接進行報表預覽,報表製作完成可直接公佈至,Report Server,提供,RDL XML,標準具備客製擴充性,報表傳送,提供 On-demand(“pull)和 event-based(“push)的傳遞方式,提供多樣化報表格式(HTML,WORD,PDF,TIFF,CSV,EXCEL,XML),提供報表訂閱機制,使用者可自行選擇報表傳送方式、格式及時間,傳送內容可為報表超連結、附加檔案或內嵌整份報表,提供 個人化報表,系統預設訂閱傳送方式,E-mail 傳送方式,File Share,可客製化,報表管理,管理程式為 Web Service APIs,提供 Web 的使用者管理介面,報表管理程式功能,排程機制整合 SQL Server Agent,提供最有效能的報表處理機制(live,cache or snapshot),提供歷史報表管理機制,提供報表稽核及保存之用,Role-based 平安機制,報表系統於企業應用的最新動態,金融業,VIP 客戶報表,客戶關係管理,平安性,自動傳送報表(訂閱/定時),客戶從入口網站訂閱報表,取代傳統的帳單,所有行業,取代傳統紙張的報表,使用者可自行訂閱報表,成為真正的資訊工作者,政府單位,電子表單,公文,/,文件的傳遞,大型資訊系統的,管理報表,電信業,電子帳單,製造業,生產製程的管理報表,零售業,銷售業績管理報表,SQL Server 2000,報表服務,demo,BI Portal 2003,提供完整企業資料,(OLAP/Relational/Files etc.),的視覺化,(Pivot table,Chart,Gauges,Spreadsheet),商業智慧整合方案,Tree View,Data Analysis,我的最愛,各種檢視,BI Portal 2003,與,Office,整合,BIP2003 Add-in,BI Portal 2003,與,Office,整合,BIP2003 Add-in,微軟平衡計分卡介紹,Microsoft,Balanced Scorecard Framework,BSC,的四個構面,Vision and,Strategy,Objectives,Measures,Targets,Initiatives,財務,“To succeed financially,how should we appear to our share-holders?,Objectives,Measures,Targets,Initiatives,學習與成長,“To achieve our vision,how will we sustain our ability to change and improve?,Objectives,Measures,Targets,Initiatives,顧,客,“To achieve our vision,how should we appear to our customers?,Objectives,Measures,Targets,Initiatives,內部流程,“To satisfy our shareholders and customers,what business processes must we excel at?,Source:The Balanced Scorecard Collaborative,股東與顧客的,外界,衡量,有關重大企業流程,創新能力,學習及成長的,內部,衡量,衡量,過去,努力成果,驅動,未來,績效,策略地圖,&,因果關係,Cause&Effect,Theme:Smart,Profitable Expansion,50%Revenue from New Stores by Year 3,Increase Sales Efficiency,Development Project Management,Great New Locations,Corporate Digital Nervous System,Business Intelligence Use,Fact-based site selection,%revenue from stores opened in last 3 years,Revenue from new stores,Avg.#of days to break even,Revenue per FTE,Avg daily customers at new stores in first 6 months,#repeat customers,Avg purchase amount,Lag between market selection and site acquisition,Project duration:site acquisition to opening day,%of stores opened on schedule,#Eligible employees trained,Financial Perspective,Customer Perspective,Operational Perspective,Employees&Technology Perspective,The Business Scorecard solution is a solution to,articulate,communicate,drive,and,measure strategy,Articulate,Define the strategy:,Strategy Map Builder,Builds the scorecards:,Scorecard Builder,Manage info about strategy:,Document Libraries,Communicate,Integrated into Collaborative Portal:,SharePoint v2,Displays KPIs:,Dashboard web parts,Drive,Relevant to the individual:,Personalization via SharePoint,Actionable and Interactive:,BI Platform,(drill down,slice,analyze),Measure,Infrastructure to manage scorecards and metrics:,Scorecard Engine,Data Management:,SQL Server 2000,Analysis Services,Scorecards:,商業價值,Scorecard Builder,提供完整工具建置平衡計分卡,Scorecards:Solution Architecture,UI for entering your scorecard data,Web Service,Scorecard,Builder,Data entry interface for manually entered targets,Data,Entry,Deploy your scorecards,Customize your views,SharePoint Portal Server,Solution-specific web parts,Scorecard,Presentation,Scorecard,Engine,Understands your BSC data,Builds the scorecard,UI for building your strategy maps,Visio,Strategy Map,Builder,Define KPI mappings and data sources,Data,Sources,Scorecard,DB,Captures information about your scorecard,SQL Server,Source,Systems,Scorecard,Cubes,Scorecard cube(s),Recommended SSABI-based,customizable,微軟平衡計分卡,策略地圖,(Strategy Map),Excel OLAP Reporting