【文件属性】:
文件名称:Manning.Mondrian_in_Action.2013.pdf
文件大小:12.74MB
文件格式:PDF
更新时间:2022-09-15 14:16:17
Mondrian olap 多维建模 Pentaho saiku
preface xiii
about this book xiv
acknowledgments xviii
1 Beyond reporting: business analytics 1
1.1 The need for business analytics 2
1.2 Replacing static reports with online analytical processing
(OLAP) 4
1.3 OLAP to the rescue 8
Mondrian lets users drive analysis 8 ■ Mondrian is a low-cost,
low-risk solution 11 ■ Mondrian is fast 13 ■ Mondrian is
secure 14 ■ Mondrian is based on open standards 14
1.4 Summary 15
2 Mondrian: a first look 17
2.1 Mondrian’s role in analytics 18
2.2 Running and using Mondrian 19
Getting and running the software 20 ■ Navigation and viewing
reports 22 ■ Interactive analytics 24 ■ MDX analysis with
Saiku 25
www.it-ebooks.info
viii CONTENTS
2.3 Multidimensional modeling 27
A simple report 27 ■ Modeling business questions 28
2.4 Getting and organizing the data 30
The data warehouse: physically storing the data 31 ■ Examining
the Adventure Works data 32 ■ Populating the data 33
2.5 Summary 34
3 Creating the data mart 36
3.1 Structuring data for analytics 37
Characteristics of analytic systems 37 ■ Data architecture for
analytics 38 ■ Star schemas 40 ■ Comparing star schemas with
3NF 42 ■ Star schema benefits 43
3.2 Additional star schema modeling techniques 44
Slowly Changing Dimensions (SCDs) 44 ■ Time dimensions