Oracle Business Intelligence The Condensed Guide to Analysis and Reporting.
A fast track guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder with this book and eBook.
Saved in:
| Online Access: |
Full text (MCPHS users only) |
|---|---|
| Main Author: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Pub.,
2010
|
| Subjects: | |
| Local Note: | ProQuest Ebook Central |
Table of Contents:
- 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; 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 toolsDeriving 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 needWhere 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 DiscovererPreparing 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 workspaceBuilding 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.
