【正文】 .......................................7 簡化數(shù)據(jù)來源 ....................................................................................................................8 功能上應(yīng)有取有舍 ............................................................................................................8 以數(shù)據(jù)集市為核心組織基礎(chǔ)數(shù)據(jù) ....................................................................................8 系統(tǒng)建設(shè)原則 ........................................................................................................................9 系統(tǒng)的業(yè)務(wù)架構(gòu) ..................................................................................................................10 以針對性營銷為核心的分析架構(gòu) ..................................................................................10 以營銷自動化為核心的處理架構(gòu) ..................................................................................11 以多角色支持為核心的界面架構(gòu) ..................................................................................11 系統(tǒng)的技術(shù)架構(gòu) ..................................................................................................................12 數(shù)據(jù)獲取層 ......................................................................................................................13 數(shù)據(jù)存儲層 ......................................................................................................................13 數(shù)據(jù)展現(xiàn)層 ......................................................................................................................14 元數(shù)據(jù) ..............................................................................................................................15 系統(tǒng)功能結(jié)構(gòu) ......................................................................................................................153 數(shù)據(jù)獲取層 ....................................................................................................................................16 數(shù)據(jù)源分析 ..........................................................................................................................16 系統(tǒng)接口分析 ..................................................................................................................16 ETL 過程 ...................................................................................................................................19 數(shù)據(jù)抽取 ..........................................................................................................................20 數(shù)據(jù)轉(zhuǎn)換 ..........................................................................................................................21 數(shù)據(jù)加載 ..........................................................................................................................23 數(shù)據(jù)審核 ..........................................................................................................................233 / 80 ETL 過程管理 ..................................................................................................................24 ETL 具體實現(xiàn) ..................................................................................................................254 數(shù)據(jù)存儲層 ....................................................................................................................................27 數(shù)據(jù)倉庫信息模型設(shè)計原則 ..............................................................................................27 模型設(shè)計方法 ......................................................................................................................27 數(shù)據(jù)倉庫信息模型 ..............................................................................................................29 數(shù)據(jù)集市構(gòu)建方法 ..............................................................................................................31 OLAP 分析模型 ........................................................................................................................32 OLAP 分析模型建模方法 ...............................................................................................32 OLAP 分析技術(shù)實現(xiàn)方法 ...............................................................................................32 客戶情況分析模型 ..........................................................................................................34 業(yè)務(wù)發(fā)展分析模型 ..........................................................................................................34 收益情況分析模型 ..........................................................................................................35 市場競爭分析模型 ..........................................................................................................365 數(shù)據(jù)展現(xiàn)層 ....................................................................................................................................37 綜合查詢 ..............................................................................................................................37 自定義查詢功能 ..............................................................................................................37 主題查詢功能 ..................................................................................................................37 即席查詢功能 ..................................................................................................................38 統(tǒng)計分析報表 ......................................................................................................................39 統(tǒng)計報表數(shù)據(jù)來源 ..........................................................................................................40 統(tǒng)計報表要素分類 ..........................................................................................................41 預(yù)定義報表 ..........................................................................................................................42 省公司報表 ......................................................................................................................43 本地網(wǎng)報表 ...............................................