USA : +1 732 325 1626
IND : +91 800 811 4040
Mail ID : info@bigclasses.com

Pages

Online Training

Saturday, September 19, 2009

DW Hyperion Essbase 9.3.1&11.1 Contents

Hyperion Essbase 9.3.1&11.1

* Introduction to Online Analytical Processing
* Multidimensional view of information
* Introduction to the Hyperion Essbase Product Family
* Essbase Product family architecture
* Setting Up Essbase Analytic Environment
* Essbase Analytic Server Architecture
* Essbase Administration Server Architecture
* Managing an Essbase Administration Server
* Using the Essbase Administration Console
* Creating an Essbase Analytic application and database
* Creating and editing the database outline
* Verifying and saving the database outline
* Building dimensions dynamically
* Loading Data into the Essbase Analytic Database
* Supported data sources
* Performing free-form data load
* Creating and editing a simple rules file
* Performing data load using the rules file
* Previewing the loaded data
* Calculating the Essbase Analytic Database
* Essbase Analytic Services scripting capabilities
* Calculating with calc scripts
* Executing the cal script
* Retrieving Analytic Data
* Essbase Spreadsheet Add-in overview
* Navigating through the spreadsheet report
* Modifying the spreadsheet report layout by selecting and pivoting retrieved data
* Updating retrieved data in the Essbase Analytic database
* Introducing Essbase Analytic Services storage options
* Block storage option concepts
* Aggregate storage option concepts
* Automating analytic reports with Report Writer
* Interacting with Essbase Analytic Services using MaxL
* Understanding aggregations
* Batch scripting and Automation
* Extending Essbase Analytic Capabilities with Hyperion Analyzer
* Hyperion Analyzer key features, system architecture, and components
* Hyperion Analyzer Java client
* Creating spreadsheet reports, composite reports, and custom reports
* Overview of Hyperion System 9 Architecture

Hyperion Financial Management 9.3.1/11.1(H.F.M)

* Introduction
* Architecture
* Hyperion Financial Management Dimensions
* Managing Applications
* Application Administration
* Creating Application Profiles
* Defining Calendars
* Creating Applications
* Windows Procedure
* Web Procedure
* Copying Hyperion Financial Management Applications
* Monitoring Running Tasks
* Managing Application Security
* Creating Security Classes
* Creating Application Security Files
* Hyperion Financial Management User Roles
* Loading Application Security
* Managing Metadata
* Defining Accounts
* Defining Entity Members
* Defining Scenario Members
* Defining Application Settings
* Defining Consolidation Methods
* Setting Up Intercompany Partners
* Creating a Data Grid
* Adding Line Item Detail
* Creating Member List Files
* Journal Entries in Accounting
* Examples of Journal Entries
* Calculating Accounting Balances
* Balance Sheet and Income Statement
* Adjusting Journal Entries
* Managing Journals
* Postings from multiple Journals are cumulative
* Journal Review Process
* Managing Data Forms
* Defining Reports
* Creating a Journal Report
* Managing Rules
* Calculation Commands
* Hyperion Financial Management Objects
* Rule Functions
* Managing Intercompany Transactions
* Elimination Process
* Plug accounts
* Managing Intercompany Transaction Periods
* Business process for the Intercompany Transaction Module
* Posting Intercompany Transactions
* Monitoring Intercompany Transactions
* Consolidating Data
* Hyperion Financial Management Business Process Overview
* Consolidation Process
* About Consolidation Percentages
* Entering Consolidation Information Using Ownership Management
* Running Consolidations
* Translating Data in Data Grids
* Entering Exchange Rates
* Automating Tasks
* Components of a Task flow
* Creating a Task flow
* Stage Definition – General Tab
* Stage Definition - Processing Tab
* Stage Definition-Starting Event
* Budgeting and Forecasting
* Financial Reporting
* Architecture
* Financial Reporting Components
* Steps to Share the report
* Steps to create batch and Schedule the reports
* Smart View
* Steps to establish a data source connection

Hyperion Planning 9.3.1&11.1

