BI商業(yè)智能簡(jiǎn)介.ppt

《BI商業(yè)智能簡(jiǎn)介.ppt》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫(kù)。

1、BI/DWIntroductionJamesChenPSOSr.Consultant程序=算法+數(shù)據(jù)結(jié)構(gòu)--NiklausWirth數(shù)據(jù)結(jié)構(gòu)離散結(jié)構(gòu)線形結(jié)構(gòu)-數(shù)組鏈表?xiàng)ｊ?duì)列樹圖算法空間復(fù)雜度時(shí)間復(fù)雜度用戶內(nèi)存中數(shù)據(jù)結(jié)構(gòu)物理數(shù)據(jù)結(jié)構(gòu)E-R業(yè)務(wù)流程二者相輔相成，不同應(yīng)用側(cè)重不同經(jīng)典業(yè)務(wù)系統(tǒng)模型Skillset數(shù)據(jù)庫(kù)C++/J2EE/.netPowerDesignerER_WINOOUML面向過程OODesignWorkflowDevelopBusinessTypeModelIdentifyBusinessInterfacesIdentifySy

2、stemInterfaces&OpsCreateInitialCompSpecs&ArchitectureDiscoverBusinessOperationsRefineInterfaces&OpsRefineComponentSpecs&ArchitectureDefineInterfaceInformationModelsSpecifyOperationPre/PostconditionsSpecifyComponentInterfaceConstraintsBusinessConceptModelUseCaseModelBusines

3、sInterfacesSystemInterfacesInterfacesInterfacesComponentSpecs&ArchitectureComponentSpecs&ArchitectureComponentSpecs&ArchitectureBusinessTypeModelArchitecturePatternsExistingInterfacesExistingAssetsComponentIdentificationComponentInteractionComponentSpecification笑一笑數(shù)據(jù)倉(cāng)庫(kù)初學(xué)者：

4、數(shù)據(jù)倉(cāng)庫(kù)與數(shù)據(jù)庫(kù)有什么區(qū)別？某專家：一個(gè)有倉(cāng)一個(gè)沒倉(cāng)！BI/DW的引出統(tǒng)計(jì)報(bào)表需求數(shù)字越來越重要報(bào)表越來越多效率越來越差數(shù)據(jù)倉(cāng)庫(kù)的定義“數(shù)據(jù)倉(cāng)庫(kù)是在企業(yè)管理和決策中面向主題的,集成的,與時(shí)間相關(guān)的和不可修改的數(shù)據(jù)集合”BillInmon數(shù)據(jù)倉(cāng)庫(kù)(DataWarehouse)是一種專為聯(lián)機(jī)分析應(yīng)用和決策支持系統(tǒng)提供數(shù)據(jù)源的結(jié)構(gòu)化的數(shù)據(jù)環(huán)境數(shù)據(jù)倉(cāng)庫(kù)要解決的問題是從數(shù)據(jù)庫(kù)中獲取信息的問題。數(shù)據(jù)信息INFORMATIONINFORMATIONINFORMATIONINFORMATION影響數(shù)據(jù)倉(cāng)庫(kù)的幾個(gè)人物BillInmon-《數(shù)據(jù)倉(cāng)庫(kù)》Ralph

5、Kimball-《數(shù)據(jù)倉(cāng)庫(kù)工具箱》BernardLiautaud-《商業(yè)智能》OLTP與數(shù)據(jù)倉(cāng)庫(kù)系統(tǒng)RDBMS關(guān)系數(shù)據(jù)庫(kù)SAP/ERPVSAM主機(jī)系統(tǒng)EXCELWeb/XMLOLTP業(yè)務(wù)系統(tǒng)數(shù)據(jù)倉(cāng)庫(kù)系統(tǒng)數(shù)據(jù)是當(dāng)前的數(shù)據(jù)總在實(shí)時(shí)變化中存儲(chǔ)明細(xì)數(shù)據(jù)優(yōu)化是針對(duì)即時(shí)更新的事務(wù)處理支持日常的業(yè)務(wù)支持辦事人員或行政人員數(shù)據(jù)是歷史的數(shù)據(jù)是靜態(tài)的，除數(shù)據(jù)刷新外數(shù)據(jù)是匯總的優(yōu)化是針對(duì)大批量查詢而不是更新支持長(zhǎng)遠(yuǎn)的業(yè)務(wù)戰(zhàn)略決策支持決策人員和管理人員面向事務(wù)面向決策5-10年數(shù)據(jù)集市分析型CRM業(yè)務(wù)指標(biāo)分析數(shù)據(jù)倉(cāng)庫(kù)BI系統(tǒng)建設(shè)方法（1）直接建立BI應(yīng)用OLTP數(shù)

6、據(jù)源各種前端應(yīng)用KPI指標(biāo)報(bào)表多維分析即席查詢數(shù)據(jù)挖掘數(shù)據(jù)倉(cāng)庫(kù)環(huán)境業(yè)務(wù)智能層中央數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)集結(jié)數(shù)據(jù)源公司數(shù)據(jù)源外部數(shù)據(jù)源BIW數(shù)據(jù)集市數(shù)據(jù)倉(cāng)庫(kù)管理子系統(tǒng)數(shù)據(jù)倉(cāng)庫(kù)元數(shù)據(jù)目錄信息訪問和引用部件BI系統(tǒng)建設(shè)方法（2）企業(yè)數(shù)據(jù)倉(cāng)庫(kù)體系架構(gòu)RelationalPackageLegacyExternalsourceDataCleanToolSourceDataDataStagingWareHouseAdmin.ToolsEnterpriseDataWarehouseDataExtraction,TransformationandloadDat

7、amartDatamartEnterprise/CentralDataWarehouseRDBMSROLAPRDBMSRDBMSArchitectedDatamartsCentralMetadataDataModelingToolEnd-UserToolEnd-UserToolMDBEnd-UserToolEnd-UserToolLocalMetadataLocalMetadata典型物理架構(gòu)ETL_DM1ETL_DM2BAS_DW1BAS_DW2BAS_OP1BAS_OP2Bas_sw01Bas_sw02Dx_sp01Dx_sp02Dx_

8、sp03元數(shù)據(jù)管理服務(wù)器BAS_SM1BAS_SM270T!企業(yè)數(shù)據(jù)倉(cāng)庫(kù)的目的數(shù)據(jù)整合--建立一個(gè)企業(yè)統(tǒng)一的信息平臺(tái)建立統(tǒng)一的業(yè)務(wù)數(shù)據(jù)定義建立唯一的統(tǒng)計(jì)分析數(shù)據(jù)源快速訪問—采用適