Cargando…
Oracle Business Intelligence : the condensed guide to analysis and reporting /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham [England] :
Packt Pub.,
©2010.
|
| Colección: | Enterprise : professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 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 dataAggregating dimensional data; Summary; Chapter 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; Chapter 3: Working with Database Data; Using analytic SQL functions; Answering simple questions
- Multidimensional data analysis with SQLCubing; 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; Chapter 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 ServerBuilding reports with Reports Builder; Summary; Chapter 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 cubeBuilding 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; Chapter 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; Chapter 7: Drilling Data Up and Down; What is drilling?