OBIEE 11g Online Training

Monstercourses is the leading and pioneer in job oriented IT online training, offering best online training on all IT technologies by industry real time employees on hands on online training

Inspired faculty

Hands on trainers

Material will be provided

Software will be installed

Resume guidance will be given

One free demo will be given before sign up for the course

Affordable price

Quality online training

Placement assistance will be provided

Experienced trainers

Software will be provided

Online training will be held through goto meeting and WebEx

Live interactive online training classes

Pl visit:  www.monstercourses.com/obiee

+1 772 777 1557 & +44 702 409 4077, visit: www.monstercourses.com
 

Monstercourses is having fully qualified and industry experts who can teach quality online training to the students,

Our online training classes include data warehousing, sap, oracle, Microsoft technologies, JAVA. J2ee, core java, testing tools, android etc.

OBIEE online training @ monstercourses

                                                     OBIEE Online training

Duration : 30 Hours

Course Outline: RPD Development
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 new calculation measures using the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
•    Creating dimension hierarchies
•    Creating level-based measures
•    Creating share measures
•    Creating rank measures
Using Aggregates
•    Purpose of aggregate tables in dimensional modeling
•    Modeling aggregate tables to improve query performance
•    Testing aggregate navigation
•    Using the Aggregate Persistence Wizard
Using Partitions and Fragments
•    Purpose for segmenting data into partitions and fragments
•    Partition types
•    Modeling partitions in an Oracle BI repository
Using Repository Variables
•    Session variables
•    Repository variables
•    Initialization blocks
•    Using the Variable Manager
•    Using dynamic repository variables as filters
Modeling Time Series Data
•    Using time comparisons in business analysis
•    Using Oracle BI time series functions to model time series data
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
Setting Up and Administering Usage Tracking
•    Tracking and storing Oracle BI Server usage at the detailed query level
•    Using usage tracking statistics to optimize query performance and aggregation strategies
•    Analyzing usage results using Oracle BI Answers and other reporting tools
Multi-user Development
•    Setting up a multi-user development environment
•    Developing a repository using multiple developers
•    Tracking development project history
Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories
•    Employing techniques to optimize Oracle BI query performance
•    Applying Oracle BI repository design principles
Course Topics: ANSWERS & DASHBOARDS
Working with Oracle Business Intelligence Answers
•    Introduction to OracleBI Answers
•    Working with requests in OracleBI Answers
Filtering Requests in Oracle Business Intelligence Answers
•    Introduction to filters in Answers
•    Adding filter prompts to requests
•    Using saved requests as filters
Views and Charts in Requests
•    Introduction to Answers views and charts
•    Creating a column selector view
Showing Results with Pivot tables
•    Introduction to pivot tables
•    Formatting pivot tables
•    Setting aggregation rules and building formulas
Creating Interactive Dashboards
•    Introduction to Dashboards and pages
•    Dashboard Editor UI elements
•    Composing Dashboard elements
Configuring Interactive Dashboards
•    Types of Dashboard content
•    Embedding content in Dashboards
Customizing the Oracle Business Intelligence User Interface
•    Modifying cascading style sheets
•    Modifying XML message files
Configuring Guided Navigation Links
•    Building guided navigation with static links
•    Building guided navigation with conditional links and sections
Administering Oracle Business Intelligence Presentation Catalog
•    Maintaining the OracleBI Presentation Catalog
•    Maintaining security
•    Understanding security inheritance
Using Oracle Business Intelligence Delivers
•    Building alerts
•    Building iBots
•    Introduction to OracleBI Scheduler
Other Feature we provide:

• FAQS
• Concentration on performance tuning
• Real time scenarios
• Certification guidance
• Resume preparation
• Sample resumes
• Interview & certification FAQS
• How to face the interview
• Class notes which is useful for who is trying for job
• Project preparation

Pl visit : www.monstercourses.com for more IT online training courses 

