Data Warehousing and Oracle BI Oracle BI 10g: Analytics Overview - LVC Eğitim Süresi: 6 Saat Neler Öğreneceksiniz: Katılımcı Profili: Functional Implementer
Technical Consultant Ön Şartlar: Suggested Prerequisites
Domain experience in business intelligence, data warehouse design, and database design Hedefler: Enable students to gain a foundational understanding of the prebuilt components of Oracle Business Intelligence Applications
Enable students to gain a foundational understanding of business intelligence concepts, Oracle BI Enterprise Edition architecture Eğitim İçeriği: Oracle Business Intelligence Enterprise Edition: Overview
Define and describe business analytics and business intelligence
Identify the analytical business challenge and the solution provided by Oracle BI products
Copyright © 2009, Oracle. All rights reserved. Page 1
Define and describe data warehousing and data modeling
Identify and describe the Oracle BI Enterprise Edition products used to support business intelligence requirements
Exploring the Oracle BI Enterprise Edition User Interface
Use Oracle BI Answers to construct, modify, and save analytics requests
Navigate a Oracle BI Analytics Intelligence Dashboard
Oracle BI Enterprise Edition Architecture
Identify the major components that make up the Oracle BI Enterprise Edition architecture
Describe the role of key components in the architecture
Describe the relationships among the components
Oracle BI Enterprise Edition Repository Basics
Identify and describe the three layers of an Oracle BI Repository and how they relate to one another
Use the Oracle BI Administration Tool to explore repository objects
Identify and describe repository features and functions
Oracle Business Intelligence Applications
Identify and describe the prebuilt components of Oracle Business Intelligence Applications
Integration with Oracle BI Publisher
Publish a BI Publisher report created from Answers request
Publish a BI Publisher report created from BI Server repository Oracle BI Applications 7.9: Develop a Data Warehouse - LVC Eğitim Süresi: 30 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Developer
Database Administrators
Technical Consultant Ön Şartlar: Required Prerequisites
Oracle BI 10g: Analytics Overview - RWC
Suggested Prerequisites
Ability to navigate within transactional applications
Understanding of underlying architecture of transactional
Working knowledge of Informatica PowerMart or PowerCenter
Domain experience in Business Intelligence, data warehouse Hedefler: Install the Oracle Business Analytics Warehouse (OBAW)
Configure the Oracle Business Analytics Warehouse
Install Informatica PowerCenter
Use the Informatica Designer to configure the OBAW components
Describe ETL for OBAW
Examine Source Dependent Extract (SDE) mappings
Examine Source Independent Load (SIL) ETL mappings
Customize the OBAW
Customize the OBAW using ERP data
Customize the OBAW using CRM data
Customize the OBAW Using the Universal Adaptor
Explore the Change Data Capture Process
Build Auxiliary Change Capture
Build Slowly Changing Dimensions
Capture and Apply Deletes in the CRM Transactional Database
Manage OBAW Performance Eğitim İçeriği: Oracle Business Intelligence Application Overview
Describing the Oracle Business Intelligence Applications
Describing Oracle Business Intelligence Applications components
Describing analytic workflows and application integration
Oracle Business Intelligence Applications Architecture Overview
Describing the Oracle Business Intelligence logical architecture
Describing the process flow of building the data warehouse
Employing the recommended deployment options to maximize data warehouse performance
Listing the components supporting the Oracle Business Analytics Warehouse and the functions performed by each core component
Oracle Business Analytics Warehouse Content
Describing the contents of the Oracle Business Analytics Warehouse
Describing the warehouse tables
Installing Oracle Business Analytics Warehouse Components
Installing the components on each machine in an Oracle Business Analytics Warehouse implementation
Detailing the required steps for each installation
Explaining the use of components on each machine
Identifying steps to grant access to Oracle Business Analytics Warehouse from Oracle Business Intelligence applications
Understanding the ETL Process
Understanding the Extraction, Transformation, and Loading (ETL) process used to load Oracle Business Analytics Warehouse (OBAW)
Describing the full and incremental load of the OBAW
Identifying the tables, tasks, and mappings used to support ETL processing
Working with Informatica Designer
Identifying the Informatica Repository objects used to configure the OBAW
Navigating the set of tools in the Informatica Designer used to configure the OBAW
Describing the process for building Oracle mappings using Informatica Designer
Exploring SDE and SIL Mappings
Defining extract and load workflows
Describing the difference between Source Dependent Extract (SDE) and Source Independent Load (SIL) sessions
Identifying transformations and their mechanics in Source Dependent Extract and Source Independent Load mappings
Exploring out-of-the-box map-lets and reusable transformations
Explaining the differences between SIL dimension and fact mappings
Building SDE and SIL Mappings
Describing the process of building mappings using Informatica Designer
Creating mapping sources and targets
Copying, modifying, and validating mappings
Working with Informatica Workflow Manager
Navigating Informatica Workflow Manager
Running workflows and sessions using Informatica Workflow Manager
Describing the steps for creating, running, and troubleshooting workflows and sessions
Working with Data Warehouse Administration Console
Using the tools and views of the Data Warehouse Administration Console (DAC)
Describing DAC objects, how they relate to each other, and their roles in the OBAW ETL
Examining the internal DAC tasks
Creating custom execution plans and subject areas in DAC
Generating scutom DDL using DAC Schema Manager
Populating Oracle Business Analytics Warehouse
Exploring prebuilt ETL execution plans
Running and viewing exception reports using DAC
Examining exception types
Loading the OBAW using DAC
Troubleshooting the load process
Configuring Oracle Business Analytics Warehouse
Reviewing configuration types
Identifying the performance benefits of ETL configuration: Research and Analysis using DAC
Configuring ETL to increase performance
Examining the impact on Auto Dependency Engine analysis
Customizing Oracle Business Analytics Warehouse
Examining customization types and scenarios
Examining customization considerations
Examining customization leading practices and requirements
Adding Columns to an Existing Dimension Table
Describing the steps in a Type I customization of the Oracle Business Analytics Warehouse
Modifying custom mapping templates to perform a Type I customization
Creating workflows and sessions for a Type I customization
Creating DAC tasks and assigning source and target tables
Generating task dependencies
Running a custom execution plan to add data to an existing table in OBAW
Validating results
Adding a New Dimension in OBAW
Describing the steps and examples of a Type II customization of the Oracle Business Analytics Warehouse, bringing in custom data Adding a new table to the OBAW and creating required foreign keys
Registering new tables in the DAC
Creating and running mappings and sessions for a Type II customization
Exploring the Change Capture Process
Describing the change capture process
Describing and generating change capture tables
Describing and generating change capture views
Describing and generating change capture SQL
Using the change capture filter
Capturing and Applying Deletes
Identifying business scenarios where records are deleted in the transactional database creating the need to capture the changes Generating delete triggers
Executing delete triggers
Building mappings to capture and extract deletes from the transactional database
Building mappings to apply deletes to the OBAW
Building sessions and workflows to apply the deletes to the OBAW
Configuring the DAC to load the deleted rows onto the OBAW
Loading the deleted rows onto the OBAW
Building Auxiliary Change Capture
Describing auxiliary change capture
Identifying the business need to perform auxiliary change capture
Building the image table for auxiliary tables
Creating auxiliary change capture mapping
Creating sessions and workflows for auxiliary change capture process
Configuring the DAC to perform the auxiliary change capture process
Defining dependencies, building the image flag, and describing auxiliary source tables
Running ETL and validating results
Managing OBAW Performance
Reviewing performance trade-offs
Reviewing common performance bottlenecks
Explaining Informatica Server throughput
Reviewing ETL parallel processing guidelines
Reviewing recommended Informatica Server parameter settings
Reviewing database server throughput and indexes
Managing optimizer statistics
Managing OBAW schema objects Oracle BI Applications 7.9: Implementation for Oracle EBS - LVC Eğitim Süresi: 24 Saat Neler Öğreneceksiniz: Katılımcı Profili: Application Developers Business Intelligence Developer Data Modelers Data Warehouse Administrator Data Warehouse Analyst Data Warehouse Developer Technical Consultant
Ön Şartlar: Oracle BI 10g: Analytics Overview - RWC
Oracle BI Suite EE 10g R3: Build Repositories
Oracle BI Suite EE 10g R3: Create Reports and Dashboards
Suggested Prerequisites
Working knowledge of Informatica PowerMart or PowerCenter
Basic knowledge of SQL
Experience in business intelligence
Dimensional modeling, database design Hedefler: Use the Data Warehouse Administration Console (DAC) to run ETL routines to populate the OBAW
Customize DAC metadata
Customize and extend the OBAW
Manage the security and performance of Oracle BI Applications
Explore Oracle Business Intelligence Applications and the Oracle Business Analytics Warehouse (OBAW) foundational concepts Install and configure Oracle BI Applications
Explore the prebuilt extract, transform, and load (ETL) metadata for Oracle BI Applications Eğitim İçeriği: Oracle Business Intelligence Applications Overview
Exploring Oracle Business Intelligence (BI) Applications
Exploring the key components of Oracle BI Applications
Exploring Oracle BI Applications integration with transactional applications
Oracle Business Intelligence Applications Architecture Overview
Exploring the Oracle BI Applications logical architecture
Exploring the process flow of building the data warehouse
Employing the recommended deployment options to maximize data warehouse performance
Exploring the core components supporting the Oracle Business Analytics Warehouse (OBAW) and the functions performed by each
Oracle Business Analytics Warehouse Content
Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
Exploring OBAW tables
Installing and Configuring Oracle BI Applications and Related Components
Understanding the ETL Process
Exploring the extract, transform, and load (ETL) process used to load the Oracle Business Analytics Warehouse (OBAW)
Identifying the differences between a full load and an incremental load of the OBAW
Identifying the applications and mechanisms used to support the ETL process
Working with Informatica Designer
Identifying the Informatica repository objects used to configure the Oracle Business Analytics Warehouse (OBAW)
Navigating the set of tools in Informatica Designer used to configure Informatica repository objects
Working with Informatica Workflow Manager
Copyright © 2010, Oracle. All rights reserved. Page 2
Navigating Informatica Workflow Manager
Running workflows and sessions using Informatica Workflow Manager
Monitoring workflows using Informatica Workflow Monitor
Exploring SDE and SIL Mappings
Describing the differences between Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
Identifying typical objects and their mechanics in SDE and SIL mappings
Working with the Data Warehouse Administration Console (DAC)
Using the tools and views of the Data Warehouse Administration Console (DAC)
Describing DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract
Configuring Analytical Applications
Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source system
Configuring general ledger account hierarchies using general ledger accounting flexfield value set definitions
Mapping Oracle general ledger natural accounts to group account numbers
Creating a new metric in the repository after adding a new group account number
Customizing DAC Metadata and Running and Execution Plan
Creating custom metadata objects in the DAC
Running a DAC execution plan and monitoring the results
Customizing the Oracle Business Analytics Warehouse (OBAW)
Identifying and describing customization types and scenarios associated with OBAW
Applying OBAW customization best practices
Adding Columns to an Existing Dimension Table
Completing the steps in a Type I customization of the OBAW
Adding a column to an existing dimension table in the OBAW and populating it with data
Adding a New Dimension in OBAW
Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
Integrating Security for Oracle BI Applications
Exploring the types of security in Oracle Business Intelligence Applications
Synchronizing Oracle BI Application user groups with EBS responsibilities
Identifying how BI Application authorization integrates with EBS responsibilities
Describing a typical data security integration
Managing OBAW Performance
Exploring strategies for increasing extract, transform, and load (ETL) and query performance
Identifying common performance bottlenecks
Configuring servers to optimize ETL and query performance Oracle BI Discoverer Administrator 11g: Develop an EUL - LVC Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Administrator
Business Intelligence Developer
Data Warehouse Analyst
Developer Ön Şartlar: Required Prerequisites
Oracle Database 11g: SQL Fundamentals II
Oracle Database 11g: SQL Fundamentals I
Suggested Prerequisites
Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data
Oracle Database 11g: Data Warehousing Fundamentals Ed 1 Hedefler: Control user access to EUL, and business areas
Create item classes, analytical and aggregate items, and drills
Create summaries to improve query
Manage multiple EULs
Design, create, maintain, and customize the EUL Eğitim İçeriği: Introduction to Oracle BI Discoverer Administrator: Develop an EUL
Oracle's BI Solution
Oracle's BI Solution Components
Oracle BI Discoverer Components
Discoverer Administrator
Role of the Discoverer Administrator
Key Terminology
Building a Business Area
Data Model
Creating the End User Layer and Business Areas
Discoverer Connections
Creating the EUL
Creating Folders and Business Areas
Importing and Exporting the EUL
EUL Security and Privileges
Creating Lists of Values (LOVs), Alternative Sorts, and Conditions
Creating Item Classes
Creating LOVs
Creating Alternative Sorts
Creating Conditions
About Optional Conditions
About Mandatory Conditions
Creating Advanced Conditions
Customizing Properties, Creating Calculated Items, and Registering PL/SQL Functions
Formatting Folders and Items
Customizing Folder Properties
About Indexed Item Properties
Creating a Simple Calculation
Creating a Complex Calculation
About PL/SQL Functions
Creating Complex and Custom Folders
Creating Joins
Creating Multi-item Joins
About Join Options
Creating Complex Folders
Assigning Items to Complex Folders
Complex Folder Reach-through
Creating a Custom Folder
Creating Custom LOVs
Creating Analytical and Aggregate Items
About Analytical Items
Using Analytical Functions
Administration Calculations
Types of Calculations
Derived Items
Aggregate Calculations
Derived Aggregate Calculations
Nested and User-defined Aggregates
Creating Drills
About Drill Structures
Creating Drills
Filtering Drills
Designing an Item Hierarchy
Creating Drill to Detail
About Date Hierarchies
Creating and Maintaining Date Hierarchies
Nonstandard Calendars
Creating and Managing Summary Folders
About Materialized Views
Summary Management
Creating Summary Folders Using EUL Items
About Database Storage
Creating Summary Folders Using Query Statistics
About External Summary Tables
Creating Summary Folders Using External Summary Tables
Summary Combination Strategies
Automated Summary Management (ASM)
About ASM
ASM Process
Executing ASM
Running ASM After Bulk Load
ASM Advanced Settings
Managing Batch Scheduling
Scheduling Workbooks
Managing Workbooks
About the Batch Reports Process
Creating a Batch Repository
Managing Scheduled Workbooks
Maintaining the EUL
Effects of Database Changes on Queries
Refreshing the Database and Business Areas
Managing Folders
About Orphaned Folders
Deleting Business Areas
Migrating from Development to Production
Support for Multiple Schemas
Workbooks for EUL Analysis
Administering Multiple EULs and Automating Tasks
Creating an EUL for a New User
Deleting an EUL
Installing the Sample Data
About Multiple EULs
Discoverer Administrator Command-line Interface
Using a Command File
Discoverer EUL Command-line for Java
Case Study Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data - LVC Eğitim Süresi: 12 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Analysts
Business Intelligence Developer
End Users
Sales Consultants Ön Şartlar: Suggested Prerequisites
Familiarity with Web browsers
Basic knowledge of SQL Hedefler: Use Oracle BI Discoverer Plus Relational to access a relational data source
Use Oracle BI Discoverer Plus OLAP to access a multidimensional data source
Create ad hoc queries and advanced reports based on relational or multidimensional data
Create exception or stoplight formatting
Use graphs to present data
Analyze data using drilling and pivoting
Generate parameterized reports
Create calculations and conditions
Schedule reports
Share reports with other users through Discoverer Viewer and Oracle Portal Eğitim İçeriği: Introducing Oracle BI Discoverer 11g
Challenges faced in managing BI applications
Evolving role of Business Intelligence
Addressing BI Requirements- Portfolio Approach
Oracle Fusion Middleware 11g- An Overview
Fusion Middleware BI Solution
Components of Oracle BI Discoverer 11g
Getting Started with Ad Hoc Queries Using Discoverer Plus Relational
Data Warehouse Versus Transactional System
Using Discoverer with a Data Warehouse or a Transactional Database
End Users
Getting helpful Information
Key Terminology
Creating Reports
Editing the query output by Sorting, Pivoting, Adding and Deleting items
Customizing Display properties of reports
Managing Relational Queries
Managing Workbooks and Worksheets
Adding New Worksheets
Viewing and Modifying Worksheet Properties
Setting Query Management, Query Execution, and Query Governor Options
Using Discoverer URL Parameters
Creating Advanced Reports Using Discoverer Plus Relational
Using Conditional Formatting
Using Predefined Conditions
Creating and Managing Conditions
Creating A Parameterized Report
Creating Parameters
Passing Parameters to a Condition
Using Cascading Parameters
Using Advanced Calculations and Summary Functions with Discoverer Plus Relational
Creating Totals, Subtotals, and Percentages
Creating Simple and Complex Calculations
Using Analytic Function Template in Calculations
Using Calculations in Conditions
Passing a Parameter Value to a Condition
Using Graphs to Present Data in Discoverer Plus Relational
Viewing Graphs to Display Worksheet Data
Editing Graphs
Using the Toolbar Options to Edit Graphs
Analyzing Data Using Drills in Discoverer Plus Relational
Identifying Different Types of Drilling
Drilling up Or Drilling down along a predefined hierarchy
Drilling to a Related Item
Drilling to Detail
Drilling to a Link
Scheduling and Distributing Reports Using Discoverer Plus Relational
Scheduling Reports- An Overview
Scheduling A Workbook in Discoverer Plus Relational
Managing Scheduled Workbooks
Sharing Scheduled Workbooks
Exporting the Query Results to Various Formats- MS Excel, HTML, PDF, Web Query for MS Excel, and so on.
Printing Query Results
Describing the OLAP Data Model
Describing the Differences between Relational and Multidimensional Data Models
Describing the Primary data types associated with the OLAP Data models :
- Dimensions
- Measures
- Cubes
- Hierarchies
- Analytic Workspace, and so on.
Getting Started with Discoverer Plus OLAP
Creating a workbook, and a worksheet using Discoverer Plus OLAP
Creating and Editing OLAP Queries
Creating and Using Saved Selections
Creating and Using Calculations
Modifying the Layout and Format of Crosstabs and Graphs
Building Advanced Reports Using Discoverer Plus OLAP
Adding new worksheets
Creating reports based on ranking and exception criteria
Adding visual cues (stoplights) to the report that highlight specific data ranges
Creating reports using time-series calculations
Creating and using calculated (custom) members in a report
Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets
Understanding distribution options for Discoverer Plus reports
Using Discoverer Viewer to access Discoverer Plus reports (both Relational and OLAP reports)
Describing how to publish Discoverer Plus reports on Oracle Portal pages Oracle BI Publisher 10g R3: Fundamentals Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Analysts
Business Intelligence Developer
End Users
Functional Implementer
Reports Developer
Technical Consultant Ön Şartlar: Required Prerequisites
Oracle 10g: XML Fundamentals Hedefler: Create and use a portable document format (PDF) template
Create and use a rich text format (RTF) template
Describe the integration capabilities of Oracle BI Publisher and Oracle BI Enterprise Edition
Understand the underlying X standards
Set up, configure, and use the Oracle BI Publisher Enterprise server
Schedule reports and analyze data
Create XML Data template
Analyze data using Excel analyzer Eğitim İçeriği: Introduction to BI Publisher
Oracle BI Publisher: Business Document Requirements
Functions of Reporting Systems
Oracle BI Publisher Paradigm
End-to-End View and Salient Features of BI Publisher
Oracle BI Publisher: Technology and Architecture
Describe the components of Oracle BI Publisher
Describe the architecture of Oracle BI Publisher
Describe the Oracle BI Publisher Underlying Technology
Introduction to XML Standards
Describe Extensible Markup Language (XML), Extensible Stylesheet Language (XSL), and other X Standards objects
List the components of an XML document
Create a well-formed XML document
Describe XML namespaces, document type definition (DTD), XML Schema, and XML Path Language (Xpath)
Describe XSL and XSL Transformations (XSLT)
Getting Started with BI Publisher: Creating a Simple Report
Describe the sample schemas used in course practices (HR,OE, and SH)
Set up a database connection in BI Publisher
Opening and viewing a Predefined Report
Create a BI Publisher Report Based on Oracle Database
Edit the Properties of a Report
Upload an existing template for the report and view data
Export or download a BI Publisher report
Creating Simple RTF Templates
Describe the functions and features of BI Publisher Desktop
Describe how to install BI Publisher Desktop
Create RTF templates for a sample report
Create and publish RTF templates for BI Publisher reports
Create RTF templates by using the basic, form field methods
Insert tables, forms, and charts in RTF templates
Preview results
Advanced RTF Template Techniques
Use native MS Word features to format RTF templates
Use other advanced features
Creating Parameters, List of Values (LOVs), and Hyperlinks
Create a report with parameters and a list of values
Create a report with a hyperlink to another report
Working with PDF and eText Templates
The Basics of PDF Templates
The advanced capabilities of PDF templates
The basics of eText templates
Using Oracle BI Publisher Enterprise Administration
Describe BI Publisher–supported security models
Configure the data sources, users, roles and permissions, and delivery options
Perform other administrative tasks
Defining Report Repository
Scheduling Reports and Analyzing Data
Configure BI Publisher Scheduler
Schedule BI Publisher Reports
View the saved output and history
Manage scheduled reports
Schedule reports to be burst to: a file location, and email
Analyze data in reports
Translating Reports
Describe the type of translations and options for translating reports by using BI Publisher
Create translation files by using BI Publisher Desktop
Create translation files by using the BI Publisher Enterprise Server
Creating Reports by Defining XML Data Templates
Describe the BI Publisher XML data template
Create an XML data template
Associate that data template with a rich text format (RTF) template
View the report
Integration with Oracle BI Enterprise Edition
Create a BI Publisher report from a BI Answers request
Create a BI Publisher report from the BI Server
Create a BI Publisher report from the BI Discoverer worksheet content
Add BI Publisher reports to BI Interactive Dashboards
Creating Reports Based on Other Data Sources
Creating a BI Publisher Report Based on Web Services
Creating a BI Publisher Report Based on RSS Feeds
Creating a Report Based on a File Oracle BI Suite EE 10g R3: Build Repositories Eğitim Süresi: 30 Saat Neler Öğreneceksiniz: Katılımcı Profili: Application Developers
Business Analysts
Business Intelligence Developer
Data Modelers
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Reports Developer Ön Şartlar: Required Prerequisites
Oracle BI Suite EE 10g R3: Create Reports and Dashboards
Suggested Prerequisites
Dimensional modeling
Basic SQL
Data warehouse design
Database design Hedefler: Use time series functions to support historical time comparison analyses
Build the Physical, Business Model and Mapping, and Presentation layers of a repository
Use Oracle BI Answers to run queries to test and validate a repository
Build simple and calculated measures for a fact table
Create dimension hierarchies and level-based measures
Model aggregate tables to speed query processing
Model partitions and fragments to improve application performance and usability
Use variables to streamline administrative tasks and modify metadata content dynamically
Set up security to authenticate users and assign appropriate permissions and privileges
Apply cache management techniques to maintain and enhance query performance
Set up query logging for testing and debugging
Set up a multi-user development environment
Use Administration Tool wizards and utilities to manage, maintain, and enhance repositories
Enable usage tracking to track queries and database usage, and improve query performance
Connect third-party reporting tools to Oracle BI Server
Configure Oracle BI to support multilingual environments Eğitim İçeriği: Repository Basics
Oracle BI architecture components
Repository structure, features, and functions
Using the OracleBI 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 and select 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
Testing and Validating a Repository
Checking repository consistency
Turning on logging
Defining a repository in the initialization file
Testing a repository using Oracle BI Answers
Inspecting the query log
Adding Multiple Logical Table Sources
Adding multiple logical table sources to a logical table
Specifying logical content
Adding Calculations to a Fact Table
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 Dimension Hierarchies and Level-Based Measures
Creating dimension hierarchies
Creating level-based measures
Creating share measures
Creating rank measures
Using Aggregates
Purpose of aggregate tables in dimensional modeling
Modeling aggregate tables to improve query performance
Testing aggregate navigation
Using the Aggregate Persistence Wizard
Using Partitions and Fragments
Purpose for segmenting data into partitions and fragments
Partition types
Modeling partitions in an Oracle BI repository
Using Repository Variables
Session variables
Repository variables
Initialization blocks
Using the Variable Manager
Using dynamic repository variables as filters
Modeling Time Series Data
Using time comparisons in business analysis
Using Oracle BI time series functions to model time series data
Modeling Many-to-Many Relationships
Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension
Configuring Oracle Business Intelligence data and metadata to support multilingual environments
Setting an Implicit Fact Column
Adding fact columns automatically to dimension-only queries
Ensuring the expected results for dimension-only queries
Selecting a predetermined fact table source
Specifying a default join path between dimension tables
Integrating Third-Party Reporting Tools with Oracle BI Server
Creating Repositories Using Multidimensional Data Sources
Adding a multidimensional data source an Oracle BI repository
Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI Interactive Dashboards
Security
Creating users and groups
Setting permissions for users and groups
Authenticating using a external database
Authenticating using database authentication
Setting query limits and timing restrictions
Setting filters to personalize information
Cache Management
Restricting tables as non-cacheable
Using Cache Manager
Inspecting cache reports
Purging cache entries
Modifying cache parameters and options
Seeding the cache
Setting Up and Administering Usage Tracking
Tracking and storing Oracle BI Server usage at the detailed query level
Using usage tracking statistics to optimize query performance and aggregation strategies
Analyzing usage results using Oracle BI Answers and other reporting tools
Multi-user Development
Setting up a multi-user development environment
Developing a repository using multiple developers
Tracking development project history
Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories
Employing techniques to optimize Oracle BI query performance
Applying Oracle BI repository design principles Oracle BI Suite EE 10g R3: Create Reports and Dashboards Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Application Developers
Business Analysts
Business Intelligence Developer
End Users
Functional Implementer
Technical Consultant Ön Şartlar: Required Prerequisites
Oracle BI 10g: Analytics Overview
Suggested Prerequisites
Oracle BI 10g: Analytics Overview - RWC Hedefler: Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas
Combine request criteria using set operations and execute direct database requests
Create and modify Business Intelligence requests using Oracle Business Intelligence Answers
Create and modify Interactive Dashboards
Create guided navigation links within Interactive Dashboards
Customize the Oracle BI Presentation Services user interface
Employ recommended design principles and best practices
Integrate Oracle BI Publisher reports in Interactive Dashboards
Perform administrative tasks related to the development and configuration of Interactive Dashboards
Configure, schedule and deliver personalized alerts to Interactive Dashboards using Oracle Business Intelligence Delivers
Work with Oracle BI Presentation Services content in Microsoft Office applications
Work with views to display request information Eğitim İçeriği: Working with Oracle Business Intelligence Answers
Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting
Filtering Requests in Oracle Business Intelligence Answers
Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters
Oracle Business Intelligence Answers: Advanced Features
Combining request criteria using set operations
Executing direct database requests
Editing logical SQL generated by a request
Building Views and Charts in Requests
Introduction to Answers views and charts
Creating and editing charts
Performing common view tasks
Showing Results with Gauge Views
Introduction to Gauge views
Working with Gauge views
Showing Results with Pivot Tables
Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas
Creating Oracle Business Intelligence Interactive Dashboards
Introduction to Interactive Dashboards and pages
Dashboard Editor UI elements
Composing dashboard elements
Configuring Oracle Business Intelligence Interactive Dashboards
Types of dashboard content
Embedding content in Interactive Dashboards
Using bookmark links to distribute and save Interactive Dashboards
Customizing the Oracle Business Intelligence User Interface
Modifying cascading style sheets
Modifying XML message files
Making configuration changes using the instanceconfig file
Configuring Guided Navigation Links
Building guided navigation with static links
Building guided navigation with conditional links and sections
Administering the Oracle Business Intelligence Presentation Catalog
Maintaining the Oracle BI Presentation Catalog
Managing security
Understanding security inheritance
Describing the Presentation Catalog structure
Permission types
Setting permissions using the Manage Catalog screen
Using Oracle Business Intelligence Delivers
Introduction to Oracle BI Delivers
Configuring delivery devices
Adding delivery profiles
Building alerts
Introduction to Oracle BI Scheduler
Scripted jobs
Using Oracle Business Intelligence Briefing Books
Introduction to Oracle BI Briefing Books
Creating an Oracle BI Briefing Book
Adding Content to Briefing Books
Editing a Briefing Book
Downloading and viewing a Briefing Book
Adding a list of Briefing Books to a Dashboard
Using Briefing Books with Oracle BI Delivers
Using Oracle BI for Microsoft Office
Introduction to Oracle BI for Microsoft Office
Working with Oracle BI content in Microsoft Office applications
Using Oracle Business Intelligence Publisher
Introduction to Oracle BI Publisher
Creating a BI Publisher report from an Answers request
Creating a BI Publisher report from the BI Server
Integrating Discoverer worksheet content in a BI Publisher report
Reviewing Interactive Dashboard Design Principles and Best Practices
Understanding dashboard design principles
Conceptualizing dashboards
Dashboard fundamentals Oracle Business Intelligence Applications 7.9.6 Implementation - LVC Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Analysts
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Database Designers Ön Şartlar: Hedefler: Gain an understanding of the Oracle Business Intelligence Applications (Version 7.9.6)
Gain a familiarization with the procedures needed to properly install Oracle BI Applications including the Informatica PowerCenter Gain a familiarization with advanced topics related to integration between BI Applications and the various Oracle Applications (E-Gain substantial hands-on experience using the Data Warehouse Administration Console
Participants will gain high-level working skills with Informatica PowerCenter tools by creating a custom ETL to load the Data Warehouse
Participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETL Eğitim İçeriği: Oracle BI Applications Overview
Describe the Oracle Business Intelligence Applications
Describe major application components
Describe integration with transactional applications
BI Applications Architecture
Describe the Oracle Business Intelligence Applications Architecture
Understand basic integration between Oracle EBS and BI Applications
DAC Overview
Use the tools and views of the Data Warehouse Administration Console (DAC)
Describe DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract,
Order Management Analytics Overview
Describe the functional aspects of the Order Management Analytic Application
Describe at a high-level the technical aspects of the Order Management Analytic Application
DAC Execution (Order Management) – Warehouse Load
Configure the DAC for a full load of the OBAW
Start and monitor a full load of the OBAW from the DAC
Describe the overall process for using the DAC
DAC Execution Review
Describe aspects of an OBAW load using the DAC
Warehouse Load Confirmation – OBI EE
Use Oracle BI EE to confirm the load of the OBAW
Describe the components of the OBI EE infrastructure
Oracle Business Analytics Warehouse (OBAW) Overview
Describe the contents of the Oracle Business Analytics Warehouse
Describe the warehouse tables
OBAW Customization Overview
Describe the recommended customization practices for the Oracle Business Analytics Warehouse (OBAW)
Describe specific aspects of each customization approach
Informatica Overview and Custom ETL
Use the various Informatica tools
Describe Informatica components and artifacts, how they relate to each other, and their roles in the overall ETL process
Describe the process for creating a Custom ETL process using the Informatica Tools
DAC Custom Configuration and Execution
Describe the process for creating new artifacts in the DAC to support a Custom ETL process
Execute a Custom ETL using the DAC
OBI EE Customization
Describe the process modifying the OBI EE Repository to include new content in the OBAW
Describe the process for incorporating new content into the OBI EE Dashboards
BI Applications Integration with Oracle Applications
Describe the options for integrating Oracle Business Intelligence Applications with the various Oracle Applications
BI Apps Security and Flexfield Support
Describe the options for security and access control for Oracle Business Intelligence Applications
Describe the options for handling EBS Flexfields within the OBAW and BI EE frameworks Oracle Real-Time Decisions (RTD) for Developers - LVC Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Intelligence Developer
SOA Architect
Technical Administrator
Technical Consultant Ön Şartlar: Suggested Prerequisites
Business Intelligence and Analytics
Service-Oriented Architectures
Data Warehousing Data Mining
Marketing Hedefler: Describe RTD platform and Base and Specialized applications
Describe RTD product functionality and key features and capabilities
Describe RTD architecture
Explore architecture components and RTD user interfaces
Describe the lifecycle and implementation methodology of a typical inline service project
Build and deploy a fully functional inline service project
Migrate an inline service project from development to production
Describe the RTD Decision Framework
Understand integration options between RTD and target operational applications
Understand the impact of RTD applications on traditional marketing processes
Describe RTD predictive analytics and aspects of its underlying real-time modeling and scoring
Implement Dynamic Choices Eğitim İçeriği: RTD: Introduction
Describing the business purpose and features of RTD
Distinguishing between RTD solutions
Describing the capabilities of RTD solutions
RTD Architecture
Identifying architecture components of the RTD platform and describing their roles
Exploring aspects of the installation and configuration of the RTD platform
Describing the Specialized solutions architecture
Exploring Decision Studio and Inline Services
Describing an inline service and explaining its role in RTD
Describing Decision Studio and explaining its role in configuring and deploying inline services
Identifying and describing the components of the Decision Studio user interface
Identifying and describing the key elements in an inline service
Exploring Load Generator
Describing the purpose of the Load Generator utility
Simulating the run-time operation of an inline service using Load Generator
Using Load Generator for testing
Using Load Generator performance characterization
Exploring Decision Center
Describing the purpose and capabilities of Decision Center
Navigating the Decision Center user interface
Describing Decision Center reports
Modifying and redeploying an inline service using Decision Center
RTD Predictive Analytics
Describing the concept of predictive analytics
Defining the benefits of real-time modeling and scoring over traditional data mining
Combining rule-driven and model-driven logic
Interpreting RTD real-time model reports and insights
Creating a Basic Inline Service
Building a basic inline service
Creating and configuring Application, Data Source, Entity, and Informant inline service elements
Deploying and testing an inline service
Creating a Model for Call Analysis
Adding informants to an inline service
Creating choice groups and choices
Creating a model to analyze call reasons
Populating a model using the Load Generator utility
Analyzing results in Decision Center
Using the JConsole administration tool to reset model learning
Generating Offers Based on Performance Goals
Creating performance goals and using them to score offers
Generating cross-sell offer recommendations using an advisor
Configuring the Inline Service to Learn on Offer Acceptances
Configuring the inline service to learn on offer acceptances
Tracking the success of offers by using events in the lifetime of an offer
Using a Model to Influence Offer Generation
Configuring the inline service to predict the likelihood of offer acceptance
Influencing inline service models to present offers based on learning
Adding artificial bias for a particular offer
Working with Dynamic Choices
Describing dynamic choices and comparing them with static choices
Creating dynamic choices in Decision Studio
RTD Administration
Migrating inline services from development to production
Describing the purpose and use of Java Management Extensions (JMX) Management Console
Administering RTD and inline services using JMX Management Console
Testing the deployed inline services for performance and scalability
RTD Integration
Describing how RTD integrates with target applications
Describing RTD integration support options
RTD Business Impact
Using Specialized and Base solutions to describe the impact of the real-time analytics approach on marketing and other processes Understanding the impact of RTD on non-marketing business processes Oracle Warehouse Builder 10g: Implementation Part I Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Analysts
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Database Administrators Ön Şartlar: Suggested Prerequisites
Oracle10g: Data Warehousing Fundamentals course, or prior DW experience or thorough familiarity with DW concepts
Oracle By Example: Warehouse Builder 10g R2: Getting Started
Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
eStudy: Introduction to Business Intelligence Products Hedefler: Create Data Profile
Generate Data Rules and Run Correction Mappings
Define source-to-target mappings
Designing the target warehouse
Create Process Flows
Extracting, transforming, and loading data into the staging tables and an enterprise model warehouse
Create Schedules
Use the Dependency Manager to manage metadata
Deploy objects directly into Oracle Business Intelligence Discoverer EUL Eğitim İçeriği: Setting Up and Starting Warehouse Builder
Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup
Describe Oracle Warehouse Builder program group components
Log in to the Design Center
Create a design repository and users
Open a project and navigate the user interface
Introducing OWB 10g R2 Architecture and Configuration
Discuss various design and run-time configurations
Describe the Warehouse Builder repository architecture, users, and owners
Describe the OWB repository architecture, users, and owners
Explain the benefits of warehouse staging areas
Describe the course data sources and targets
Import metadata using tcl scripts
Defining Source Metadata
Define and create source modules
Specify source data from flat files
Specify source data from relational database tables
Import source object metadata into the source modules
Ensuring Data Quality Using Data Profiling
Create a data profile
Profile the data
View profile results
Analyze profile results
Defining Staging Metadata and Mapping Tables
Create a target module
Add a staging table to a staging area warehouse module
Define mappings between source objects and staging table columns
Deriving Data Rules and Running Correction Mappings
Derive data rules
Create a correction
Run the generated correction mappings
Defining a Relational Dimensional Model
Define dimensions and cubes
Navigate the Data Object Editor
Define ETL mappings to load the dimensions and cubes
Handling Slowly Changing Dimensions
Explain how OWB handles a slowly changing dimension
Define a type 2 slowly changing dimension
Use the type 2 policy dialog box
Using Process Flows
Navigate the process flow editor
Create process flow definitions
Define a schedule
Use process flow activity templates
Use process flow activities
Deploying, Loading, and Viewing Data
Use the Control Center Manager
Load data into tables
Use the Dependency Manager to manage metadata
Business Intelligence Integration
Define Oracle Discoverer structures
Derive Oracle Discoverer structures
Define cross-tab and graph presentation templates Oracle Warehouse Builder 10g: Implementation Part II Eğitim Süresi: 18 Saat Neler Öğreneceksiniz: Katılımcı Profili: Business Analysts
Business Intelligence Developer
Data Warehouse Administrator
Data Warehouse Analyst
Database Administrators Ön Şartlar: Suggested Prerequisites
Oracle Warehouse Builder 10g: Implementation Part 1
Introduction to Business Intelligence Products-estudy
Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
Introduction to Oracle Warehouse Builder 10g Release 2 -ODE
Hands-on experience on earlier version of Warehouse builder Hedefler: Model multi-dimensional dimensions and cubes
Populate the Oracle database analytic workspace by using OWB
Build an Expert
Manage multiple named configurations
Debug your mappings using the Mapping Debugger
Use OracleBI Spreadsheet Add-In Microsoft Excel to connect to your Oracle OLAP data source
Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary Eğitim İçeriği: Understanding Oracle OLAP Concepts and Technology
Benefits of using OLAP for end users and for information technology (IT) in general
Key advantages of Oracle OLAP
Main features of a dimensional model
Role of an analytic workspace in the Oracle database
OWB OLAP Modeling and Deployment
Use additional dimension-modeling capabilities –Value-based, ragged-level, skip-level hierarchies
Design the multi-dimensional modeling
Using Spreadsheet Add-In to Query OLAP Data
Use OracleBI Spreadsheet Add-In in Microsoft Excel
Connect to your Oracle OLAP data source
Create OLAP queries
Use Excel features on OLAP data
Managing OWB Life-Cycle Changes
Use OWB Change Manager to take “snapshot” versions of metadata, compare them, and restore them if necessary
Use Metadata Dependency Manager to perform impact and lineage analysis
Using the Mapping Debugger
Initialize a mapping debugging session
Prepare the testing environment and test data
Set breakpoints and watch points
Run a test mapping
Evaluate the flow of data to detect mapping errors
Managing the Warehouse Builder Environment
Use OWB security management user interface
Manage deployment and loading in a variety of configurations
Creating Experts
Explain the benefits of Warehouse Builder Experts for novice users
Use the Expert Editor to define an Expert |
|
|