Home / IT Books / Oracle Business Intelligence The Condensed Guide to Analysis and Reporting

Oracle Business Intelligence The Condensed Guide to Analysis and Reporting

Oracle Business Intelligence The Condensed Guide to Analysis and Reporting

This book is a quick guide to getting started with Oracle Business Intelligence SE platform that will answer common business questions and help you make quick business decisions. The examples in this book will help you prepare the database for analysis and create business reports in no time. If you are an business analyst, a report builder, a DBA, or an application developer who wants to learn how to use the Oracle Business Intelligence platform for analysis and reporting, this is the perfect book for you. Previous knowledge of Oracle Business Intelligence tools is not required, but you should have a competent grasp of using an Oracle Database.

Oracle Warehouse Builder offers a set of graphical user interfaces allowing you to implement a data store, either relational or dimensional, integrating and consolidating data from a variety of data sources. During building such a data store, also called a warehouse, you create a set of metadata objects within a workspace hosted on an Oracle database.
Oracle Warehouse Builder provides broad data integration facilities, making it a breeze to create Business Intelligence metadata for a wide range of data sources. You might want to use this powerful tool if, for example, you need to derive data from different database systems such as DB2, Informix, SQL Server, and Sybase, as well as flat files, XML, Web, and other disparate sources.

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 data
Aggregating dimensional data
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
Chapter 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
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 Server
Building reports with Reports Builder
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 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
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
Chapter 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
Chapter 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

Oracle Business Intelligence The Condensed Guide to Analysis and Reporting


Top books

About huydam

Check Also

[UWP] The program could not build Windows Universal Samples

If you get this error like this: “Type universe cannot resolve assembly: System.Runtime, Version=4.0.0.0, Culture=neutral, …

Leave a Reply

Your email address will not be published. Required fields are marked *