微軟商務(wù)智能解決方案

微軟商務(wù)智能解決方案目標(biāo)：數(shù)據(jù)信息轉(zhuǎn)化為商務(wù)價(jià)值過程：知識(shí)決策價(jià)值數(shù)據(jù)信息分析提煉指導(dǎo)創(chuàng)造行動(dòng)落實(shí)BusinessIntelligence戰(zhàn)略價(jià)值可靠健全數(shù)據(jù)可擴(kuò)展性一致性、有效性整合性個(gè)人與團(tuán)隊(duì)業(yè)務(wù)洞察力協(xié)作、共享簡(jiǎn)單、易用高效、便捷企業(yè)決策力企業(yè)業(yè)務(wù)活動(dòng)協(xié)調(diào)、統(tǒng)一企業(yè)管理目標(biāo)化、職責(zé)化業(yè)務(wù)決策敏捷、準(zhǔn)確平臺(tái)應(yīng)用業(yè)務(wù)狀態(tài)脈絡(luò)清晰領(lǐng)悟透徹企業(yè)客戶數(shù)據(jù)再利用業(yè)務(wù)挑戰(zhàn)與需求高層管理報(bào)表太多，分散，數(shù)據(jù)不一致；難及時(shí)監(jiān)控到業(yè)務(wù)狀況；決策時(shí)無有效基礎(chǔ)數(shù)據(jù)；難以有效考核業(yè)績(jī)…業(yè)務(wù)部門主管與業(yè)務(wù)分析員

所需報(bào)表難及時(shí)獲取；

報(bào)表制作太麻煩；難以多角度、深層次分析業(yè)務(wù)異常原因；業(yè)務(wù)報(bào)表分享困難…IT主管“數(shù)據(jù)孤島”造成數(shù)據(jù)分散，不一致，質(zhì)量不高；報(bào)表與分析需求多且頻繁變動(dòng)，難以應(yīng)付；報(bào)表多，業(yè)務(wù)系統(tǒng)性能受影響；報(bào)表隨意分發(fā)，數(shù)據(jù)安全難以保障…報(bào)表即席查詢個(gè)人與部門儀表板分析圖表數(shù)據(jù)整合數(shù)據(jù)存儲(chǔ)數(shù)據(jù)管理

安全一致性、有效性擴(kuò)展能力……戰(zhàn)略價(jià)值企業(yè)客戶數(shù)據(jù)再利用解決方案可靠、健全

企業(yè)數(shù)據(jù)個(gè)人

&團(tuán)隊(duì)業(yè)務(wù)洞察力企業(yè)管理

決策力數(shù)據(jù)中心數(shù)據(jù)倉庫報(bào)表與分析績(jī)效管理應(yīng)用商務(wù)智能系統(tǒng) 20062005BusinessIntelligence(BI) 1 2+4.8%Securityenhancementtools 2 1+4.5%Mobileworkforceapplications 3 3 +3.9%Collaborationtechnologies 4 * +3.6%Customersalesandservicetechnologies 5 8 +3.4%Service-orientedapplicationsandarchitecture(SOA,SOBA) 6 11 +3.2%Workflowmanagement 7 4+3.2%Networking,voiceanddatacommunications 8 7 +3.0%Virtualization(storage,computing,datacenter) 9 10 +2.9%Legacyapplicationmodernizationandupgrade 10 5 +2.5%Towhatextentwillyourinvestmentineachofthefollowingtechnologieschangein2006?RankingSpendingIncrease2006CIOTechnologyPrioritiesSource:GartnerEXP2006CIOSurvey商務(wù)智能系統(tǒng)—

NO.1的關(guān)注

BIisthe#1TechologyPriorityforCIOs

Themarketishot,spendingishigh,theopportunityishuge市場(chǎng)客戶關(guān)系管理市場(chǎng)促銷市場(chǎng)細(xì)分品牌管理客戶忠誠度分析客戶流失分析產(chǎn)品及服務(wù)目錄管理運(yùn)營(yíng)供應(yīng)鏈優(yōu)化IT運(yùn)營(yíng)優(yōu)化分銷商評(píng)估質(zhì)量控制內(nèi)部管理流程優(yōu)化企業(yè)報(bào)表系統(tǒng),信息門戶數(shù)據(jù)分析應(yīng)用數(shù)據(jù)挖掘