* Hyperion Analytical Administration Services 9.3
* Hyperion Analytical Services 9.3
* Hyperion Planning 4.0.5
* Hyperion Shared Services 9.3
* Hyperion Business rules 9.3
* Vignette Business Integration Studio 7.2
* Hyperion reports 7.2

Content

* Planning Features
* Planning Architecture
* Planning Installation Sequence
* Connection between Planning and Essbase
* Hyperion Planning required dimensions
* Hyperion Planning user-defined dimensions
* Create and Manage Applications
* Creating an Application
* Creating Calendar
* Setting up currencies
* Setting up Plantypes
* Account types
* Data Type and Exchange Rate Type
* Storage Options
* Account members and Plan Types
* Creating Application with Setup Application Task
* Creating Additional Applications
* Creating databases
* Refresh databases
* Setting Up Security
* Creating Security Filters
* Assigning Access rights
* Importing Access rights
* Reporting on Access Assignments
* Refresh Security
* Hyperion Planning Desktop
* Hyperion Planning web
* Planning Thick Client vs Thin Client
* Setting up Audit Trails
* Usage of Audit Trails
* Setting Up Alias Tables
* Creating Alias Tables
* Refresh Alias Tables
* Loading Members and Data
* Using Hyperion Application Link
* Using Vignette Business Integration Studio
* Using Flow Diagrams
* Hyperion Planning Adapter
* Creating an Adapter Process
* Flat File Adapter
* Importing Data
* Managing Shared Services Models
* Registering Applications
* Assigning an Application to a Shared Services Project
* Managing Models
* Sharing Data
* Creating Shared services Applications
* Working with Models
* Comparing Models
* Managing Permissions to Models
* Sync Operations
* Data Forms
* Creating Data Forms
* Setting the Row and Column Layout
* Adding Row Definitions
* Selecting Attribute Values as Members
* Selecting Substitution Variables as Members
* Selecting User Variables as Members
* Creating Asymmetric Rows and Columns
* Enabling Users to Dynamically Add Rows
* Defining the Page and POV
* Setting a Data Form’s Display Options
* Business Rules
* Business Rules Roles
* Business Rules from AAS
* Business Rules from Hyperion Planning web
* Business Rules from Hyperion Business rules web portal
* Creating a Business Rule
* Creating Global Variables
* Inserting Functions with the Function Editor
* Creating Local Variables
* Launching a Business Rule
* Selecting Business Rules form Hyperion Planning web:
* Runtime Prompts
* Previewing a Data Form
* Managing User Variables
* Different Ways of Launching Hyperion Business Rules
* Managing the Budgeting Process
* Planning Units
* Setting Up E-mail for Workflow Notification
* Printing Planning Unit Annotations
* Overview of Managing Task Lists
* Creating Task Lists
* Copying Data

DW Microstrategy 8 Contents

Microstrategy 8

Agenda

* Microstrategy Desktop
* Microstrategy Architect
* Microstrategy report services
* Advanced Microstrategy desktop
* Microstrategy intelligence server
* Microstrategy Narrowcast server
* Microstrategy Administration
* Introduction to Microstrategy web server

Microstrategy Desktop

* Introduction to Microstrategy Business Intelligence
* Introduction to Microstrategy Desktop and Architecture
* Configuration objects
* Public objects
* Schema objects
* Creating and saving Reports in Desktop
* Report Manipulations in Desktop

* Data Manipulations
* Style Manipulations

* Creating and saving basic report filters
* Creating, formatting and saving basic metrics
* Microstrategy OLAP services in Desktop

* Report objects
* View Filters
* Derived Metrics

* Creating and saving Basic prompts and searches

Microstrategy Architect

* Introduction to Microstrategy Architect
* The logical data model
* The physical warehouse schema
* Advanced Data modeling and schema design

* Many to Many relationships
* Role attributes

* Introduction to project creation in Microstrategy Architect
* Creating Microstrategy facts
* Creating Microstrategy Attributes
* Creating Microstrategy Hierarchies
* Project configuration workshop
* Project optimization and maintenance
* Maintaining your project over time
* Aggregate tables
* Partitioning and partition mappings
* Transformations

Microstrategy report services

* Introduction to Enterprise reporting
* Document basics
* Document design concepts
* Useful design techniques

* Derived summary and stacked metrics
* Calculated expressions
* Conditional formatting
* Personalizing content
* Linking to other reports or documents
* Dynamic images
* Multiple data set considerations

* Microstrategy office overview

Advanced Microstrategy desktop

* Introduction to advanced reporting
* Advanced metrics
* Advanced filters
* Consolidations and custom groups
* Advanced prompts and OLAP services
* Drill maps
* Report data options
* Report developer tools

Microstrategy intelligence server

* Introduction to Microstrategy administration
* Architecture and query flow
* Connectivity
* Startup and administration interface
* Security
* Microstrategy intelligence server administration
* Caching and Scheduling
* Datamarts
* Clustering

Microstrategy Narrowcast server

* Narrowcast server overview
* Information source
* Creating a simple service
* Message contents
* Message recipients
* Delivery methods, schedules and service editor
* Personalization
* Subscription portal functionality
* Microstrategy web deliveries and administration

Microstrategy Administration

* MSTR Installation
* Object Manager
* Project Duplication
* System to system code migration in Narrowcast server
* Groups and user creation
* Command manager

DW AB-INITIO 2.10 /2.15 Contents

AB-INITIO 2.10 /2.15

Chapter: 1

* What is an ETL Tool
* Abinitio and its importance

Chapter: 2

* AbinitioProducts
* Co-operating system
* Graphical development environment
* Enterprise Meta Environment
* Data Profiler
* Shop for data
* Connector
* DTM

Chapter: 3

* Abinitio Architecture

Chapter: 4

* Abinitio Graph development life cycle

Chapter: 5

* GDE (Graphical Development Environment)

Chapter: 6

* Abinitio Concepts
* Serial file system
* Layout
* DML
* DBC File
* PARALLELISM
* Joins

Chapter: 7

* GDE Components
* Compress
* Continous
* Database
* Datasets
* De-partition
* Deprecated
* Examples
* FTP
* Miscellaneous
* Partition
* Sort
* Transform
* Translate
* Validate

Chapter: 8

* ETL Admin Commands

DW TERADATA Contents

TERADATA 12

Teradata Warehouse and Competitiveness

* What is Teradata-RDBMS
* Teradata 12 Vs Other versions
* Teradata History
* Teradata in the Enterprise
* Teradata Users & Scalability
* Teradata competitiveness with other RDBMS
* (Oracle, SqlServer etc)
* Teradata Warehouse

Discussion on interview and certification questions

Teradata Architecture and Components

* PDE(Parallel Data Extension)
* Vprocs(Virtual Processors)
* AMP(Access Module Processing)
* Board less Bynet
* TDP(Teradata Directory Program)
* CLI(Call Level Interface)
* TPA(Trusted Parallel Application)

Going in depth by explaining the process of SQL statement execution

Various Architectures

* Node Architecture(Shared Nothing)
* SMP Architecture
* MPP Architecture
* Parallelism Architecture

Benefits and Types

Data Recovery and Protection

* Object Locks

* Various locks for simultaneous access

* RAID 1
* RAID 5
* Disk Arrays
* Fall Back
* Clique
* AMP Clustering
* Journals

* Recovery Journal
* Trasient Journal

* Permanent Journal

* Before Journal
* After Journal

Answering various recovery questions

Teradata Storage and Retrival Architectures

* Request Processing

* Syntaxer
* Resolver
* Security Module
* Optimizer
* Step Generator
* GNC Apply
* Dispatcher

* Primary Index

* Hash algorithm
* Row Hash
* DSW
* Hash Map
* Hash Bucket
* Reaching V disk

Teradata Indexes

* Primary Index

* Unique
* Non unique
* Partitioned

* Secondary Index

* Unique
* NonUnique
* Hash, Join, Value Ordered
* Skewness
* Secondary Index Sub table
* Accessing Records via Primary Index
* Accessing records via Secondary Index
* Keys Vs Indexes

Full Real time scenarios and explaining

Teradata Sql Reference

* Fundamentals
* Data Types and Literals
* Data Definition Statements
* Data Manipulation Statements

Explaining with proper examples

Teradata Functions and Operators

* String Functions
* Format Function
* Cast Functions
* Group & Aggregate Functions
* With & with by clauses

Practices of this section

Teradata Transactions

* Implicit Transaction
* Explicit Transaction

Performance Tuning and Explain Utility

* Explain Usage
* Collecting Statistics
* Tuning SQL Performance
* Usage of PMON

Explaining various SQL statements

Joins and Unions

* Inner Join
* Left Outer Join
* Right Outer Join
* Full Outer Join

Detailed explanation

Join Strategies

* Product Join
* Merge Join
* Hash Join
* Nested Join

Questions of this section

Teradata Basic Commands

* HELP
* SHOW
* EXPLAIN
* COLLECT STATISTICS

Teradata Objects

* Tables

* SET table
* Multi Set table
* Volatile tables
* Global Temporary tables
* Derived tables

* Views
* Macros
* Stored Procedures
* Triggers

Practices and FAQs of this session

Teradata spaces

* PERM space
* SPOOL space
* TEMPORARY space
* Teradata User and managing

Practical Examples

Teradata Transaction Modes

* BTET
* ANSI
* Interactive
* Batch

Load and Unload Utilities & Tools

* Teradata Sql Assistant(Queryman)
* Teradata Performance Monitor
* Teradata BTEQ

* Batch Scripts with samples
* Branching and Looping
* Importing data through scripts
* Exporting data through scripts
* Error handling

Explanation with proper debugging

* Teradata Fast Load

* Various Phases of Fast Load
* Advantages and Process
* Limitations of Fast Load
* Sample Scripts

Real time Issues and resolving it

* Teradata Multi Load

* Various Phases of Multi Load
* Limitations of Multi Load
* Working with multiple tables
* Applying various operations
* Sample Scripts

Real time Issues and solving it

* Teradata Parallel Data Pump

* Limitations of TPump
* Overview of TPump
* Sample Scripts

* Teradata Fast Export

* Exporting Data
* Passing Parameters
* OUTMODS
* Sample Scripts

* Utility Vs Parallelism

Introduction to

* Answering AD-hoc queries and FAQs
* Covering DBA Concepts

Concentrating on Performance Tuning

DW MSBI Contents

MS-BI (SSIS,SSAS,SSRS)

SSIS Objectives

* Plan data transfer and staging solutions for an ETL operation
* Plan an SSIS Solution
* Design and implement data flows
* Incorporate logging, error handling and reliability into a package
* Optimize an SSIS Solution
* Deploy an SSIS Solution

Contents:

Planning for ETL

* Identifying Data Sources and Destinations
* Evaluating Source Data
* Identifying Staging Requirements
* Lab: Planning an ETL Solution

Planning an SSIS Solution

* Planning Packages
* Planning Package Development
* Designing Package Control Flow
* Lab: Implementing SSIS Packages

Designing Data Flow

* Understanding Data Flow
* Designing Data Flow Operations
* Handling Data Changes
* Lab: Implementing Data Flow

Logging, Error Handling and Reliability

* Logging ETL Operations
* Handling Errors in SSIS
* Implementing Reliable ETL Processes with SSIS
* Lab: Implementing Reliable Packages

Optimizing an SSIS Solution

* Monitoring SSIS Performance
* Optimizing SSIS Packages
* Scaling Out SSIS Packages
* Lab: Optimizing Packages

Deploying and Operating an SSIS Solution

* Deploying SSIS Packages
* Operating an SSIS Solution
* Lab: Optimizing Packages

SSAS Objectives:

* Describe how SQL Server Analysis Services can be used to implement Analytical solutions
* Create multidimensional analysis solutions with SQL Server Analysis Services
* Implement dimensions in an Analysis Services solution
* Implement measures and measure groups in an Analysis Services solution
* Query a multidimensional Analysis Services solution
* Customize an Analysis Services cube
* Deploy and secure an Analysis Services database
* Maintain a multidimensional Analysis Services solution
* Implement Data Mining solution

Contents:

