Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting


Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting
eBook: $23.99
Formats: PDF, PacktLib, ePub and Mobi formats
$20.39
save 15%!
Print + free eBook + free PacktLib access to the book: $63.98    Print cover: $39.99
$39.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
 
  • 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

Book Details

Language : English
Paperback : 184 pages [ 235mm x 191mm ]
Release Date : October 2010
ISBN : 184968118X
ISBN 13 : 9781849681186
Author(s) : Yuli Vasiliev
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Applications, Oracle Database, Oracle Fusion Middleware, Enterprise, Oracle


Table of Contents

Preface
Chapter 1: Getting Business Information from Data
Chapter 2: Introducing Oracle Business Intelligence
Chapter 3: Working with Database Data
Chapter 4: Analyzing Data and Creating Reports
Chapter 5: Warehousing for Analysis and Reporting
Chapter 6: Pivoting Through Data
Chapter 7: Drilling Data Up and Down
Chapter 8: Advanced Analysis and Reporting
Index
  • 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
    • 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 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
  • 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
    • 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 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
  • 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?
    • 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
  • 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
    • Summary

Yuli Vasiliev

Yuli Vasiliev is a software developer, freelance author, and consultant currently specializing in open-source development, Oracle technologies, and service-oriented architecture (SOA). He has over 10 years of software development experience as well as several years of technical writing experience. He wrote a series of technical articles for Oracle Technology Network (OTN) and Oracle Magazine.

Contact Yuli Vasiliev

Sorry, we don't have any reviews for this title yet.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting +    Oracle Essbase 9 Implementation Guide =
50% Off
the second eBook
Price for both: £24.75

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Install and configure Oracle Business Intelligence SE suite and Oracle Business Intelligence Tools suite
  • Perform multidimensional data analysis through the prism of SQL
  • Understand database structures behind Business Intelligence metadata components
  • Perform analysis and prepare reports using the Oracle Business Intelligence SE  components— Discoverer Administrator, Discoverer Plus and Discoverer Viewer
  • Build, deploy and execute reports using Oracle Reports—Reports Server and Reports Builder
  • Integrate data from different transactional systems and facilitate business analysis with warehousing
  • Take advantage of the slice and dice capability to change the layout or contents of an Oracle BI Discoverer Plus report
  • Arrange data for effective analysis by use of pivoting
  • Drill data up and down and navigate the Discoverer worksheet to process data
  • Use analytic SQL functions to answer business questions
  • Unveil the power of your business data with Oracle Discoverer
  • Analyze data and prepare business reports using Oracle Reports
  • Build a data warehouse with Oracle Warehouse Builder

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

Approach

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.

Who this book is for

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software