Online IBM DATASTAGE training @ monstercourses

 Monstercourses.com is a leading and pioneers in IT online training, offering best online training on various IT technologies by industry qualified real time experts.  Highlights:  Hands on trainers Material software installation Resume guidance One free demo Affordable prices Quality online training Placement assistance  MonsterCourses reviews teaching methodology is different and unique as the training programs designed helps the Learners to master in broad range of skills that is essential to become a creative IT professional.  We have dedicated trainers who continuously work to improve quality of Online Training programs.  Learners who complete Graduation, Post Graduation and working employees were not adequately trained to meet today’s World of competition. So there was a great need for highly professional online training institute and in order to fill this gap MonsterCourses.com was started.  Our IT courses includes informatica online training, cognos online training, obiee online training, microstrategy online training ,datastage online training, teradata online training, BOXI online training, SAP FICO online training,  abap online training, BOXI online training, oracle dba, sql/pl , dot net , QA online training and many more. Join monstercourses.com for better career Opportunities 

STEP-1 DATA WAREHOUSE FUNDAMENTALS An Introduction of Data warehousing purpose of Data warehouse Data ware Architecture OLTP Vs Data warehouse Applications Data Marts Data warehouse Lifecycle SDLC

STEP-2 DATA MODELING Introduction of Data Modeling Entity Relationship Model Dimensions and Fast Tables Logical Modeling Physical Modeling Schemas Like Star Schema & Snowflake Schemas Fact less Fact Tables

STEP-3 PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD) Introduction of Extraction , Transformation and Loding Types of ETL tools Key tools in the market

STEP-4 INSTALLATION PROCESS Windows server Oracle .NET Datastage 7.5X2 & 8x

STEP-5 DIFFERENCE Server jobs & Parallel jobs

STEP-6 COMPONENTS IN DATASTAGE Administrator clint Designer client Director client Import/export manager Multi client manager Console for IBM imformation server Web console for IBM imformation server

STEP-7 INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X Datastage Introduction IBM Information server Architecture IBM Data Quality Architecture EnterpriseInformation Integration Web Sphere DataStage Components

STEP-8 DATASTAGE DESIGNER About Web Sphere DataStage Designer Partitioning Methods Partitioning Techniques Designer Canvas Central Storage Job Designing Creating the Jobs Compiling and Run the Jobs Exporting and importing the jobs Parameter passing System(SMP) & Cluster system(MPP) Importing Method(Flat file, Txt, Xls and Database files) OSHImporting Method Configuration file

STEP-9 PARALLEL PALETTE DATABASES STAGES Oracle Database Dynamic RDBMS ODBC SQL Server Teradata FILE STAGES Sequential File Dataset Lookup File set DEV/DEBUG STAGES Peek Head Tail Row Generator Column Generator PROCESSING STAGES Slowly changing dimension stage Slowly changing dimensions implementation Aggregator Copy Compress Expand Filter Modify Sort Switch Lookup Join Marge Change Capture Change Apply Compare Difference Funnel Remove Duplicate Surrogate Key Generator Pivot stage Transformer

CONTANERS Shared Containers Local Containers

STEP-10 DS-DIRECTOR About DS Director Validation Scheduling Status View logs Monitoring Suppress and Demote the Warnings Peek view

STEP-11 DATASTAGE ADMINISTRATOR Create Project Delete Project Protect Project Environmental variables Auto purge RCP OSH Commands Execute Multiple Instances Job Sequence Settings

STEP-12 JOB SEQUENCE AREA Job Activity Job sequencer Start loop Activity End loop Activity Notification Activity Terminator Activity Nested Condition Activity Exception handling Activity Execute Command Activity Wait for file Activity User variable Activity Adding Check Points Restartable

STEP-13 IBM WEB SPHERE QUALITY STAGE Data Quality Data Quality Stages Investigate Stage Standardize Stage Match Frequency Stage Reference Match Stage Unduplicated Match Stage Survive Stage Viewing audit details in operational DASHBOARD reports

KEY SERVICE FAQS Covering DBA concepts Concentration on performance tuning Real time scenarios Certification guidance Resume preparation Sample resumes Interview & certification FAQS How to face the interview Class notes which is useful for who is trying for job Project preparation

Contact monstercourses.com for more IT online job oriented training courses visit www.monstercourses.com +17727771557