文件名称：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