Session : 1 – 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

Session : 2 – 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

Session : 3 – 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

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya