Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting电子书

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting

Table of Contents

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting

Credits

About the Author

About the Reviewers

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Getting Business Information from Data

Data, information, and Business Intelligence

The kind of business questions you may need to answer

Answering basic business questions

Answering probing analytical questions

Asking business questions using data-access tools

Deriving information from existing data

Answering business questions from your data

Comparing and analyzing data

Accessing transactional and dimensional data

Reporting against a transactional database

Using historical data

Aggregating dimensional data

Summary

2. Introducing Oracle Business Intelligence

What Oracle Business Intelligence is comprised of

Oracle Business Intelligence components

Composing a Business Intelligence system

Sitting on top of Oracle Database

Installing Oracle Business Intelligence software

The software you will need

Where to get the software

Installation process

Installing the Oracle Business Intelligence Tools package

Post-installation tasks

Summary

3. Working with Database Data

Using analytic SQL functions

Answering simple questions

Multidimensional data analysis with SQL

Cubing

Generating reports with only summary rows

Ranking

Windowing

Accessing external sources

Discovering SQL in Discoverer

Relational implementation of the dimensional model

Database structures behind an EUL

Summary

4. Analyzing Data and Creating Reports

Analyzing and reporting with Discoverer

Preparing your working environment with Discoverer Administrator

Exploring the Discoverer Plus IDE

Maintaining a business-oriented view of relational data

Analyzing data

Using Discoverer Viewer

Using Oracle Reports

Starting up the Reports Server

Building reports with Reports Builder

Summary

5. Warehousing for Analysis and Reporting

Data organization in multidimensional data sources

Getting started with Oracle Warehouse Builder

Installing Oracle Warehouse Builder

Creating a Warehouse Builder repository schema

Creating a Warehouse Builder workspace

Building dimensional data stores with Oracle Warehouse Builder

Launching Design Center

Defining source metadata

Creating a source module

Importing database objects

Designing target structures

Creating a target module

Creating dimensions

Creating a Time dimension

Creating a Product dimension

Creating a Region dimension

Creating a cube

Building a staging table

Creating a staging mapping

Loading the staging table with data

Creating mappings for loading data into dimensions

Creating a product mapping

Creating the REGION mapping

Creating a cube mapping

Deploying

Executing

Summary

6. Pivoting Through Data

Making database data available for use in Discoverer

Creating a crosstab worksheet in Discoverer Plus

Pivoting worksheet items

Creating a calculation

Changing the worksheet layout

Pivoting using the drag-and-drop feature

Summary

7. Drilling Data Up and Down

What is drilling?

Drilling to a related item

Drilling up and down

Working with drill hierarchies

Drilling down to see data in more detail

Drilling up to summarize data at a higher level

Drilling from a graph

Using the page items area

Summary

8. Advanced Analysis and Reporting

Using parameters in Discoverer

Analyzing worksheets by entering dynamic input values

Changing the condition behind a parameter

Filtering a worksheet with parameters

Conditional formatting

Making data easier to analyze with sorting

Summary

Index