數(shù)據(jù)整合，數(shù)據(jù)中心技術(shù)決策者/IT專業(yè)人士商務(wù)決策者/經(jīng)理商業(yè)分析人士財(cái)務(wù)績(jī)效評(píng)估盈利分析預(yù)算風(fēng)險(xiǎn)控制欺詐識(shí)別銷售銷售分析客戶管理銷售漏斗管理需求預(yù)測(cè)關(guān)聯(lián)銷售分析Web點(diǎn)擊流和銷售分析商務(wù)智能應(yīng)用場(chǎng)景商務(wù)決策者/經(jīng)理緊密集成，“all-in-one”一步到位，節(jié)約成本…快速構(gòu)建，簡(jiǎn)單易用（與Office整合），便于管理豐富的可視化報(bào)表、分析與展現(xiàn)工具全面的數(shù)據(jù)集成整合，分析處理平臺(tái)數(shù)據(jù)集市統(tǒng)計(jì)分析數(shù)據(jù)挖掘數(shù)據(jù)抽取、清洗與加載企業(yè)報(bào)表數(shù)據(jù)倉庫CRMLOBERP業(yè)務(wù)系統(tǒng)知識(shí)發(fā)布Familiar,

Powerful

BITools客戶工具門戶DevicesThirdPartyApplications績(jī)效記分卡交互式報(bào)表決策分析微軟全面商務(wù)智能解決方案內(nèi)置商務(wù)智能套件數(shù)據(jù)的價(jià)值在數(shù)據(jù)上的投資洞察力/預(yù)見力預(yù)測(cè)數(shù)理統(tǒng)計(jì)分析神經(jīng)元網(wǎng)絡(luò)數(shù)據(jù)挖掘在線分析工具多維分析KPI在線分析知識(shí)信息報(bào)表和查詢報(bào)表SQL查詢數(shù)據(jù)透視表數(shù)據(jù)數(shù)據(jù)收集數(shù)據(jù)倉庫ETL工具數(shù)據(jù)抽取數(shù)據(jù)整合層次化業(yè)務(wù)分析深入數(shù)據(jù)挖掘自定義報(bào)表數(shù)據(jù)展現(xiàn)報(bào)表分析集成BIApplicationsand

AnalyticalClientsDevelopment

ToolsBIPlatformSQLServer2005商業(yè)智能模塊SQLServer200550%

性能優(yōu)勢(shì),

較SQLServer2000性價(jià)比好20%162%

性能優(yōu)勢(shì),

較SQLServer2000性價(jià)比好54%

also1,231,433$4.82SQLServer200538%的性能優(yōu)勢(shì),

較Oracle性價(jià)比好20%

(垂直擴(kuò)展到16顆安騰處理器)5%的性能優(yōu)勢(shì),

較Oracle性價(jià)比好15%

(垂直擴(kuò)展到64顆安騰處理器)TPC-CresultsreferencedaboveareHPIntegritySuperdomerunningSQLServer2005,1,082,203tpmC,5.38$/tpmC,available12/7/05,andHPIntegritySuperdomerunningOracle10g,1,008,144tpmC,8.33$/tpmC,available4/14/04.

TPC-HresultsreferencedabovearethefollowingthreeresultsrunningSQLServer2005:HPIntegrityrx8620,13,637QphH@1000GB,54$/QphH@1000GB,available12/7/05;NECExpress5800/1320Xe,13,453QphH@1000GB,99$/QphH@1000GB,available12/7/05;BullNovaScale?5160,12,865QphH@1000GB,44$/QphH@1000GB,available12/7/05;andUnisysES7000Aries420EnterpriseServerrunningOracle10g,9,853QphH@1000GB,68$/QphH@1000GB,available11/30/04.

Resultsasof6/7/05.1,184,8931,231,433$5.52$4.82快速的故障轉(zhuǎn)移數(shù)據(jù)庫鏡像故障轉(zhuǎn)移群集始終在線技術(shù)在線索引操作快速恢復(fù)細(xì)粒度在線修復(fù)數(shù)據(jù)庫鏡像高訪問能力快照隔離BusinessIntelligenceonSQLServer

-高可用性Agenda商務(wù)智能概述集成服務(wù)分析服務(wù)報(bào)表服務(wù)和展現(xiàn)工具案例分析CRM:semistructuredLegacydata:binaryfilesApplicationdatabaseETLWarehouseReportsMobiledata

DataminingAlerts&escalationHandcodingStagingTextMining

ETLStagingCleansing&ETLStagingETLIntegrationServices

-傳統(tǒng)ETL過程

CRMsemi-structureddataLegacydata:binaryfilesApplicationdatabaseAlerts&escalationSQLServerIntegrationServicesTextminingcomponentsCustomsourceStandardsourcesDatacleansingcomponentsMergesDataminingcomponentsWarehouseReportsMobiledataIntegrationServices

