Oracle - Course Details

OraBI11gR1:ADRB Oracle BI 11g R1: Analyses, Dashboards Repositories Bootcamp

Oracle Course Description:
This course also provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Participants use the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. Participants import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, participants learn how to build physical and logical joins, simple measures, and calculation measures.
Oracle Course Duration:
5 DAYS
Oracle Course Target Audience:
Application Developers,Business Analysts,Business Intelligence Developer,Data Modelers,Data Warehouse Administrator,Data Warehouse Developer,Functional Implementer,Reports Developer
Oracle Course Prerequisite:
Data warehouse design,Database design,Dimensional modeling,Basic SQL
Course Content:
  • Working with Oracle Business Intelligence Analyses

    • Introduction to Oracle BI Analysis Editor
    • Oracle BI column types
    • Working with analyses in Oracle BI
    • Using advanced formatting

  • Administering the Presentation Catalog

    • Maintaining the Oracle BI Presentation Catalog in the Catalog page
    • Oracle BI and catalog security overview
    • Managing security using roles
    • Understanding security inheritance
    • Setting object permissions
    • Setting system privileges
    • Archiving catalog items

  • Limiting and Grouping Data in Analyses

    • Introduction to filters and selections
    • Creating, editing, and grouping filters
    • Adding prompts to analyses
    • Dynamic filtering
    • Using saved analyses as filters
    • Creating groups
    • Creating calculated items
    • Creating selection steps

  • Working with Views and Graphs in Analyses

    • Introduction to views, graphs, and editors
    • Working with views in Compound Layouts
    • Creating and editing graphs
    • Linking master-detail views
    • Performing common view tasks

  • Visualizing Data: Gauges, Maps, and Mobile

    • Introduction to Gauge views
    • Working with Gauge views
    • Introduction to Map views and their components
    • Creating and editing Map views
    • Introduction to Oracle Business Intelligence Mobile
    • Working with and searching content in BI Mobile

  • Showing Results With Pivot Tables

    • Introduction to pivot tables
    • Creating, arranging, and formatting a pivot table
    • Using hierarchical columns
    • Sorting in pivot tables
    • Setting aggregation and using totals
    • Showing an item's relative value
    • Building calculations and displaying running sums

  • Creating and Configuring Oracle Business Intelligence Dashboards

    • Creating and editing dashboards
    • Exploring dashboard oject properies and options
    • Publishing dashboard pages
    • Creating personal customizations and using other page options
    • Types of dashboard content
    • Embedding content in dashboards

  • Creating Dashboard Prompts and Variables

    • Introduction to dashboard prompts and prompt types
    • Adding a named dashboard prompt to a dashboard
    • Adding a hidden named dashboard prompt to a dashboard
    • Creating additional prompt page and setting page preferences
    • Variables and prompts
    • Adding variable prompts to a dashboard
    • Wiring dashboard prompts

  • Repository Basics

    • Exploring Oracle BI architecture components
    • Exploring a repository's structure, features, and functions
    • Using the Oracle BI Administration Tool
    • Creating a repository
    • Loading a repository into Oracle BI Server memory

  • Building the Physical Layer of a Repository

    • Importing data sources
    • Setting up connection pool properties
    • Defining keys and joins
    • Examining physical layer object properties
    • Creating alias tables

  • Building the Business Model and Mapping Layer of a Repository

    • Building a business model
    • Building logical tables, columns, and sources
    • Defining logical joins
    • Building measures
    • Examining business model object properties

  • Building the Presentation Layer of a Repository

    • Exploring Presentation layer objects
    • Creating Presentation layer objects
    • Modifying Presentation layer objects
    • Examining Presentation layer object properties

  • Managing Logical Table Sources

    • Adding multiple logical table sources to a logical table
    • Specifying logical content

  • Adding Calculations to a Fact

    • Creating new calculation measures based on existing logical columns
    • Creating new calculation measures based on physical columns
    • Creating new calculation measures using the Calculation Wizard
    • Creating measures using functions

  • Working with Logical Dimensions

    • Creating logical dimension hierarchies
    • Creating level-based measures
    • Creating share measures
    • Creating dimension-specific aggregation rules
    • Creating presentation hierarchies
    • Creating parent-child hierarchies
    • Using calculated members

  • Using Aggregates

    • Modeling aggregate tables to improve query performance
    • Setting the number of elements in a hierarchy
    • Testing aggregate navigation
    • Using the Aggregate Persistence Wizard

  • Using Partitions and Fragments

    • Exploring partition types
    • Modeling partitions in an Oracle BI repository
    • Using the Calculation Wizard to create derived measures

  • Using Repository Variables

    • Creating session variables
    • Creating repository variables
    • Creating initialization blocks
    • Using the Variable Manager
    • Using dynamic repository variables as filters

  • Security

    • Exploring Oracle BI default security settings
    • Creating users and groups
    • Creating application roles
    • Setting up object permissions
    • Setting row-level security (data filters)
    • Setting query limits and timing restrictions

  • Cache Management

    • Restricting tables as non-cacheable
    • Using Cache Manager
    • Inspecting cache reports
    • Purging cache entries
    • Modifying cache parameters and options
    • Seeding the cache

  • Multiuser Development

    • Setting up a multiuser development environment
    • Developing a repository using multiple developers
    • Tracking development project history