You are previewing Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting.
O'Reilly logo
Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting

Book Description

A fast track guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder

  • Install, configure, and deploy the components included in Oracle Business Intelligence Suite (SE)

  • Gain a comprehensive overview of components and features of the Oracle Business Intelligence package

  • A fast paced, practical book that provides you with quick steps to answer common business questions and help you make informed business decisions

  • Leverage the computational power of Oracle Database

  • In Detail

    Business Intelligence (BI) is the process of obtaining business information from available data and today, most businesses use BI to control their affairs. With Business Analysis and Reporting in Oracle Business Intelligence, you can quickly learn how to put the power of the Oracle Business Intelligence solutions to work. To jump start with analysis and reporting of data on an Oracle Business Intelligence SE platform and to keep the process of learning simple and interesting requires numerous annotated examples.

    The examples in this introductory guide will make you immediately familiar with tools included in the Oracle Business Intelligence package. This book will teach you how to find answers to common business questions and make informed business decisions as well as helping you to use Oracle Business Intelligence SE platform and prepare database for analysis.

    This practical, example-rich guide starts by explaining concepts behind getting business information from data. We then move smoothly onto the tools included in the Oracle Business Intelligence SE and Oracle Business Intelligence Tools packages. Along the way, we will look at how to take advantage of Discoverer Administrator, Discoverer Plus, and Discoverer Viewer for analysis and reporting. You will also learn how to build, deploy and execute reports using Oracle Reports, and integrate data from different data sources with warehousing, employing Oracle Warehouse Builder software. Covering advanced Oracle Business Intelligence features, this book will teach you how to pivot data, drill it up and down, as well as display it visually in graphs.

    A fast-paced introductory guide to get you up and running swiftly with the tools included in Oracle BI SE

    Table of Contents

    1. Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting
      1. Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting
      2. Credits
      3. About the Author
      4. About the Reviewers
      5. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      6. 1. Getting Business Information from Data
        1. Data, information, and Business Intelligence
        2. The kind of business questions you may need to answer
          1. Answering basic business questions
          2. Answering probing analytical questions
          3. Asking business questions using data-access tools
        3. Deriving information from existing data
          1. Answering business questions from your data
          2. Comparing and analyzing data
        4. Accessing transactional and dimensional data
          1. Reporting against a transactional database
          2. Using historical data
          3. Aggregating dimensional data
        5. Summary
      7. 2. Introducing Oracle Business Intelligence
        1. What Oracle Business Intelligence is comprised of
          1. Oracle Business Intelligence components
          2. Composing a Business Intelligence system
          3. Sitting on top of Oracle Database
        2. Installing Oracle Business Intelligence software
          1. The software you will need
          2. Where to get the software
          3. Installation process
          4. Installing the Oracle Business Intelligence Tools package
          5. Post-installation tasks
        3. Summary
      8. 3. Working with Database Data
        1. Using analytic SQL functions
          1. Answering simple questions
          2. Multidimensional data analysis with SQL
          3. Cubing
          4. Generating reports with only summary rows
          5. Ranking
          6. Windowing
          7. Accessing external sources
          8. Discovering SQL in Discoverer
        2. Relational implementation of the dimensional model
          1. Database structures behind an EUL
        3. Summary
      9. 4. Analyzing Data and Creating Reports
        1. Analyzing and reporting with Discoverer
          1. Preparing your working environment with Discoverer Administrator
          2. Exploring the Discoverer Plus IDE
          3. Maintaining a business-oriented view of relational data
          4. Analyzing data
          5. Using Discoverer Viewer
        2. Using Oracle Reports
          1. Starting up the Reports Server
          2. Building reports with Reports Builder
        3. Summary
      10. 5. Warehousing for Analysis and Reporting
        1. Data organization in multidimensional data sources
        2. Getting started with Oracle Warehouse Builder
          1. Installing Oracle Warehouse Builder
          2. Creating a Warehouse Builder repository schema
          3. Creating a Warehouse Builder workspace
        3. Building dimensional data stores with Oracle Warehouse Builder
          1. Launching Design Center
          2. Defining source metadata
            1. Creating a source module
            2. Importing database objects
          3. Designing target structures
            1. Creating a target module
            2. Creating dimensions
              1. Creating a Time dimension
              2. Creating a Product dimension
              3. Creating a Region dimension
            3. Creating a cube
          4. Building a staging table
          5. Creating a staging mapping
          6. Loading the staging table with data
          7. Creating mappings for loading data into dimensions
            1. Creating a product mapping
            2. Creating the REGION mapping
          8. Creating a cube mapping
          9. Deploying
          10. Executing
        4. Summary
      11. 6. Pivoting Through Data
        1. Making database data available for use in Discoverer
        2. Creating a crosstab worksheet in Discoverer Plus
        3. Pivoting worksheet items
          1. Creating a calculation
          2. Changing the worksheet layout
          3. Pivoting using the drag-and-drop feature
        4. Summary
      12. 7. Drilling Data Up and Down
        1. What is drilling?
        2. Drilling to a related item
        3. Drilling up and down
          1. Working with drill hierarchies
          2. Drilling down to see data in more detail
          3. Drilling up to summarize data at a higher level
        4. Drilling from a graph
        5. Using the page items area
        6. Summary
      13. 8. Advanced Analysis and Reporting
        1. Using parameters in Discoverer
          1. Analyzing worksheets by entering dynamic input values
          2. Changing the condition behind a parameter
          3. Filtering a worksheet with parameters
        2. Conditional formatting
        3. Making data easier to analyze with sorting
        4. Summary