微软BI解决方案.ppt

微软BI解决方案王颖微软华南区议程SQLServer对数据仓库的支持增强ETL组件--IntegrationServiceOLAP组件--AnalysisService报表展现组件--ReportingServiceSQLServer企业版和标准版区别通过为所有员工提供业务认知来强化组织结构,从而做出更好、更快、更恰当的决策提升企业整体的业务分析效率和深度;执行完整的、集成的商业智能解决方案;通过MicrosoftOffice提供普及的智能分析前端;以经济实惠的成本满足企业需求;微软商务智能愿景年至今微软数据仓库管理系统市场占有率领先SQLServer在关系型数据库和BI方面是所有数据库系统中更新最快的SQLServerOLAP市场占有率排名第一SQLServer发布的组件数量多于Oracle和IBM的总数市场占有率突飞猛进BI平台SQLServer报表服务SQLServer分析服务SQLServer关系型数据库SQLServer集成服务SharePointServerReportsDashboardsExcelWorkbooksAnalyticViewsScorecardsPlans统一报表平台产品构成呈现零售业务风险检测资产负债信贷业务ExcelService其他业务系统可测数据响应世界级的性能表现16C479tpsE64C1,126tpsETPC-E16C34,000users18,000users+88%64C63,650QphHTPC-H10TB+14%16C419tpsEonWindowsonIndustryStandardServersResultsasof2/27/08. IBMSystemx3850M2(w/SQLServer2005),419tpsE,1,527$/tpsE,available12/7/07;IBMSystemx3850M2(w/SQLServer2008),479tpsE,1,591$/tpsE,available8/30/08;NECExpress5800/1320Xf,1,126tpsE,2,771$/tpsE,available8/30/08. Source:TransactionProcessingPerformanceCouncil().Resultsasof2/27/08. HPIntegritySuperdome,63,******@10TB,$/******@10TB,available8/30/08.  Source:TransactionProcessingPerformanceCouncil().Highestperformanceon4-socketIndustryStandardServers. CertificationNumber2005030:SAPSDstandardR/,:(2005)applicationbenchmarkin3-Tierconfigurationcertifiedon02/26/08with34,,:CertificationNumber2005030:TheSAPSDstandardR/,2005byHPinRedmond,WA,USAwascertifiedonJune27,2005withthefollowingdata:p.:18,000SD(Sales&Distribution)Averagedialogresponsetime::FullyProcessedOrderLineitems/hour:1,819,000Dialogsteps/hour:5,457,000SAPS:90,950AverageDBrequesttime(dia/upd)::85%CPUutilizationofapplicationservers:67%(dia:85%,upd:19%,msg/enq:29%)OperatingSystemdatabaseserver:WindowsServer2003EnterpriseEdition(64-bit)OperatingSystemapplicationservers:Wind