Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info
ONLINE TRAINING FOR DATA-WAREHOUSING
DATA WAREHOUSING
Introduction to Data Warehousing
* What is Data Warehousing?
* Who needs Data Warehousing?
* Why Data Warehouse is required?
* Types of Systems
(i) OLTP (ii) DSS (iii) OLAP
* Maintenance of Data Warehouse
* Data Warehousing Life Cycle
Data Warehousing Architecture
* Source
* Integration Layer
* Staging Area
* Target
* Analysis & Reporting
* ODS
* HPQS
Multi-Dimensional Modeling
* What is a Dimension?
* What are Facts?
* Multi-Dimensional Model
* Hierarchies
* OLAP
* MOLAP
* ROLAP
* HOLAP
* Cubes and its Functions
* Start Schema
* Fact Table
* Dimensional Tables
* Snow Flake Schema
* Factless Fact Table
* Confirmed Dimensions
1.Informatica Power Center 7.1.1/ 8.1.1/8.6
Introduction
* Overview
* Basic Definitions
* Informatica Products
* Intormatica Architecture
* Tools and their roles
* Folders-Sub folders
* Power Center / Power Mart
Informatica Designer – Introduction
* Introduction to Designer
* Logon to Designer
* Designer interfaces
* Designer Tools
* Defining Sources
(i) Database as a source
(ii) Flat File Sources
* Defining Targets
* Importing from database
* Creating a new target
* Creating target database objects
Informatica Designer
* Mapping Introduction
* Source Qualifier
* Ports
* Mapping – Table to Table
* Mapping Flat File to Table
* Connected/Unconnected Transformations
* Active and Passive Transformation
* Source Qualifier Transformation
* SQL Override-Source Qualifier Transformation
* Mapping Source Qualifier and Filter
* Source Qualifier to Join Data
* Filter Transformation
* Expression Transformation
* Sequence Generator Transformation
* Rank Transformation
* Router Transformation
* Aggregator Transformation
* Joiner Transformation
* Stored Procedure Transformation(Connected & Unconnected)
* Union Transformation
* XML Transformation
* Mapping Wizards
* Implementing Type-I, Type-II, Type-III Mappings
Informatica-Workflow Manager
* Workflow Introduction
* Tasks
* Workflow tools
* Connections
* Defining tasks
(i) Command tasks
(ii) Email Task
(iii) Session Task
(iv) Link Conditions
(v) Event Wait & Event Raise
* Setting Properties of Session Task
* Creating Workflow
* Starting Workflow
* Monitoring Workflow
Informatica Advanced Features
* Incremental Aggregation
* Mapplet Implementation
* Target Load Plan
* Constraint Based Loading
* Mapping Parameters
* Mapping Variable
* Session Parameters
* Link Conditions
* Reusable Transformation
* Task and Types of Tasks
* Work let and types of work lets
* Scheduling Workflow
* Control flow using command task and event wait task
* Perform testing ETL
* Unit Testing ETL
* System Testing ETL
* Incremental Loading
* Performance Tuning
* File Repository
2.BOXI / R3
INTRODUCTION:
* Datawarehouse concepts
* Difference between Versions 5.x/6/5/XI R1, R2, R3
* Business objects XIR3 Suite
* Role of Business objects in Data warehousing real time life cycle.
Designer:
* Understanding how universes allow users to query databases using their everyday business terms
* Creating an ODBC connection to the course database
* Creating a universe
* Populating the universe structure
* Defining joins in a universe
* Understanding classes and objects
* Creating classes and objects
* Understanding measure objects
* Working with LOVs in Designer
* Creating a cascading LOV
* Resolving loops using aliases
* Resolving loops using shortcut joins
* Resolving loops using contexts
* Resolving chasm traps
* Resolving fan traps
* Restricting the data returned by objects
* Using @ Functions
* Working with hierarchies
* Using derived tables
* Creating links between universes
* Setting access restrictions on a universe
* Documenting universes
* Deploying and maintaining universes
Advanced Designer:
* Use your universe design and Business Objects Universe Designer knowledge to solve Business problems
* Define aggregate awareness
* Apply aggregate awareness to objects
* Combine database functions in objects
* Construct relative data-time objects
* Create complex predefined conditions
* Work with advanced LOVs
* Work with advanced join syntaxes
* Define connection and user credential parameters
* Work with Central Management Server (CMS) universe security
* Move content from development to production
* Maintain universe design
* Work with OLAP universes
Designing Topics We can Show by using Following Databases
* Oracle
* Ms-Access
* SqlServer
* TeraData
* External Files (Flat files)
Desktop Intelligence:
* Introduction to desktop intelligence
* Report Creation
* Publishing the report
* Report conversation (desktop) to (Webi)
Webi Reporting:
* Accessing information with Web Intelligence
* Understanding how universes allow you to query database using everyday business terms
* Understanding Web Intelligence core functionalities
* Creating a document in the Web Intelligence Rich Client
* Building a simple query
* Modifying a document query
* Working with query properties
* Restricting data with query filters
* Modifying a query with a predefined query filter
* Applying a single-value query filter
* Using prompts to restrict data
* Using complex filters
* Working in the Report Panel
* Displaying data in tables and charts
* Using breaks and cross tabs
* Formatting break, calculations, and report filters
* Formatting breaks and cross tabs
* Using default and custom sorts
* Ranking data to see top or bottom values
* Using alerter to highlight information
* Organizing a report into sections
* Copying data to other applications
* Preparing document for PDF and print
* Document formatting
* Formatting charts
* Understanding formulas and variables
* Understanding how Web Intelligence calculates data
* Creating formulas and variables to calculate data
* Adding a new query using a personal data provider
* Creating multiples queries in a document
* Synchronizing data with merged dimensions
* Analyzing the data cube
* Drilling into the data
* Setting Web Intelligence drill options
* Exporting documents from the Rich Client
* Accessing Info View
* Scheduling a Web Intelligence document
* Setting Info View preference
Advanced Webi reporting:
* Using combined queries
* Using sub-queries
* Creating a query based on another query
* Changing data sources
* Understanding the impact of the query drill on performance
* Understanding calculation contexts
* Redefining calculation context
* Using character string functions
* Using the replace( ) function
* Using the right ( ) function
* Using the Substring ( ) function
* Using the Pos ( ) function
* Using If ( ) to group data
* Using data tracking
* Using additional report function
* Understanding the options for creating hyperlinks in Web Intelligence
* Creating hyperlinks in the different Web Intelligence interfaces
Webi rich client:
* Web Intelligence Rich Client general preferences
* To create a new document in Web Intelligence Rich Client without Universe
* To select a universe in Web Intelligence Rich Client
* How does Web Intelligence generate combined queries?
* Scope of analysis
* Levels of scope of analysis
* To set the scope analysis
Introduction to Dashboard:
Creating Dashboards
* What is Dashboard Builder?
* Creating an Analytic based on a Universe Query
* Creating a Corporate Dashboards folder
* Creating a pie chart based on sales of product lines
• Selecting data for the pie chart
• Saving your pie chart
* Creating a bubble chart that compares product line sales to Revenues
• Selecting data for the bubble chart
• Saving your bubble chart
* Scheduling an Analytic Refresh
• Scheduling a refresh on your bubble chart
* Designing a Corporate Dashboard
• Analytics in dashboards
• Set the dashboard preferences
• Creating a dashboard
• Add a text analytic to the dashboard
* Creating a speedometer gauge that shows profit margins
• What is a speedometer?
• Getting Started Creating Dashboards
• Selecting the data for the speedometer
* Creating a dashboard tab that contains analytics
* Creating a dashboard sub tab with web page and viewer analytics
• Creating a sub tab
• Adding a web page analytic to the sub tab
• Adding a viewer to the dashboard sub tab
Data source Migration:
* Migrating reports and data sources
* Migration options
* Modifying the migration setting
Import Wizard / Report Conversation:
* Using Import wizard
* Creating of BIAR
* MIGRATING The BO objects from one CMS TO ANOTHER CMS
* Migrating the objects from one domain to another (dev/stage/Prod)
Publishing:
* Publish the Webi report between different CMS
* Publish the converted reports (deski to webi) to destination servers
* Publishing the repository objects
CMC/CCM/CMS:
* Introduction of Window and web based Central management in BOXIR3
* Roles and responsibilities of Contents of CCM/CMS/CMC
* When to use CCM/CMS/CMC
* Detail description of contents of CCM/CMS/CMC
* Case study
Crystal Report 2008
* Introduction to Crystal Reports
* Creating Reports
* Selecting Records
* Organizing Data on Reports
* Formatting & Section Formatting
* Creating basic and complex formulas
* Using Variables and Arrays
* Using Report Templates
* Applying Conditional Reporting
* Building parameterized and specialized reports
* Summarizing Data with Cross Tabs
* Using Report Sections
* Representing Data Visually
* Managing Reports
* Distributing Reports
* Using Repository and Repository data sources
* Report Processing
* Using sub Reports
* Using Custom Functions
* How to Publish Crystal Report in Bo-Enterprise Portal
* Scheduling
Bo-Administration:
* Computer setup
* Business Objects Enterprise Architecture
* Creating Folders, Users and groups
* Publishing and configuring the servers
* Scheduling
3.MicroStrategy
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
4.COGNOS 8.4 BI
* About Cognos 8BI
* Architecture
* Cognos Suit
* Cognos Features
* Difference between Cognos and Other OLAP tools
* Cognos Release
Cognos Connections
* How to connect to different Data Sources
* How to provide security to the Package
* Import and Export of Package (Deployment)
* Running the Report Burn.
* Scheduling
Framework Manager
* About Framework Manager
* Creation of Interface and Usage
* Creating Model & Name space (Layers)
* Importing Meta data
* Creating Query Subjects & Query Items
* Merging Query Subjects
* Creating Relationships & Setting Cardinalities
* Creating Parameter Maps & Macros
* Creation of Model Filters, Prompts & Calculations
* Creating Package & Security Settings
* Publishing Package
Query Studio
* Introduction
* About Ad-hoc Reports
* Types of Reports (List, Cross Tab, Chart Reports & Others)
* Applying Filters, Prompts & Calculations
* Sorting, Grouping, Sections & Aggregate functions
Report Studio
* Type of Report Templates
* Creating List, Cross Tab, Chart & Other Reports
* Map Reports
* Formatting Reports
* Generating and Creating Prompt Page
* Types of Prompts
* Query Calculations & Layout Calculations
* Static Filters and Dynamic Filters
* Conditional Block
* Conditional Formatting
* Master Detail
* Cascading Prompt
* HTML Items & Hyperlinks
* Set Operators
* Setting Burst Options
* Setting Variables
* Report Functions
* Report Validation
* Reports Run with Options
Analysis Studio
* Insert Data
* Change the number of Visible Items
* Nest Data
* Replace Data
* Sort Data
* Explore Data
* Change the measure
* Drill down for Details
* Hide Items
* Focus on significant Items
* Show data as a Chart
* Calculate
* Switch between percentages and values
* Insert a calculation
* Save a custom set
* Define a filter
* Compare sets of data
* Using Dynamic Context
Event Studio
* What is Event Studio
* Event Studio Features
* Event Life cycle Management
* Workflow of Tasks
* Why Event Life cycle Management
5.Abintio
Introduction to Ab Initio.
Operating Systems & Hardware Platforms that it supports
* Products of Ab Initio Software Corporation
o The Ab Initio Co>Operating System
o Graphical Development Environment (GDE)
o The Ab Initio Enterprise Meta>Environment (EME)
* Salient Features of Ab Initio
* Understanding the High Level Architecture of Ab Initio
* What is the Anatomy of Running a Job? What happens when we push the ‘Run’ Button?
o Deployment Process
o Host Process Creation
o Agent Process Creation
o Component Process Creation
o Successful Component Termination
o Agent Termination
o Host Termination
o Abnormal Component Termination
* How do we Connect from GDE to the Server (Run -> Settings)
o Host Profile File (.aih)
o Connection, Co-Operating System, Shell & Host Directory
* What is Graph Programming? What are the basic parts of an Ab Initio Graph?
* Broad Classification of Components
o Dataset Components
o Program / Computing Component
* Data Manipulation Language (DML)
o Record Formats
o DML Expressions
o Transform Functions
o Key Specifiers
* How do we build a basic Ab Initio Graph? Using .dat(Data File) & .dml(Record Format File)
* Dataset Components
o Input File
o Output File
o Intermediate File
o Lookup file
* Editors in the GDE
o Record Format Editor
o Expression Editor
o Transform Editor
o Key Specifier Editor
o Package Editor
o Variables Editor
o Sequence Specifier Editor
* Transform Functions
* Transform File(.xfr)
* Functions, Variables, Statements & Rules
* Transform Components - Multistage and Advanced Components
o Filter by Expression
o Dedup Sorted
o Reformat
o Aggregate
o Scan
o Rollup
o Join
o Match Sorted
o Normalize
o Denormalize Sorted
* Lookup Dataset’s & DML Lookup Functions
* Partition Components
o Broadcast
o Partition by Key
o Partition by Expression
o Partition by Percentage
o Partition by Range
o Partition by Round-Robin
o Partition with Load Balancing
* Multifiles and Multidirectories
* De-partition Components
o Concatenate
o Gather
o Interleave
o Merge
* What is Parallelism - Types
o Component ||’sm
o Pipeline ||’sm
o Data ||’sm
* Repartitioning – When & Why
* Layout Implications
* Sort Components
o Sort
o Sort within Groups
o Sample
o Partition by Key & Sort
* Working with Database’s. Introduction Database Configuration File (.dbc)
* Interactive Database Components (IDB)
o Input Table
o Output Table
o Run SQL
o Truncate Table
o Update Table
o Join with DB
* Miscellaneous Components
o Redefine Format
o Gather Logs
o Replicate
o Run Program
o Thrash
* Deprecated Components
o Find Splitters
* Compress Components
o Compress
o Uncompress
o GZip
o GUnzip
* File Transfer Protocol (FTP) Components
o FTP From
o FTP To
* Testing and Validation of Ab Initio Graphs using Validate Components
o Check Order
o Compare Records
o Validate Records
o Generate Records
o Generate Random Bytes
o Compute Checksum
* Compare Checksum
* Phasing & Checkpointing
* Reusability Features
o Sub graphs
o Graph Parameters
* The Ab Initio Enterprise Meta>Environment(EME)
o High level anatomy of the EME
o Relation to sandbox environment
o Checking in your sandbox
o Checking out a graph or a sandbox
o Locking in order to change an object
o Tagging
o Common projects
o Dependency and Impact analysis
* Performance Tuning Ab Initio Graphs
o What is Good Performance?
.. Going Parallel
... Serial Inputs
... Phases
... Record Formats and Components
... Memory Usage
... Various Tips
Should you require any further information please do not hesitate to contact us Email id: trainings@keentechnologies.com
website URL:http://www.keentechnoligies.com
We offer you:
? Interactive Learning at Learner’s convenience
? Industry Savvy Trainers
? Learn Right From Your Place
? Customized Curriculum
? Highly Affordable Courses
? Support after Training
1) Resume Preparation
2) Certification Guidance
3) Interview assistance
Respond to this adAd ID: 294747
Similar ads:Easy Learning Courses, is an organisation that conducts vocational training, computer courses and several other professional courses that help our students in either acquiring a ... H2kinfosys is a one of foremost online training institute that offers on demand courses on testing tools and other software technologies. We deliver comprehensive qa testing ... Business Analysts are subject matter experts that can perfectly bridge the gap between real businesses and their virtual counterparts. A good understanding of software systems, a ... Bigdata is simply data that is not of a specific form, typically large and unconventional. We are all familiar with data of this sort, but the recent conundrum that businesses ... We are mobile based growing IT company in noida, who provides client outsourcing services in mobile and web application development. Funki Orange technologies offer Industrial ... TIBCO ActiveMatrix BPM Overview:
TIBCO ActiveMatrix BPM is used to develop, deploy, execute and manage Business Process Management centric applications. TIBCO ActiveMatrix BPM ... What is JavaScript?
JavaScript is a dynamic computer programming language. It is most commonly used as part of web browsers, whose implementations allow client-side scripts to ...
