Smart - I Training

Trainer : Vani S/Shanmughapriya B/Santhosh K
Date : 18-Jun-2009 to 10-July-2009
Venue : Conference Room
Duration : 30 hours

The Smart i Appliance is a low-cost, data analytics solution for small and mid-size businesses seeking the benefits of Business Intelligence without the cost and complexity of current solutons. Smart i is based on easy-to-use, proven technologies of the IBM System i and Power Server,the first Open Source ETL sofware from Talend, and IBM's powerful Web Query analytcs engine.

The training program comprises the following:

Introduction to AS400

Introduction to Db2 and usage of Db2 in Smart-i

Introduction to Talend Integration Suite in the context of Smart-i

Introduction to web query architecture and report development

The training was followed by workshop and certification exam

Netezza Expert

Trainer : Karthikeyan Sethuraman /Shanmughapriya
Date : 09-Jun-2009 to 26-Jun-2009
Venue : Conference Room
Duration : 10 hours

It is essential for a Data Warehouse expert to know the advance concepts of Netezza as it helps you to work in the ETL projects independantly. The DW Professionals who cleared the Netezza Prefessional course can attend this course.

The concise course content is as follows:

Introduction to command line interface

Overview of NZSQL

Accessing other Database and Cross Database Access

Analyzing Query Performance

Workload Management and DBOS

Netezza Silver Certification questions was given to the trainees as special exercise before the certification exam.

Netezza Professional

Trainer : Karthikeyan Sethuraman /Yashpal Saini/Sundar Ravanan
Date : 18-May-2009 to 28-May-2009
Venue : Conference Room
Duration : 10 hours

Netezza is a booming data warehouse appliance in recent times. Hence it has become an essential trait for a BI consultant to understand the basics of Netezza as it helps a great deal to work in the ETL projects.

The concise course content is as follows:

Introduction to Unix

Introduction to Architecture and Administration

Database objects overview

Basic commands and its operations

Connectivity and Statistic Planning

Microstrategy Dashboards

Trainer : Vidya latha Karunakaran
Date : 18-May-2009 to 27-May-2009
Venue : Conference Room
Duration : 10 hours

Dashboard’s have become very popular with Business managers as they

Help gain quick insights into data and trends

Monitor performance indices and track leading as well as lagging indicators

Convert the business data into a ‘picture’ to easily communicate the story.

The strength of Report Services(Dashboards) and popularity had been the foundation for the training.
The following are the concepts covered in the training:

Document Basics

Document Design Concept

Useful Design Techniques

Microstrategy Expert

Trainer : Dinesh Rajendren
Date : 13-Apr-2009 to 15-May-2009
Venue : Conference Room
Duration : 24 hours

The expert training focuses on the advanced concepts of Microstrategy.
This training provides in depth technical knowledge on all the features of Microstrategy which helps the associates to be in a better position to build reports and dashboards.

The course content includes:

MicroStrategy Desktop: Advanced Reporting

MicroStrategy Intelligence Server Administration

Advanced features of MicroStrategy Office

MicroStrategy Narrowcasting Server

MicroStrategy Enterprise Manager

Microstrategy Web Report Designer

Webinar

Topic: Unify Data at the Speed of Business with Oracle Data Integration
Venue: Conference Room
Date: 08–May-2009

The webinar was about the ETL tool released by ORACLE wherein the initial half hour talk discussing about the tool. The latter half was about a migration project done in Raiffeisen International Bank from Data Stage to Oracle Data Integration.The presenters are from various continents and they are highly accented in their speech

Microstrategy Professional

Trainer : Keerthana Venkatesan
Date : 04-May-2009 to 08-May-2009
Venue : Conference Room
Duration : 10 hours

Microstrategy has been reigning as the most efficient reporting tool for delivering business intelligence solutions. The purpose of this training is to give an insight to BI consultants on the various components of Microstrategy.

The training session focused on the following:

MicroStrategy Desktop : Reporting Essentials

MicroStrategy Architect : Project Design

MicroStrategy Office Essentials

MicroStrategy Report Services

Microstrategy Web Report Analysis

Teradata Professional

Trainer : Palanivelu Muthukrishnan
Date: 14-Apr-2009 to 29-Apr-2009
Venue: Conference Room
Duration: 12 hrs

The objective of this training program is to make the associate work with fundamentals of this database.

The course covered the following:

Teradata Architecture

Teradata Management Systems

Loader Utilities

Indexing Concepts

Data Storage methods

Webinar

Topic: Crystal Reports
Venue: Conference Room
Date: 10–APR-2009


This session gave a brief insight on

Introduction to Crystal reports.com

Special Features of Crystal reports.com

Walk through the interface of crystal reports.com

Presentation Skills

Trainer : Sudha Gopal
Date : 31-Mar-2009
Venue : Conference Room
Duration : 2 hours


Being consultants we ought to know what are the different tones of presentations and how it has to be delivered. This was the prime objective of this session by Sudha Gopal. As a part of this training program a video was also played which demonstrates how an associate can prepare as well as deliver a good presentation.