-現(xiàn)在SQLServer2005Justasdatacanbemergedintheflow,soitcanbesplitandpartitioned…控制流LoopFTPExecuteSQLDataFlowSendMail數(shù)據(jù)流FlatFileSourceOracleADO.NETSourceMergeDe-duplicateSplitSQLServerFlatFileControlflowenablestheusertodefineacomplexworkflowoftasks.Thiscontrolflowcanincludemanydifferentkindsoftasks…ArrangedinLoopsandSequencesandrelatedbyconstraints.DataFlowisaspecialtask…Whichhasitsownobjectmodel.Itisusedformovingdata.Datacanbefrommultiple,heterogeneoussources…Datacanbemergedintoasingleflow,evenfromvariedsources.Fromthereitcanbecleansed…Andloadedintomultiple,diverse,destinations.企業(yè)級(jí)數(shù)據(jù)整合工具高性能支持復(fù)雜數(shù)據(jù)流程設(shè)計(jì)支持各類復(fù)雜數(shù)據(jù)源設(shè)計(jì)開發(fā)特性可視化數(shù)據(jù)流程設(shè)計(jì)動(dòng)態(tài)調(diào)試、斷點(diǎn)自定義任務(wù)、轉(zhuǎn)換、數(shù)據(jù)源集成特性支持WebServices,XML與BI應(yīng)用緊密集成自身能夠作為數(shù)據(jù)源再度利用CallcenterbinaryfilesAppssemi-structuredLegacydatabaseWarehouseReportsMobileETLIntegrationServices

-強(qiáng)大的ETL工具Agenda商務(wù)智能概述集成服務(wù)分析服務(wù)報(bào)表服務(wù)案例分析AnalysisServices

－OLAP中的多維數(shù)據(jù)集(Cube)特性關(guān)系型OLAP靈活的架構(gòu)

實(shí)時(shí)的數(shù)據(jù)訪問

單一數(shù)據(jù)存儲(chǔ)

管理簡(jiǎn)便

詳細(xì)數(shù)據(jù)報(bào)表

高性能

最終用戶驅(qū)動(dòng)

易于導(dǎo)航、鉆取和查找

豐富的分析功能

豐富的語義

AnalysisServices

－關(guān)系數(shù)據(jù)和OLAPLOBDWDatamart數(shù)據(jù)模型分析工具數(shù)據(jù)源MOLAPMOLAP復(fù)雜的模型OLAPversusReporting重復(fù)的數(shù)據(jù)DashboardsRichReportsBIFrontEndsSpreadsheetsAd-HocReportsUDMXML/AorODBOAnalysisServicesCacheAnalysisServices

－統(tǒng)一維度模型UDMAnalysisServicesMOLAPcacheUpdateMDXUDMEventsNewVersionDataSilenceIntervalLatencySQLRDBMSAnalysisServices

-前攝緩存ProactiveCaching

AnalysisServices

-KPIAnalysisServices

-透視AnalysisServices

-多語言轉(zhuǎn)換可視化的數(shù)據(jù)挖掘工具與導(dǎo)航8種數(shù)據(jù)挖掘算法集成DecisionTreesNa?veBayesianClusteringSequenceClusteringAssociationRulesNeuralNetworkTimeSeriesTextMining行業(yè)標(biāo)準(zhǔn)的領(lǐng)導(dǎo)者DMX,XML/A支持第三方算法嵌入關(guān)聯(lián)銷售銷售預(yù)期客戶分類客戶行為分析風(fēng)險(xiǎn)管理信用評(píng)估欺詐檢測(cè)流量點(diǎn)擊分析….DataMiningAnalysisServices

-數(shù)據(jù)挖掘DataMiningAgenda商務(wù)智能概述集成服務(wù)分析服務(wù)報(bào)表服務(wù)案例分析SQLServerCatalogReportServerXMLWebService接口ReportProcessing調(diào)度和訂閱發(fā)布目標(biāo)(E-mail,SharePoint,Custom)分發(fā)輸出格式(HTML,Excel,PDF,Custom)數(shù)據(jù)處理數(shù)據(jù)源(SQL,OLEDB,XML/A,ODBC,Oracle,Custom)安全安全機(jī)制(NT,Passport,Custom)Office客戶端應(yīng)用程序?yàn)g覽器ReportingServices

－基本架構(gòu)完全集成在VisualStudio中ReportingServices

－報(bào)表設(shè)計(jì)器報(bào)表生成器ReportBuilderReportingServices

－報(bào)表模型設(shè)計(jì)器ReportingServices支持多種數(shù)字，圖形，Web格式的報(bào)表輸出可以定制開發(fā)新的圖表插件SQLServer2005BIDevelopmentStudio對(duì)于商業(yè)智能開發(fā)完整、集成的工具一種工具實(shí)現(xiàn)多種技術(shù)企業(yè)級(jí)的軟件開發(fā)環(huán)境開發(fā)