Contact Us:
USA : +1 732-744-3369
India :+91-80-26687171

 

 
Training Services

Learn Data Warehousing and engergise your career. Take up our specilaised course that has evolved from our BI implementation experience. Master a wide range of Business Intelligence tools around a central core of concepts. Practise in an advanced lab running high-end software from IBM, Oracle, Cognos and Microsoft. Choose from a number of course options that suit your individual requirements of duration, including a project course, built around real life case studies.Experience comes with time. The Project Track course is designed for those wanting to gain project experience. so that at the end of the program you are armed with the experience and training required to be a successful Data Warehousing Professional.Defy project risks. Before the project starts, answer the challenge of end users’ resistance to change with our workshops and seminars; seminars that create a common vision for them and set their expectations. Once the project takes off, and you face the constant risk of manpower attrition, depend on our training division to get access to skilled BI resources trained on a wide range of technologies.Accurate information about tools and how they match up to your needs is nearly impossible to find - confusion rules. So there is always this risk of choosing the appropriate technology. But since we have tried and tested most of these, we can help you make the right choice through evaluations, proof of concept and benchmarks.

Corporate Training Services:

Corporate training is a tailor made program focussed on specific needs identified by an organization. The modules and duration are relative to the requirement.However, we have certain standard modules which are most popular with the corporate sector which have proved phenomenal results.

How Is The Breakthrough Experience Unique?

In today’s dynamic fast paced world of “ No Borders “, the challenge of a successful investment is to sustain the change beyond the classroom into the working environment. In essence, as radical as it may sound, a paradigm shift is needed to breakthrough the mind set and change age old behavioral patterns that do not relate to today’s business practices.
1.Introduction to DWH :
Day Hour Topic
Day 1 hour 1 - 4

Introduction to DWH and BI            
    All about OLTP and OLAP
    About DWH TOOLS

2.Introduction to ETL and SSIS

Day Hour
Topic
Day 1
hour 1
What is ETL
 
hour 2
ETL Process
 
hour 3
Introduction to SSIS
 
hour 4
Overallsummary
Note: Practices on past 4 Hours for 4 Hours
Day 2
hour 5
SSIS architecture
 
hour 6
Business intelligence development studio
 
hour 7

Creating source and  destination

Note: Practices on past 4 Hours for 4 Hours
Day 3
hour 8
Overview of transformations
 
hour 9
Dataconversion,  copycolumn, derived column
 
hour 10
Hands on above transformations
Note: Practices on past 4 Hours for 4 Hours
Day 4
hour 11
Aggregator, Sorter, Rowsampling,
 
hour 12
Hands on above transformations
 
hour 13
Summary

Note: Practices on past 4 Hours for 4 Hours
Day 5
hour 14
lookup, pivot, unipivot,
 
hour 15
Hands on above transformation
 
hour 16
Summary
Note:Practices on past 4 Hours for 4 Hours
Day 6
hour 17
SCD, export, import, audit, row count, lookup
 
hour 18

Hands on above transformations

 
hour 19
Summary
Note: Practices on past 4 Hours for 4 Hours
3. Cognos8 Framework Manager & Connection Manager

Days

Hours Topics
Day 1
hour 1
Framework Manager
 
hour 2
Designing a Project I
 
hour 3
Designing a Project II
 
hour 4
Designing a Project III
Note: Practices on past 4 Hours for 4 Hours
Day 2
hour 5
Data Sources I
 
hour 6
Data Sources II
 
hour 7
Preparing Relational Metadata for Use in Reports I
 
hour 8
Preparing Relational Metadata for Use in Reports II
Note: Practices on past 4 Hours for 4 Hours
Day 3
hour 9
Preparing Relational Metadata for Use in Reports III
 
hour 10
Preparing Relational Metadata for Use in Reports V
 
hour 11

Preparing SAP BW Metadata for Use in Reports I
 
hour 12
Preparing SAP BW Metadata for Use in Reports II

Note: Practices on past 4 Hours for 4 Hours

Day 4
hour 13
Preparing SAP BW Metadata for Use in Reports III
 
hour 14
Making Metadata Available to Report Authors
 
hour 15
Guidelines for Modeling Metadata
 
hour 16
The SQL Generated by Cognos 8

Note: Practices on past 4 Hours for 4 Hours
Day 5
hour 17
Guidelines for Modeling Metadata
 
hour 18
The SQL Generated by Cognos 8
 
hour 19

Cognos Connection I Access Permissions
  hour 20

Cognos Connection II Reports and Cubes
Agents Microsoft Office Documents Schedule Management Troubleshooting Cognos Connection

Note: Practices on past 4 Hours for 4 Hours
4. Query Studio and Report Studio
Day Hour Topic
Day 1
hour 1
Using Query Studio I
 
hour 2
Using Query Studio II
 
hour 3
Using Query Studio III
 
hour 4
Working with Data I
Note: Practices on past 4 Hours for 4 Hours
Day 2
hour 5
Working with Data II
 
hour 6
Working with Data III
 
hour 7
Troubleshooting
 
hour 8
Samples I
Note: Practices on past 4 Hours for 4 Hours
Day 3
hour 9

Samples II Chart Types
 
hour 10

Report Studio I

 
hour 11

Report Studio II
 
hour 12

Types of Reports I

Note: Practices on past 4 Hours for 4 Hours
Day 4
hour 13
Types of Reports II
hour 14

Types of Reports II
hour 15
Formatting a Report I
hour 16
Formatting a Report II
Note: Practices on past 4 Hours for 4 Hours
Day 5 hour 17
Working with Data I
  hour 18
Working with Data II
  hour 19
Working with Existing Reports
  hour 20
Working with Existing Reports

Note: Practices on past 4 Hours for 4 Hours

Try It Yourself Exercises

Create a List Report
Create a Crosstab
Create Charts
Create Map Reports
Show the Distribution of Revenue by Country
Show Revenue and Margins for Cities in the United States
Add Prompts
Create a Multiple Page Report
Create a Template
Create an Invoice
Create a Dashboard Report
Create a Dynamic Report That Shows Period-to-date Data
Create a Report with Drill-through Access to Itself
 
Copyright © 2010 Aviana Nrit Pvt Ltd.