Oracle Business Intelligence the condensed guide to analysis and reporting. - "A fast track guide to uncovering the analytical power of Oracle Business Intelligence : Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder.". - "Prof

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 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 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 written 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. Cover 1 Copyright 3 Credits 4 About the Author 5 About the Reviewers 6 Table of Contents 8 Preface 12 Chapter 1: Getting Business Information from Data 18 Data, information, and Business Intelligence 19 The kind of business questions you may need to answer 21 Answering basic business questions 21 Answering probing analytical questions 22 Asking business questions using data-access tools 23 Deriving information from existing data 26 Answering business questions from your data 27 Comparing and analyzing data 29 Accessing transactional and dimensional data 31 Reporting against a transactional database 32 Using historical data 32 Aggregating dimensional data 33 Summary 34 Chapter 2: Introducing Oracle Business Intelligence 36 What Oracle Business Intelligence is comprised of 37 Oracle Business Intelligence components 37 Composing a Business Intelligence system 38 Sitting on top of Oracle Database 41 Installing Oracle Business Intelligence software 42 The software you will need 42 Where to get the software 44 Installation process 45 Installing the Oracle Business Intelligence Tools package 52 Post-installation tasks 54 Summary 59 Chapter 3: Working with Database Data 60 Using analytic SQL functions 60 Answering simple questions 61 Multidimensional data analysis with SQL 61 Cubing 65 Generating reports with only summary rows 68 Ranking 69 Windowing 71 Accessing external sources 72 Discovering SQL in Discoverer 74 Relational implementation of the dimensional model 75 Database structures behind an EUL 75 Summary 78 Chapter 4: Analyzing Data and Creating Reports 80 Analyzing and reporting with Discoverer 80 Preparing your working environment with Discoverer Administrator 81 Exploring the Discoverer Plus IDE 86 Maintaining a business-oriented view of relational data 93 Analyzing data 96 Using Discoverer Viewer 99 Using Oracle Reports 102 Starting up the Reports Server 102 Building reports with Reports Builder 104 Summary 109 Chapter 5: Warehousing for Analysis and Reporting 110 Data organization in multidimensional data sources 111 Getting started with Oracle Warehouse Builder 111 Installing Oracle Warehouse Builder 112 Creating a Warehouse Builder repository schema 114 Creating a Warehouse Builder workspace 115 Building dimensional data stores with Oracle Warehouse Builder 119 Launching Design Center 119 Defining source metadata 121 Creating a source module 121 Importing database objects 123 Designing target structures 126 Creating a target module 126 Creating dimensions 128 Creating a cube 131 Building a staging table 132 Creating a staging mapping 133 Loading the staging table with data 139 Creating mappings for loading data into dimensions 140 Creating a product mapping 140 Creating the REGION mapping 141 Creating a cube mapping 141 Deploying 142 Executing 143 Summary 143 Chapter 6: Pivoting Through Data 144 Making database data available for use in Discoverer 144 Creating a crosstab worksheet in Discoverer Plus 147 Pivoting worksheet items 149 Creating a calculation 149 Changing the worksheet layout 150 Pivoting using the drag-and-drop feature 153 Summary 155 Chapter 7: Drilling Data Up and Down 156 What is drilling? 156 Drilling to a related item 157 Drilling up and down 160 Working with drill hierarchies 161 Drilling down to see data in more detail 162 Drilling up to summarize data at a higher level 163 Drilling from a graph 164 Using the page items area 167 Summary 167 Chapter 8: Advanced Analysis and Reporting 168 Using parameters in Discoverer 168 Analyzing worksheets by entering dynamic input values 169 Changing the condition behind a parameter 171 Filtering a worksheet with parameters 172 Conditional formatting 174 Making data easier to analyze with sorting 177 Summary 177 Index 178 www.it-ebooks.info IT eBooks

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.