Introduction To Data warehousing
• Database Design And Data Modeling
• Tools Consideration:
• Erwin (Data Modeling Tool)
• Informatica 8.6
• Informatica Installation
• Informatica Powercenterwebadministrator Console
• Informatica Repository Manager
• Informatica Designer
• Types Of Transformations:
• Workflow Manager
• Types Of Tasks
COGNOS 8.1/8.3
• Introduction
• Cognos Connections
• Framework Manager
• Query Studio
• Report Studio
• Analysis Studio
DATA STAGE
• Introduction about Data Stage
• Data stage Administrator
• Data stage Director
• Designer
• Processing stage Hayagriva Technologies Course Content
• Debugging Stage
• Manager
• Containers
• Job Sequencer
• Information Analyzer
• Web sphere Quality Stage
• IBM Information Server Administration Guide
MSBI (SSIS, SSAS, SSRS)
SSIS Objectives
• Contents: Planning for ETL
• Planning an SSIS Solution
• Designing Data Flow
• Optimizing an SSIS Solution
• Deploying and Operating an SSIS Solution
SSAS Objectives:
• Contents: Introduction to Microsoft SQL Server 2005
Analysis Services
• Creating Multidimensional Analysis Solution
• Working with Dimensions
• Working with Measures and Measure Groups
• Querying Multidimensional Analysis Solutions
• Customizing Cube Functionality
• Deploying and Securing an Analysis Services Database
• Maintaining a Multidimensional Solution
• Introduction to Data MiningHayagriva Technologies Course Content
SSRS Objectives
• Introduction to Microsoft SQL Server Reporting Services
• Authoring Basic Reports
• Enhancing Basic Reports
• Manipulating Data Sets
• Publishing and Executing Reports
• Using Subscriptions to Distribute Reports
ABINITIO
• Overview (ETL and Abinitio)
BO XI
• Data warehousing/Dimensional modeling Practical
Concepts
• Database Concepts needed for Data warehousing
• BOXIR2&3 Architecture
• Universe Design
• Web intelligence
• Crystal Reports
• Dashboard Builder
• Xcelsius-Scorecard Builder
• Administration
• Widgets
• Desktop Intelligence
• Webi-rich Client
• Universe Builder & Query Builder
• Query as Web serviceHayagriva Technologies Course Content
• Voyager
• Security Implementation
• OLAP Universe
• Import Wizard\Publishing Wizard
• Business View Manager
• Performance Management
• Live Office Reporting
• BO-SAP Integration/Edge Series
• SAP Webi/Dashboard Reporting:
• Introduction to BO-SDK
• Introduction to BO Extension points:
• Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
• Performance Tuning of Database w.r.t BO
• Performance Tuning of BO
• Testing & Migration of BO components from
Dev/Stage/Production environment
• Polestar/Business Explorer
• BO XI R3 Certification Guidelines:
DATA MART
• Setting The Stage
• The Data Mart Scope Phase
• The Data Mart Design Phase.
• The Data Mart Construction Phase. Hayagriva Technologies Course Content
Hyperion-Essbase, FM, Plan
• Hyperion Essbase 9.3.1&11.1
• Hyperion Financial Management 9.3.1/11.1(H.F.M)
• Hyperion Planning 9.3.1&11.1
• Content
• Tera Data
• TERADATA 12
• Teradata Warehouse and Competitiveness
• Teradata Architecture and Components
• Various Architectures
• Data Recovery and Protection
• Teradata Storage and Retrieval Architectures
• Teradata Indexes
• Teradata Sql Reference
• Teradata Functions and Operators
• Teradata Transactions
• Performance Tuning and Explain Utility
• Joins and Unions
• Join Strategies
• Teradata Basic Commands
• Teradata Objects
• Teradata spaces
• Teradata Transaction Modes
• Load and Unload Utilities & Tools
• Explanation with proper debugging
• Real time Issues and resolving it
• Real time Issues and solving itHayagriva Technologies Course Content
• Teradata Parallel Data Pump
• Teradata Fast Export
• Introduction to
• Concentrating on Performance Tuning