數(shù)據(jù)可視化與分析基礎(chǔ)

第 1 章 數(shù)據(jù)分析概述 ............. 1
1.1　大數(shù)據(jù)簡(jiǎn)介..................................................... 1
1.2　數(shù)據(jù)可視化..................................................... 2
1.2.1　數(shù)據(jù)可視化概述...................... 2
1.2.2　在線可視化工具...................... 2
1.2.3　專業(yè)可視化軟件...................... 3
1.3　數(shù)據(jù)挖掘.......................................................... 4
1.3.1　數(shù)據(jù)挖掘概述. ........................ 4
1.3.2　常用數(shù)據(jù)挖掘工具.................. 4
1.4　數(shù)據(jù)分析.......................................................... 5
1.4.1　數(shù)據(jù)分析概述. ........................ 5
1.4.2　數(shù)據(jù)分析的目的與分類.......... 5
1.4.3　數(shù)據(jù)分析的作用...................... 5
1.5　數(shù)據(jù)分析的步驟.......................................... 6
1.6　數(shù)據(jù)分析方法論.......................................... 7
1.7　常見數(shù)據(jù)分析法則..................................... 8
第２章 數(shù)據(jù)可視化初步
2.1　Oracle.DV 產(chǎn)品簡(jiǎn)介............................ 10
2.2　軟件安裝....................................................... 11
2.2.1　硬件要求................................11
2.2.2　安裝 Oracle.DVD...................12
2.2.3　安裝 DVML............................13
2.3　其他數(shù)據(jù)可視化工具............................ 13
2.3.1　Excel.......................................13
2.3.2　Tableau. ..................................13
2.3.3　Power.BI.................................13
2.3.4　ECharts. ..................................14
2.4　Oracle.DVD 功能介紹........................ 14
2.4.1　認(rèn)識(shí)主頁(yè)................................14
2.4.2　連接到文件. ...........................16
2.4.3　連接到數(shù)據(jù)庫(kù). .......................17
2.4.4　創(chuàng)建項(xiàng)目和添加數(shù)據(jù)集.........18
2.4.5　項(xiàng)目的導(dǎo)入導(dǎo)出.....................23
2.4.6　工作界面簡(jiǎn)介. .......................26
2.5　Oracle.DVD 支持的數(shù)據(jù)類型....... 27
2.5.1　定性數(shù)據(jù)與定量數(shù)據(jù).............27
2.5.2　度量和屬性. ...........................32
2.5.3　連續(xù)和離散. ...........................33
2.5.4　數(shù)據(jù)轉(zhuǎn)換選項(xiàng). .......................33
2.6　創(chuàng)作一個(gè)畫布............................................. 35
2.6.1　畫布新建與設(shè)置.....................36
2.6.2　將數(shù)據(jù)添加到可視化畫布.....36
2.6.3　添加多個(gè)可視化圖表.............38
2.6.4　更改可視化類型.....................39
2.6.5　調(diào)整可視化屬性.....................41
2.6.6　顏色設(shè)置................................42
2.6.7　大?。▽挾龋┰O(shè)置.................45
2.6.8　排序和篩選. ...........................45
2.6.9　數(shù)據(jù)的鉆探. ...........................48
2.6.10　用作篩選器. .........................48
2.6.11　導(dǎo)出畫布. .............................49
第 3 章 數(shù)據(jù)可視化進(jìn)階
3.1　運(yùn)算符和表達(dá)式....................................... 51
3.1.1　算術(shù)表達(dá)式. ...........................52
3.1.2　關(guān)系表達(dá)式. ...........................52
3.1.3　邏輯表達(dá)式. ...........................53
3.2　添加計(jì)算....................................................... 53
3.3　主要功能函數(shù)簡(jiǎn)介.................................. 56
3.3.1　COUNT() 函數(shù)......................56
3.3.2　TOPN() 函數(shù)..........................58
3.3.3　Case(if) 函數(shù). ..........................59
3.4　創(chuàng)建圖表....................................................... 61
3.4.1　條形圖....................................61
3.4.2　水平條形圖. ...........................71
3.4.3　線形圖....................................72
3.4.4　面積圖....................................77
3.4.5　餅圖........................................80
3.4.6　旭日?qǐng)D....................................84
3.4.7　雷達(dá)線....................................86
3.4.8　網(wǎng)格熱圖................................88
3.4.9　樹狀圖....................................91
3.4.10　標(biāo)記云..................................92
3.4.11　散點(diǎn)圖..................................95
3.4.12　組合圖表. ........................... 102
3.4.13　瀑布圖................................ 105
3.4.14　箱線圖................................ 108
3.4.15　地圖.................................... 110
3.5　創(chuàng)建故事.................................................... 113
第 4 章 數(shù)據(jù)挖掘基礎(chǔ) .......... 116
4.1　數(shù)據(jù)挖掘概述......................................... 116
4.1.1　數(shù)據(jù)挖掘的分類................... 116
4.1.2　數(shù)據(jù)挖掘的步驟................... 117
4.1.3　數(shù)據(jù)挖掘的應(yīng)用................... 118
4.1.4　數(shù)據(jù)挖掘的案例................... 119
4.2　IBM.SPSS.Modeler.18 簡(jiǎn)介...... 120
4.2.1　軟件下載與安裝................... 121
4.2.2　軟件界面介紹. ..................... 121
4.2.3　數(shù)據(jù)流構(gòu)建. ......................... 123
4.2.4　模型簡(jiǎn)介.............................. 125
4.3　數(shù)據(jù)整理.................................................... 127
4.3.1　數(shù)據(jù)的屬性. ......................... 128
4.3.2　數(shù)據(jù)的角色. ......................... 128
4.3.3　數(shù)據(jù)的導(dǎo)入. ......................... 128
4.3.4　數(shù)據(jù)的集成. ......................... 133
4.3.5　數(shù)據(jù)的導(dǎo)出. ......................... 135
4.4　數(shù)據(jù)建模——決策樹......................... 136
4.4.1　決策樹案例. ......................... 136
4.4.2　用戶畫像案例. ..................... 140
4.5　數(shù)據(jù)建?！P(guān)聯(lián)分析.................... 142
4.5.1　關(guān)聯(lián)參數(shù).............................. 142
4.5.2　關(guān)聯(lián)分析案例. ..................... 144
第 5 章 數(shù)據(jù)分析報(bào)告 .......... 147
5.1　數(shù)據(jù)分析報(bào)告概述............................... 147
5.2　數(shù)據(jù)分析報(bào)告的寫作原則.............. 147
5.3　數(shù)據(jù)分析報(bào)告的結(jié)構(gòu)......................... 148
5.4　數(shù)據(jù)分析報(bào)告排版　......................... 149
第６章 綜合案例（成績(jī)分析） ... 156
6.1　數(shù)據(jù)整理.................................................... 156
6.2　人數(shù)分析.................................................... 163
6.3　生源地分析............................................... 166
6.4　成績(jī)分析.................................................... 166
6.5　敘述............................................................... 171
附錄 A 數(shù)據(jù)分析報(bào)告評(píng)分表
附錄 B 數(shù)據(jù)分析報(bào)告示例...... 173
附錄 C Access 基本操作
參考文獻(xiàn) .................... 194