Welcome To Eazygurus

OBIEE Datawarehousing

Course Name        :   Data Warehousing – OBIEE Online Training
Duration                 :  35 hrs

STUDENTS ENROLLED

    1. Oracle Business Intelligence Enterprise Edition: Overview and Architecture
      • • Define and describe business analytics and business intelligence
      • • Identify the analytical business challenge and the solution provided by Oracle BI products
      • • Define and describe data warehousing and data modeling
      • • 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
    2. Repository Basics and Building the Physical Layer of a Repository
      • • Repository structure, features, and functions
      • • Using the OracleBI Administration Tool
      • • Creating a repository
      • • Loading a repository into Oracle BI Server memory
      • • Importing data sources
      • • Setting up connection pool properties
      • • Defining keys and joins • Creating alias and select tables
    3. 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
    4. Building the Presentation Layer of a Repository
      • • Exploring Presentation layer objects
      • • Creating Presentation layer objects
      • • Modifying Presentation layer objects
      • • Examining Presentation layer object properties
    5. 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
    6. Adding Multiple Logical Table Sources and Calculations to a Fact Table
      • • Adding multiple logical table sources to a logical 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
    7. Creating Dimension Hierarchies and Level-Based Measures
      • • Creating dimension hierarchies
      • • Creating level-based measures
      • • Creating share measures
      • • Creating rank measures
    8. Using Aggregates, Partitions, Fragments and Repository Variables
      • • Modeling aggregate tables to improve query performance
      • • Testing aggregate navigation and Using the Aggregate Persistence Wizard
      • • Purpose for segmenting data into partitions and fragments
      • • Partition types and Modeling partitions in an Oracle BI repository
      • • Session variables and Repository variables
      • • Initialization blocks
      • • Using the Variable Manager
      • • Using dynamic repository variables as filters
    9. Modeling Time Series Data
      • • Using time comparisons in business analysis
      • • Using Oracle BI time series functions to model time series data
    10. Security and Cache Management
      • • Creating users and groups
      • • Setting permissions for users and groups
      • • Authenticating using a external database and database authentication
      • • Setting query limits and timing restrictions
      • • Restricting tables as non-cacheable
      • • Using Cache Manager, Inspecting cache reports and Purging cache entries
      • • Modifying cache parameters and options
      • • Seeding the cache
    11. Multi-user Development
      • • Setting up a multi-user development environment
      • • Developing a repository using multiple developers
      • • Tracking development project history
    12. Filtering Requests in Oracle Business Intelligence Answers
      • • Introduction to filters in Answers
      • • Adding filter prompts to requests
      • • Using saved requests as filters
    13. Building Views and Charts in Requests
      • • Introduction to Answers views and charts
      • • Creating and editing charts
      • • Performing common view tasks
    14. Showing Results with Pivot Tables
      • • Introduction to pivot tables
      • • Formatting pivot tables
      • • Setting aggregation rules and building formulas
    15. Creating and Configuring Oracle Business Intelligence Interactive Dashboards
      • • Introduction to Interactive Dashboards and pages
      • • Dashboard Editor UI elements
      • • Composing dashboard elements
      • • Types of dashboard content
      • • Embedding content in Interactive Dashboards
      • • Using bookmark links to distribute and save Interactive Dashboards
    16. Customizing the Oracle Business Intelligence User Interface
      • • Modifying cascading style sheets
      • • Modifying XML message files
      • • Making configuration changes using the instance config file
    17. 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
    18. Using Oracle Business Intelligence Delivers
      • • Introduction to Oracle BI Delivers
      • • Configuring delivery devices
      • • Adding delivery profiles
      • • Building alerts
      • Introduction to Oracle BI Schedule

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.