Introduction to Microsoft SQL Server 2005 Analysis Services

* Overview of Data Analysis Solutions
* Over of SQL Server 2005 Analysis Services
* Installing SQL Server 2005 Analysis Services

Creating Multidimensional Analysis Solution

* Developing Analysis Services Solutions
* Data Sources and Data Source Views
* Creating a Cube
* Lab: Creating a Multidimensional Analysis Solution

Working with Dimensions

* Configuring Dimensions
* Defining Hierarchies
* Sorting and Grouping Attributes
* Lab: Defining Dimensions

Working with Measures and Measure Groups

* Working with Measures
* Working with Measure Groups
* Lab: Configuring Measures and Measure Groups

Querying Multidimensional Analysis Solutions

* MDX Fundamentals
* Adding Calculations to a Cube
* Lab: Querying a Cube

Customizing Cube Functionality

* Implementing Key Performance Indicators
* Implementing Actions
* Implementing Perspectives
* Implementing Translations
* Lab: Customizing a Cube

Deploying and Securing an Analysis Services Database

* Deploying an Analysis Services Database
* Securing an Analysis Services Database
* Lab: Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

* Configuring Processing Settings
* Logging, Monitoring and Optimizing an Analysis Services Solution
* Backing Up and Restoring an Analysis Services Database
* Lab: Maintaining an Analysis Services Database

Introduction to Data Mining

* Overview of Data Mining
* Creating a Data Mining Solution
* Validating Data Mining Models
* Lab: Implementing Data Mining

SSRS Objectives

* Describe SQL Server Reporting Services and its components
* Create a Reporting Services report
* Enhance a Reporting Services report
* Create and implement data sets
* Use report models to implement reporting for business users
* Configure report publishing and execution settings
* Implement subscriptions for reports
* Implement custom Reporting Services applications

Contents:

Introduction to Microsoft SQL Server Reporting Services

* Overview of SQL Server Reporting Services
* Reporting Services Tools
* Lab: Using Reporting Services Tools

Authoring Basic Reports

* Creating a Basic table Report
* Formatting Report Pages
* Calculating Values
* Lab: Creating a Simple Report

Enhancing Basic Reports

* Interactive Navigation
* Displaying Data
* Lab: Enhancing a Report

Manipulating Data Sets

* Defining Report Data
* Using Parameters and Filters
* Using Parameter Lists
* Manipulating Data Sets

Publishing and Executing Reports

* Executing Reports
* Creating Cached Instances
* Creating Snapshots and Report History
* Lab: Publishing and Executing Reports

Using Subscriptions to Distribute Reports

* Introduction to Report Subscriptions
* Creating Report Subscriptions
* Managing Report Subscriptions
* Lab: Implementing Subscriptions

DW COGNOS Contents

COGNOS 8 BI

Overview of Cognos 8 BI

* Introduce Cognos 8 BI
* Examine the different studios in Cognos 8 BI
* Identify the different data sources within the studios

Cognos 8 Installation and Configuration

* Components used by Cognos 8

* Server Components
* Modeling Components

* Installing Cognos 8
* Uninstalling Cognos 8

Cognos 8 BI Architecture and Planning

* Architecture

* Multi-tire architecture
* Communications
* Workflow
* Security

Cognos 8 Connection

* Examine Cognos Connection
* Run and view reports
* View the run history of a report
* Organize content with folders and shortcuts
* Customize report outputs by using report views
* Schedule single and multiple reports
* Personalize Cognos Connection

Query Studio

* Introduction to Query Studio
* Create Reports (List, Grouped List, Crosstab, Charts)
* Changing the Appearance of Reports (Format)
* Sorting and Grouping
* Filters and Prompts
* Calculations
* Run and Manage Reports
* Drill Through reports

Analysis Studio

* Introduction to Analysis Studio
* Creating a Basic Analysis
* Working with data in Crosstab
* Exploring Data
* Limiting Data
* Calculating Data

Report Studio

* Introduction to Report Studio

* Report Studio User Interface
* Creating, Save and Run Reports
* Report Templates
* Managing Reports

* Types of Reports

* List
* Cross tab
* Charts
* Maps

