Jump to content

OBIEE ONLINE TRAINING @ VERY LOW COST


Raj2011

Recommended Posts

Dear Students

I am offering OBIEE Online Training at ver low cost. Interested students can email me at : [email protected] for further details.

Here is the course curriculum :
 OBIEE Administrator Architecture:
 Creation of the ODBC Data Source Name (System DSN) for
            Different Databases at Operating System Administrator
 ODBC connectivity between Database and Oracle BI
            Administrator
 Development of RPD (Repository Directory) file at OBI
            Administrator

 Repository creation

 Physical layer:  development of physical diagram (ROLAP) using physical objects.
 Import tables from different databases
 Connection pool verification
 Working with type conversion and referential integrity in physical layer.
 Working with new foreign key and complex join in Physical diagram.
 Business model and mapping layer (MOLAP):  development of
      logical  diagram  using logical fact tables and logical dimensional 
      tables.
• For standard requirements (detailed),
• Multi dimensional requirements (summarized) using arithmetic operators, aggregate functions
• Case statement generation (IF statement, IF-ELSE statement, SWITCH statement
• Working with various join types( Inner, Left outer, Right outer and Full outer)
• Creation of global filters
 Develop the dimensions for drill down analysis (multi dimensional
 analysis)
 Development Meta Data in Business Model for Business Requirements
 Converting the technical columns information into end user
                  Vocabulary.
 Overview of various facts (measures) in BMM layer.
 Presentation layer: Divide or Recombine the Meta data created in
            the Business Model for easy analysis
 Working with Repository and Session Variables.
 Working with OBI ODBC client.
 Overview on OBI server architecture.
 RPD file configuration at OBI Server Level
 Utilities
 Security creation of repository
 Row updations
 Internal Process at Server level (conversion of Business query in to SQL query)
 User alteration at Database level

Project Development:

 OLAP Specifications
 Development of Business Requirement  Specifications (BRS)
 Development of Reporting Requirement Specifications(RRS)

Oracle Answers and Interactive Dashboards:

 Selection of the Subject Area
 Creation of the Excel Sheet for Reporting Requirement Specifications using Business Requirement Specifications
 Develop the Request in the Criteria
 Generate the Reports using Results
 Develop the logical calculations using advanced tab (set sql format)

 Reports:

 Ad-hoc reports
 Standard reports
 Dashboard reports.

Generate customized reports and override reports in different formats.
a. Query Optimization
b. Report Optimization
 2-dimensional
 Multi dimensional
 List reports
 Chart reports
 Line chart reports
 Bar chart reports
 Pie-chart reports
 Cross-Tab reports
 Working with various variables
 Repository
 Session
 Presentation
 Prompts (advance filters)
 Cascading prompts
 Dash board reports
 Page prompts
 Testing the prompts with single Go button
 Combined the requests from the different subject areas using set operators like
Union, Intersect etc.
 case statement generation (IF statement, IF-ELSE statement, SWITCH statement
 Filters (Global and Local filters)
 Generation of Expression and Aggregated functions
 Download the reports in PPT and Excel sheet, etc formats
 Working with direct database connection
 Working with prompts in direct database request.

 Interactive dashboards

 Creation of the folder for different requests
 Scheduling the reports
 Generation of the iBots
 Dashboard Management
 Tabs creation for multiple Dashboards
 Creation of the pages for different Dashboards
 Installation of Oracle 10g and Configuration Schemas  at DBA level
 Installation of OBI Administrator.


 Working with BI Publisher.

 Create a JDBC connection to access repository file and database.
 Create report request
 Create data model
 Working with query builder
 Create row set
 Create templates
 Working with Analyzer
 Working with Analyzer for Excel
 Working with Studio to generate list reports, chart and cross-tab reports.

Thanks
Rajendra
Ph : +91-9660567626(M)
Email : [email protected]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...