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.
