Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting

A fast track Oracle book and eBook guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder.
Preview in Mapt
Code Files

Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting

Yuli Vasiliev

A fast track Oracle book and eBook guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$16.80
RRP $23.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$16.80
$39.99
$29.99p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting Book Cover
Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting
$ 23.99
$ 16.80
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 Book Cover
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
$ 29.99
$ 21.00
Buy 2 for $34.30
Save $19.68
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781849681186
Paperback184 pages

Book Description

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.

Table of Contents

Chapter 1: Getting Business Information from Data
Data, information, and Business Intelligence
The kind of business questions you may need to answer
Deriving information from existing data
Accessing transactional and dimensional data
Summary
Chapter 2: Introducing Oracle Business Intelligence
What Oracle Business Intelligence is comprised of
Installing Oracle Business Intelligence software
Summary
Chapter 3: Working with Database Data
Using analytic SQL functions
Relational implementation of the dimensional model
Summary
Chapter 4: Analyzing Data and Creating Reports
Analyzing and reporting with Discoverer
Using Oracle Reports
Summary
Chapter 5: Warehousing for Analysis and Reporting
Data organization in multidimensional data sources
Getting started with Oracle Warehouse Builder
Building dimensional data stores with Oracle Warehouse Builder
Summary
Chapter 6: Pivoting Through Data
Making database data available for use in Discoverer
Creating a crosstab worksheet in Discoverer Plus
Pivoting worksheet items
Summary
Chapter 7: Drilling Data Up and Down
What is drilling?
Drilling to a related item
Drilling up and down
Drilling from a graph
Using the page items area
Summary
Chapter 8: Advanced Analysis and Reporting
Using parameters in Discoverer
Conditional formatting
Making data easier to analyze with sorting
Summary

What You Will Learn

  • 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

Authors

Table of Contents

Chapter 1: Getting Business Information from Data
Data, information, and Business Intelligence
The kind of business questions you may need to answer
Deriving information from existing data
Accessing transactional and dimensional data
Summary
Chapter 2: Introducing Oracle Business Intelligence
What Oracle Business Intelligence is comprised of
Installing Oracle Business Intelligence software
Summary
Chapter 3: Working with Database Data
Using analytic SQL functions
Relational implementation of the dimensional model
Summary
Chapter 4: Analyzing Data and Creating Reports
Analyzing and reporting with Discoverer
Using Oracle Reports
Summary
Chapter 5: Warehousing for Analysis and Reporting
Data organization in multidimensional data sources
Getting started with Oracle Warehouse Builder
Building dimensional data stores with Oracle Warehouse Builder
Summary
Chapter 6: Pivoting Through Data
Making database data available for use in Discoverer
Creating a crosstab worksheet in Discoverer Plus
Pivoting worksheet items
Summary
Chapter 7: Drilling Data Up and Down
What is drilling?
Drilling to a related item
Drilling up and down
Drilling from a graph
Using the page items area
Summary
Chapter 8: Advanced Analysis and Reporting
Using parameters in Discoverer
Conditional formatting
Making data easier to analyze with sorting
Summary

Book Details

ISBN 139781849681186
Paperback184 pages
Read More

Read More Reviews

Recommended for You

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial Book Cover
Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial
$ 35.99
$ 25.20
Oracle SOA Suite 11g R1 Developer's Guide Book Cover
Oracle SOA Suite 11g R1 Developer's Guide
$ 35.99
$ 25.20
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Book Cover
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$ 35.99
$ 25.20
Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology Book Cover
Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology
$ 35.99
$ 25.20
Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting Book Cover
Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
$ 29.99
$ 21.00