Obiee Training in Mangalore

Introduction to DWH concepts

• OLTP Vs OLAP
• Data warehouse Architecture
• Data warehouse Vs Data Mart
• ETL
• Masures, Fact, Dimensions
• Schema
• Star Schema and
• Snowflake Schema
• Dimension Hierarchy
• Aggregates
• Aggregation Strategy, Compression Ratio
• Indexing Strategy
• Slowly Changing Dimension
• Type 1
• Type 2
• Type 3
• Performance Tuning

Oracle Business Intelligence – Repository

• 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 Dimension Hierarchies and Level-Based Measures
• Creating dimension hierarchies
• Creating level-based measures
• Using Aggregates
• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
• Using Partitions and Fragments
• Purpose for segmenting data into partitions and fragments
• Modeling Time Series Data
• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data
• 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

Oracle Business Intelligence – Repository Part 2

• 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
• 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
• Dynamic Filter in Dashboard
• Using Prompts
• Scope of the Prompt
• Presentation Variable and Uses
• Request Variable
• Combine Request
• Direct Database Request
• Customizing the Oracle Business Intelligence User Interface
• 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
• Using BI Deliver
• Configuration of Scheduler Service
• Creating & scheduling iBots
• Using Repository Variables
• Session variables
• Repository variables
• Initialization blocks
• Using the Variable Manager
• Using dynamic repository variables as filters
• 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