* Formatting a Report

* Report Layout Guidelines
* Fonts, Styles, Header, Footer and Borders
* Insert objects
* Apply Table Styles
* Swap Columns and Rows
* Create and Modify Classes

* Working with Data

* Filters, Parameters and Prompts
* Sorting and Grouping
* Calculations
* Working with Queries

* Working with Reports

* Managing changes in the Package
* Report Bursting
* Conditional Formatting
* Drill-through Reports
* Drill-up/Drill-down Reports
* Master-Detail Reports
* Scheduling Reports

Framework Manage (Metadat Modeling)

* Introduction to Framework Manager

* Framework Manager Basics
* User Interface, Navigation, Objects

* Designing Project

* Create project
* Importing Metadata
* Exporting Metadata
* Create Model Documentation

* Data Sources

* Working with Data Source Connections
* Create and Modify Data Sources
* Improve Performance by setting Query Processing Type

* Preparing Relational Metadata for use in Reports

* Verifying Relationships
* Working with Dimensions
* Working with Query Subjects
* Working with Query Items
* Supporting Multilingual Metadata
* Adding Business Rules
* Organizing the Model

* Making Metadata Available to Report Authors

* Verify Model
* Set Governors
* Improving Performance
* Create or Modify Package
* Controlling access to Metadata
* Explore Package
* Publish Package

* Guideline for Modeling Metadata

* Scenarios
* New Objects - Regular Dimensions, Measure Dimensions, Scope Relationship
* Dimensional Modeling of Relational Data Sources

Event Studio

* Introduction to Event Studio
* Events

* Event Instance
* Event List
* Event Key
* Task Execution Rules

* Agents
* Tasks
* Creating an agent
* Working with Agents in Cognos Connection

DW BODI Contents

BODI 11.2(DATA INTEGRATOR)

Introduction to Data Integrator

* About Data Integrator
* Data Integrator product documentation

Data Integrator Architecture

* Standard Data Integrator components
* Optional Data Integrator components
* Data Integrator management tools
* Data Integrator operating system platforms
* Data Integrator distributed architecture

Data Integrator Designer

Introduction to Data Integrator Designer

* Logging in to the designer
* Designer overview
* Data Integrator objects
* Working with objects
* General and environment options
* Projects and Jobs
* Data stores
* File formats
* Data flows
* Work flows
* Nested data
* Real-time jobs
* Embedded data flows
* Variables and Parameters
* Executing jobs
* Data Quality
* Design and Debug
* Data Cleansing

Transforms

* About transforms,operation codes
* Address_Enhancement
* Case
* Date_Generation
* Effective_Date
* Hierarchy_Flattening
* History_Preserving
* Key_Generation
* Map_CDC_Operation and Map_Operation
* Match_Merge
* Merge Name_Parsing
* Pivot(columns to rows) and Reverse Pivot(rows to columns)
* Query
* Row_Generation
* SQL
* Table_Comparison
* Validation
* XML_Pipeline

Functions and Procedures

* Overview of functions
* About functions
* Custom functions
* Database and application functions
* Description of built-in functions
* About procedures
* Calling stored procedures
* In general
* From queries
* Without the function wizard

Data Integrator Scripting Language

* About scripting language
* Language syntax
* Syntax for statements in scripts
* Syntax for column and table references in expressions
* Strings
* Quotation marks
* Escape characters
* Trailing blanks
* Variables
* Variable interpolation
* Functions and Stored procedures
* Operators
* NULL values
* NULL values and empty strings
* Debugging and Validation
* Keywords
* Sample scripts
* Export/import

Data Integrator Administrator

* Introduction
* Administrator Management
* Central Repository Management
* Using Server Groups
* Executing batch jobs
* Scheduling jobs
* Trace and monitoring jobs
* Export Execution command
* Using the Administrator
* Using a third-party scheduler
* Data Integrator job launcher

Data Integrator Metadata Reports

* Introduction
* Viewing Metadata Reports

Data Integrator Performance Optimization

* Introduction
* Environment Test Strategy
* Measuring and Tuning Data Integrator Performance
* Using Bulk Loading