ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
1.800.803.3948     Email Us

Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading

Oracle BI 11g R1: Analyses, Dashboards Repositories Bootcamp

Format: Instructor-Led Classroom
 
 

This course provides step-by-step instructions for creating analyses and dashboards, which compose business intelligence applications. Participants learn how to administer the Oracle BI Presentation Catalog and to build a simple Oracle BI dashboard starting with basic analyses, then adding more complexity as the course progresses. Participants learn to include pivot tables, graphs, gauges, maps, prompts, embedded content, navigation links, and KPIs on the dashboards. Participants also use Oracle BI Delivers to send real-time, personalized alerts to dashboards and subscribed users, and are introduced to the use of Oracle Business Intelligence Mobile in accessing BI content on their mobile devices.

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.

Participants then extend the initial repository and learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, and partitions. Participants also learn how to implement Oracle BI Server security, manage Oracle BI Server cache, and set up a multi-user development environment.

Learn To:
  • Configure, schedule, and deliver personalized alerts using Oracle BI Delivers
  • Build a dimensional business model to address business intelligence requirements
  • Build and execute analyses to test and verify a dimensional business model analyses
  • Build analyses and dashboards
  • Build and use views and graphs in analyses
  • Create and modify Oracle BI Dashboards
 
 

Skills Gained

 

  • Add geographical mapping to analyses

  • Create and modify Oracle Business Intelligence analyses and dashboards

  • Perform administration tasks related to the development and configuration of dashboards

  • Build and use views and graphs in analyses

  • Perform pre- and post-aggregate filtering using filters, groups, and selections

  • Use Oracle Business Intelligence Mobile to view BI content on a mobile device

  • Configure Agents using Delivers to get the results of analyses and deliver them to subscribers

  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository

 

  • Build and run analyses to test and validate a repository

  • Build simple and calculated measures for a fact table

  • Create logical dimension hierarchies and level-based measures

  • Model aggregate tables to speed query processing

  • Model partitions and fragments to improve application performance and usability

  • Set up security to authenticate users and assign appropriate permissions and privileges

  • Apply cache management techniques to maintain and enhance query performance

Who Can Benefit

 

  • Application Developers

  • Business Analysts

  • Business Intelligence Developer

  • Data Modelers

 

  • Data Warehouse Administrator

  • Data Warehouse Developer

  • Functional Implementer

  • Reports Developer

Prerequisites

 

  • Data warehouse design

  • Database design

 

  • Dimensional modeling

  • Basic SQL
 
Oracle DB PeopleSoft Hyperion This course is taught by Certified Oracle instructors.

ExitCertified is the Oracle University North American Partner of the Year

There is a difference....learn more.
Ask A Question About This Training
Code: D75364GC10
Format: Instructor-Led Classroom
Length: 5
Certified By: Oracle
Tuition (USD): $5,000
Oracle University Awards ExitCertified the Oracle Delivery Partner for 2012
Sort Schedule By: 
No Course Dates There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
   
Request course date Request Course On-Site
Browse Similar Training Classes
 

Oracle BI 11g R1: Analyses, Dashboards Repositories Bootcamp Content Details
 
 
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


  ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
  When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

There is a difference. Learn from the source.		  
     
Training Contacts    
Training Provided Across North America
     
Atlanta Training
Austin Training
Boston Training
Chicago Training
Dallas Training 		Denver Training
Hampton Training
Houston Training
Indianapolis Training
Kansas City Training 		Los Angeles Training
Las Vegas Training
New York Training
Philadelphia Training
Phoenix Training 		Sacramento Training
San Francisco Training
San Jose Training
Tampa Training
Washington Training

View All US Training Centers
Phone:1.800.803.3948 Trust your IT training™
If you have any questions email us and we'll get back to you within 1 business day.
   



(c) 2013 ExitCertified Corp. All rights reserved.


ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
 
Sun Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses,Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, e-Business Suite, MySQL Training, Altiris Training, NetBackup Training, Veritas Training, Symantec CertificationIT Security Training DB2 Training, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class RedHat Training , JBoss Training
         
Cisco Training Apple Training Hitachi - HDS Training Project Management PMI Training VMware Training
Routing and Switching Training, Unified Communications Training, Network Security Training, Data Center Training Apple Course, Leopard Training, Xsan Training