OBIEE Administrator
Introduction
Oracle Business Intelligence Enterprise Edition(Oracle BI EE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine. Oracle Business Intelligence is designed to bring greater business visibility and insight to a wide variety of users.
OBJECTIVE of the Training:
Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:
- Collect up-to-date data from your organization
- Present the data in easy-to-understand formats (such as tables and graphs)
- Deliver data in a timely fashion to the employees in your organization
- These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.
OBIEE Administrator Course Content:
1.OBI Architecture
- Clients
- OBI Presentation Services
- OBI Server
- OBI Repository (.rpd)
- Data Sources
2.OBI Components
- OBI Administration Tool
- OBI Answers
- Intelligence dashboards
3.Repository Basics
- Oracle Business Analysis Warehouse
- DAC and Informatica Server
- Informatica Server ETL
- Sample Request Processing
- Using the OracleBI Administration Tool
- Repository Directory
- Repository Files ( Initialization files and log files)
- Informatica Server ETLLoading a repository into Oracle BI Server memory
- Creating a repository
- Connection Pool
- Repository Modes ( ONLINE and OFFLINE )
- Physical Layer
- Business Model & Mapping Layer
- Presentation Layer
- Presentation Catalogs, Folders and Columns
- Error Messages
4.Building The Physical Layer Of a Repository
- Defining an ODBC System DSN
- Setting up connection pool properties
- Importing data sources ( Physical Schema )
- Verifying the import
- Defining physical keys and joins
- Creating alias and select tables
5.Building The Business Model And Mapping Layer Of a Repository
- Creating the logical business model
- Creating the logical tables, columns, and sources
- Defining logical joins
- Adding Calculation to a Fact Table
- Building measures
6.Building The Presentation Layer Of a Repository
- Creating a new Presentation Catalog
- Modifying Presentation layer objects
- Rename tables
- Reorder Table
7.Testing And Validating a Repository
- Checking repository consistency
- Defining a repository in the initialization file
- Testing a repository using Oracle BI Answers
- Message Severity
- Viewing Server Logs
8.Adding Multiple Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content
9.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
10.Creating Dimension Hierarchies And Level-Based Measures
- Creating dimension hierarchies
- Creating level-based measures
11.Creating And Using Agrregates
- Purpose of aggregate tables in dimensional modeling
- Modeling aggregate tables to improve query performance
- Testing aggregate navigation
- Using Initialization Blocks Repository Variables
12.Creating Dynamic Repository Variables
13.Execute Direct Database Requests
- Accessing database directly
14.Creating Time Series And Measures
- Using time comparisons in business analysis
- Using Oracle BI time series functions to model time series data
15Creating Dimension Hierarchies And Level-Based Measures
- Creating dimension hierarchies
- Creating level-based measures
16.Providing Security for Groups & Users:
17.Answers(Reports)
18.Working With ORACLE Business Intelligence Answers
- Introduction to Oracle BI Answers
- Working with requests in Oracle BI Answers
- Using advanced formatting
- Creating report Level Hierarchy
19.Filtering Requests in ORACLE Business Intelligence Answers
- Introduction to filters in Answers
- Adding filter prompts to requests
- Using saved requests as filters
20.Building Views And Charts in Requests
- Introduction to Answers views and charts
- Creating and editing charts
- Performing common view tasks
- Creating a Narrative View
- Creating a column Selector
21.Showing Results with Pivot Tables
- Introduction to pivot tables
- Formatting pivot tables
- Setting aggregation rules and building formulas
Course Reviews
No Reviews found for this course.
Write a Review