Copyright
Brief Table of Contents
Table of Contents
Preface
About this Book
Acknowledgments
Chapter 1. Beyond reporting: business analytics
1.1. The need for business analytics
1.2. Replacing static reports with online analytical processing (OLAP)
1.3. OLAP to the rescue
1.3.1. Mondrian lets users drive analysis
1.3.2. Mondrian is a low-cost, low-risk solution
1.3.3. Mondrian is fast
1.3.4. Mondrian is secure
1.3.5. Mondrian is based on open standards
1.4. Summary
Chapter 2. Mondrian: a first look
2.1. Mondrian’s role in analytics
2.2. Running and using Mondrian
2.2.1. Getting and running the software
2.2.2. Navigation and viewing reports
2.2.3. Interactive analytics
2.2.4. MDX analysis with Saiku
2.3. Multidimensional modeling
2.3.1. A simple report
2.3.2. Modeling business questions
2.4. Getting and organizing the data
2.4.1. The data warehouse: physically storing the data
2.4.2. Examining the Adventure Works data
2.4.3. Populating the data
2.5. Summary
Chapter 3. Creating the data mart
3.1. Structuring data for analytics
3.1.1. Characteristics of analytic systems
3.1.2. Data architecture for analytics
3.1.3. Star schemas
3.1.4. Comparing star schemas with 3NF
3.1.5. Star schema benefits
3.2. Additional star schema modeling techniques
3.2.1. Slowly Changing Dimensions (SCDs)
3.2.2. Time dimensions
3.2.3. Snowflake design
3.2.4. Degenerate and combination/junk dimensions
3.3. Summary
Chapter 4. Multidimensional modeling: making analytics data accessible