Shopping Cart
Your Cart is Empty
View Cart
  
 
 
 
Textbooks & Training Courseware
Oracle 12c
Oracle 11g
Oracle Database 11g: SQL & PL/SQL Programming
Oracle Database 11g: Administrator
Oracle High Availability 11g
Oracle Data Warehouse 11g
ora11g300-ver1
tt-oracle-bi-350
Oracle Training Courseware 11g Complete List
Oracle11g eTextbooks Complete List
Oracle 10g
Oracle Certification
Microsoft
Adobe & PHP

ora11g330-ver1

Oracle BI 11g: Create Analyses & Dashboards (2 day)

Description

This textbook offers an exhaustive, step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. One will learn the concepts, methods and techniques for building sophisticated data analytic modules. Analytic results are then organized into interactive dashboards. A solid foundation is laid for one to progress onto the latest and most advanced data analytic capabilities.

Audience

The target audience for this course is any business professional seeking to analyze enterprise-wide or departmental information collected into an organization data warehouse. Among those for whom this course might be particularly useful would be:
• Data architects
• Data warehouse administrators and analysts
• Business analysts
• Financial managers
• Market research professionals
• Human resource managers
• Procurement and vendor management professionals
• Field representatives
• Business development managers

Prerequisites

It is assumed that you have access to a valid installation of the Oracle WebLogic Server and a deployment of the Oracle BI Server. Therefore, it is a mandatory prerequisite that this environment be configured in advance. A step-by-step guide to creating such an installation along with overview information about the technical architecture which supports these platforms is provided in the Sideris textbook
• ORACLE FUSION MIDDLEWARE 11G: WEBLOGIC & BI SERVER ARCHITECTURE & INSTALLATION.

Advanced or power users who may not be responsible for the actual installation but who are interested in Oracle BI architecture and administration topics may consider that textbook to be an optional prerequisite.

Otherwise, a general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.

Suggested Next Courses

After completing this textbook, advanced users should proceed onto the next textbook in the Sideris Oracle BI learning series entitled
• ORACLE BI 11G: ADVANCED ANALYSES FOR POWER USERS.

Instructor Resources

Instructor resources from the Sideris Training Portal combined with Sideris custom print courseware make distance-learning and virtual training more effective than ever! Available for download when you purchase this title. Please turn on your audio, make sure you have the latest version of Adobe Reader and then watch the demo to see how these new instructor resources improve your instructor’s presentations!

Objectives

The following specific topics are included in this guide book:
• Background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
• Background concepts regarding logical data models, star schema and snowflake schema warehouse models.
• How to build analytical models using fact tables, dimensions, dimension hierarchies, cubes, measures and other multidimensional data model objects.
• Use interactive Dashboards to analyze data, uncover trends and make strategic business decisions.
• Export BI results to productivity software such as Microsoft Office or other external systems.
• Design customized Dashboards to reflect an individual's role, perspective or business interest.
• Creating data analyses and dynamically interact with results produced from Oracle BI.
• Format analyses using sorts, filters and prompts.
• Format column output, subtotaling, customization of column properties and transforming column data using formulas.
• Create results with compound layouts, including views such as tabular, chart, pivot table, gauge and others.
• Manage content, permissions and access within the Presentation Catalog.

This textbook includes dozens of learning exercises, with detailed point-and-click solutions also provided.

CONTENTS

DATA WAREHOUSING, BUSINESS INTELLIGENCE & DATA ANALYTICS
GETTING STARTED WITH ORACLE BI
USING A DASHBOARD
CREATING AN ANALYSIS
SELECTING & ORDERING DATA
COLUMN FORMATTING
EMPLOYING TABLE & TITLE VIEWS
EMPLOYING GRAPH & GAUGE VIEWS
EMPLOYING PIVOT TABLE VIEWS
EMPLOYING SECONDARY VIEWS
DEPLOYING ANALYSES TO DASHBOARDS
BUILDING A DASHBOARD




Download PDF outline here!


Oracle courseware, Oracle course books and training materials
Oracle BI 11g: Create Analyses & Dashboards
 
Price: $79.00
  1  
  494 pages  
 
Consider these advanced courses relating to Business Intelligence (BI) and data warehousing
ora11g205-ver1
 
Oracle Database 11g: Data Warehousing & Oracle Warehouse Builder
Price: $195.00
  1.0  
  758 pages  
 
ora11g300-ver1
 
Oracle Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation
Price: $39.00
  1  
  180 pages