Oracle BI Training in OMR Chennai
OBIEE 11g (11.1.1.6.0)
This course is designed for those professionals who are looking for Great career as Consultant in BI Technology. This course provides a solid foundation on OBIEE 11g. Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 11g/Fusion Middleware Security and OBIEE-BI Publisher integration.
Course Content
| PART I: Overview |
| 1. General Datawarehousing concepts
2. Dimensional modeling basics 3. Dimension Types ( Conformed and SCD) 4. Fact Types( Additive , Non additive, Snapshot, Accumulator etc) |
| PART II: Installation |
| 1. Installation Prerequisites
2. Points of Caution while installing 3. Understanding the need for RCU 4. Installation best practices 5. Difference between Simple and Enterprise Install |
| PART III: Admin Tool And RPD Modeling |
| 1. Understanding Online and Offline modes of RPD
2. Creating Repository Using Administration Tool 3. Repository Basics 4. Building Physical Layer of Repository 5. Building Physical Model and BMM Layer of a Repository 6. Building the Presentation Layer of a Repository 7. Aggregate Persistence 8. Dimension Lookups 9. Hierarchical Tables and Parenct Child Hierarchy 10. Modeling a Ragged Hierarchy Dimension 11. Creating Time Series Measures 12. Testing , Validation of a Repository 13. Creating Calculated Measures 14. Creating Dimension Hierarchies 15. Organizing Presentation Layer 16. Working with Initialization Blocks and Variables ( Session and Repository Variables) 17. Adding Multiple Sources 18. Executing Direct Database Requests 19. Working with Aggregates |
| PART IV: Dashboard And Analysis |
| 1. Creating and Editing Analysis
2. Creating Interactive Dashboards using Analysis 3. Creating query and chart 4. Working with Filters 5. Working with Pivot Table 6. Building Views and Charts in Requests 7. Creating and Configuring Interactive Dashboards 8. Creating and Configuring Dashboard Prompts 9. Configuring Action Links 10. Creating and understanding KPI,KPI Watchlists and Scorecards 11. Oracle BI for MS-Office 12. Sending Alerts Using Delivers 13. Using Job Manager |
| PART V: Architecture And Security Features |
| 1. Understanding OBIEE 11g Architecture
2. Role of Weblogic Server and Enterprise Manager 3. Admin and managed Server 4. Authentication & Authorization 5. Creating Application Roles 6. Creating Users , Groups, Web Catalog groups 7. LDAP Integration 8. Object & Data Level Security Implementation 9. Web catalog Level Security Implementation |
Oracle Data Integrator Training in Chennai. Get Trained by real professionals having 9+ years industry experience in India & USA
Greens technology training in step with the global pace! When you train with us, you can be assured that this is your passport to the global IT world. Our training programs are designed to help you develop practical and technical skills that will make you a full-fledged IT professional.
Our main focus is to provide individual training and corporate training in Data Warehouse and Business Intelligence tools like OBIEE, ODI, Informatica, SQL Server BI, MicroStrategy, Cognos, Datastage, Teradata and Ab Initio.
| Oracle Data Integrator 11g: Integration and Administration |
| Audience |
| – Business Analysts |
| – Data Modelers |
| – Data Warehouse Administrator |
| – Database Administrators |
| – SOA Architect |
| – Technical Consultant |
| Objectives |
| – Describe ODI Model concepts |
| – Describe architecture of Oracle Data Integrator 11g |
| – Apply ODI Topology concepts for data integration |
| – Design ODI Interfaces, Procedures, Packages, and Load Plans to perform ELT data transformations |
| – Explore, audit data, and enforce data quality with ODI |
| – Administer ODI resources and setup security with ODI |
| – Implement Changed Data Capture with ODI |
| – Use ODI Web services and perform integration of ODI with SOA |
| Topics Covered |
| Introduction – Identifying the Course Units – What is Oracle Data Integrator? – Why Oracle Data Integrator? – Overview of ODI 11g Architecture – Overview of ODI 11g Components – About Graphical Modules – Types of ODI Agents – Overview of Oracle Data Integrator Repositories |
| Administering ODI Repositories and Agents – Administrating the ODI Repositories – Creating Repository Storage Spaces – Creating and Connecting to the Master Repository – Creating and Connecting to the Work Repository – Managing ODI Agents – Creating a Physical Agent – Launching a Listener, Scheduler and Web Agent – Example of Load Balancing |
| ODI Topology Concepts – Overview of ODI Topology – About Data Servers and Physical Schemas – Defining the Physical Architecture – Defining the Logical Architecture – Mapping Logical and Physical Resources – Defining Agents – Defining a Topology – Planning the Topology |
| Describing the Physical and Logical Architecture – Overview of Topology Navigator – Creating Physical Architecture – Creating a Data Server – Testing a Data Server Connection – Creating a Physical Schema – Creating Logical Architecture – Overview of Logical Architecture and Context Views – Linking the Logical and Physical Architecture |
| Setting Up a New ODI Project – Overview of ODI Projects – Creating a New Project – Using Folders – Organizing Projects and Folders – Understanding Knowledge Modules – Exchanging ODI Objects and Sharing Global Objects – Exporting and Importing Objects – Using Markers |
| Oracle Data Integrator Model Concepts – What is a Model? – Understanding Metadata in ODI – Understanding Reverse Engineering – Creating Models – Organizing Models – Creating Data stores – Using Constraints in ODI – Creating Keys and References |
| Organizing ODI Models and Creating Data stores – What is an Interface? – Business Rules for Interfaces – What is a Mapping? – What is a Join? – What is a Filter? – What is a Constraint? – What is a Staging Area? – Creating a Basic Interface |
| ODI Interface Concepts – What is an Interface? – Business Rules for Interfaces – What is a Mapping, Filter, Join? – Overview of Integration Process – What is a Staging Area? – About Execution Location – Using Knowledge Modules (KM) with ODI Interface – Creating a Basic Interface |
| Designing Interfaces – Designing an Interface – Multiple Source Data stores – Creating Joins – Filtering data – Disabling Transformations – Overview of the Flow – Specifying the Staging Area – Selecting Knowledge Modules |
| Interfaces: Monitoring and Debugging – Monitoring Interfaces – Using Operator – Viewing Sessions and Tasks – How to Monitor Execution of an Interface – How to Troubleshoot a Session – Keys to Reviewing the Generated Code – Working with Errors – Tips for Preventing Errors |
| Designing Interfaces: Advanced Topics – Using Business Rules in Interfaces – Overview of Business Rule Elements – Using and Tracking Variables – Using User Functions – Using Substitution Methods – Modifying a KM – Showing Variable Values in Log – Using RKM for Customized Reverse Engineering |
| Using ODI procedures – What is a Procedure? – Examples of Procedures – Creating Procedures – Adding Commands – Adding Options – Running a Procedure – Using Operator to View Results |
| Using ODI Packages – What is a package? – Creating a package – Executing a package – Creating Advanced Packages – Error handling – Controlling an Execution Path – Creating a Loop – Using the Advanced tab |
| Managing ODI Scenarios and Versions – What is a Scenario? – Managing Scenarios with Load Plans – Preparing Scenarios for Deployment – Automating Scenario Management – Scheduling the ODI Scenario – Overview of ODI version management – Using Version Browser and Version Comparison Tool – Handling concurrent changes |
| Enforcing Data Quality and Auditing Data with ODI – Why Data Quality? – When to Enforce Data Quality? – Data Quality in Source Applications – Data Quality Control in the Integration Process – Data Quality in the Target Applications – Enforcing Data Quality – Exploring Your Data – Auditing Data Quality |
| Working with Changed Data Capture – Overview of ODI version management – Techniques of Changed Data Capture – Changed Data Capture in ODI – CDC Strategies and Infrastructure – CDC Consistency – Using CDC – Viewing Data/Changed data – Using Journalizing |
| Administering ODI Resources: Advanced Topics – Using Open Tools – Installing Open Tools – Using Open Tools in a Package – Using Open Tools in a Procedure or in a KM – Developing Your Own Open Tools – Setting Up ODI Security – Defining Security Policies – Defining Password Policies |
| Using Web Services and Integration of Oracle Data Integrator with SOA – Web Services in Action – Using Data Services – Setting Up Data Services – Testing Data Services – Installing Public Web Services – Using Public Web Services – Invoking Web Services – Integrating ODI with SOA |
| Extending ODI with the SDK – Using SDK Public Interfaces – Integrating through ODI SDK – Examining SDK examples |
| Next Courses |
| – Oracle Database: Introduction to SQL |
| – Oracle Enterprise Data Quality: Match and Parse |
| – Oracle Enterprise Data Quality: Profile, Audit and Operate |
| – Oracle Data Integrator 11g: Advanced Integration and Development NEW |