SSIS training

Trainer: Satish Narayanan Rajagopal
Date: 26-Mar-2009 to 30-Mar-2009
Venue: Training room
Duration: 6 hrs

It is very important for us to learn the latest tools from the popular vendors in order to excel in the business. The same goes to Microsoft Sql Server 2005. The session got in detail with integrated services which is an ETL part of this tool. Training includes the below listed essentials concepts of advanced level

Overview of Sql Server 2005 and its Components

Introduction to Sql Server 2005 Integrated Services

Architecture of Sql Server 2005 Integrated Services

Overview of Sql Server 2005 Integrated Services Utilities· Sql Server 2005

Integrated Services - Data flow elements

Overview of Scheduling

Webinar

Topic: Dashboards: Not Just For C-Level Executives
Venue: Conference Room
Date: 24 – Mar - 2009

This session organized by Information management team gave a brief insight on

How to determine which key data points to portray in a dashboard

Why mixing and matching data sets makes a big difference

Best practices for designing interactive dashboards

The value of collaboration and personalization

Common mistakes in data visualization, and how to avoid them

The importance of clearly delineating trends and outliers

Oracle Business Intelligence Professional

Trainer : Yogendra Kumar
Date : 18-Mar-2009 to 20-Mar-2009
Venue : Conference Room
Duration : 6 hours
It is very essential for us to keep up with the new trends in the data warehouse industry in order to help a wide range of clients to take certain vital business decisions. This session by Yogi was able to provide the fundamental of this tool. The session also included exercises on creating the business catalogs.
Training includes the below listed essentials concepts:

Describe the role of key components in Oracle BI architecture

Describe the relationships among the components

Identify and describe repository features and functions

Design the repository and test the repository using Answers

Build queries in Oracle BI Answers

Create and modify Oracle BI Interactive Dashboards

Schedule, publish a report created from OBI answers using ibots.

Business Objects Professional

Trainer : Sridhar Koilada / Pawan Kumar
Date : 18-Feb-2009 to 24-Feb-2009
Venue : Conference Room
Duration : 10 hours

The purpose of this training program is to build the fundamentals of BO XI architecture, new features/components of BO, design a universe with necessary contexts, resolve loops, traps and create objects, hierarchies. During the program the associates were thought how to create reports and format them according to the requirements. Brief course content is as below,
· Business Objects XI R2 architecture· Overview of Business Objects Universe Design
. Business Objects Desktop Intelligence Report Design
. Import and Export universes, reports to repository.

Microstrategy professional

Trainer : Maruthu Pandian / Jayalakshmi
Date : 12-Feb-2009 to 16-Feb-2009
Venue : Conference Room
Duration : 12 hours

Microstrategy has been reigning as the most efficient reporting tool for delivering business intelligence solutions. The purpose of this training is to give an insight to BI consultants on the various components of Microstrategy.

The training session focused on the following:
· MicroStrategy Desktop : Reporting Essentials
· MicroStrategy Architect : Project Design
· MicroStrategy Office Essentials
· MicroStrategy Report Services

Webinar

Topic:Open source is the solution to your data integration problems
Venue: Conference Room
Date: 05 – Feb- 2009

The webinar conducted by Talend dealt with

How change data capture (CDC) enables real time integration

The various techniques available to detect changes in your databases and applications

Applying CDC to synchronization, replication, and event publishing

Why CDC is also relevant to ETL for data warehousing

Webinar

Topic: Walk through - Cognos 8 BI Suite
Venue: Conference Room
Date: 30 – Jan- 2009

The webinar focused on

What is Cognos 8 BI

Overview

Simplified deployment and ease of use

Complete range of capabilities

Proven technology

Summary

Microstrategy Dashboards

Trainer : Vidya latha Karunakaran
Date : 29-Jan-2009 to 3-Feb-2009
Venue : Conference Room
Duration : 10 hours

Dashboard’s have become very popular with Business managers as they

Help gain quick insights into data and trends

Monitor performance indices and track leading as well as lagging indicators

Convert the business data into a ‘picture’ to easily communicate the story.

The strength of Report Services(Dashboards) and popularity had been the foundation for the training.
The following are the concepts covered in the training:

Document Basics

Document Design Concept

Useful Design Techniques

Project Experience Sharing

Trainer : Vinayak Thatte
Date : 28-Jan-2009
Venue : Conference Room
Duration : 1 hour

Vinayak Thatte shared his knowledge about the issues he faced and the methodologies adopted to overcome the various drawbacks while working with Netezza. He threw light on the business of American Red Cross and Nationwide Finance and his experience while dealing with the client. He brought our focus on how to effectively communicate with the client and its impact and the importance of email communication.

Project Experience Sharing

Trainer : Palanivelu Muthukrishnan
Date : 12-Jan-2009
Venue : Conference Room
Duration : 1 hour

Palanivelu Muthukrishnan shared his valuable experience on working with the Gaming industry. He gave us a deep insight into the pros and cons of gaming business. He also discussed on the different kinds of games played and the various strategies which these organizations adopt to make profitable business.