PacktLib: Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting

Credits

About the Author

About the Reviewers

Preface

Getting Business Information from Data

Data, information, and Business Intelligence

The kind of business questions you may need to answer

Deriving information from existing data

Accessing transactional and dimensional data

Summary

Introducing Oracle Business Intelligence

What Oracle Business Intelligence is comprised of

Installing Oracle Business Intelligence software

Summary

Working with Database Data

Using analytic SQL functions

Relational implementation of the dimensional model

Summary

Analyzing Data and Creating Reports

Analyzing and reporting with Discoverer

Using Oracle Reports

Summary

Warehousing for Analysis and Reporting

Data organization in multidimensional data sources

Getting started with Oracle Warehouse Builder

Building dimensional data stores with Oracle Warehouse Builder

Summary

Pivoting Through Data

Making database data available for use in Discoverer

Creating a crosstab worksheet in Discoverer Plus

Pivoting worksheet items

Summary

Drilling Data Up and Down

What is drilling?

Drilling to a related item

Drilling up and down

Drilling from a graph

Using the page items area

Summary

Advanced Analysis and Reporting

Using parameters in Discoverer

Conditional formatting

Making data easier to analyze with sorting

Summary