Curriculum

With our course based on Business Intelligence, you can gain familiarity over multiple BI tools. Rapid track is a 1 month course with 6 hours of classes per day. For those who want to get hands on experience on projects, we have a specially designed Project Track, which is a course having 3 months of training followed by additional 4 months of Project. And Rapid Track Project course which is same as Project track, the only difference being here you get 1 month of training with 6 hours of classes per day.

 

SL.No
COURSES COVERED
TOOLS
DURATION (Hrs)
1. Basics of RDBMS , Basics of SQL Server and Advanced SQL Server
Need and capabilities of a DBMS, data models, database design, database architecture, concept of transaction management, basic and advanced SQL commands
SQL SERVER 2005
Theory
15
10

Total
25 Hours
2. Basics of Data Warehousing
Introduction to Data Warehousing, Data Warehousing Architecture, Data Marts, Dimensionality Modeling
None
10
NA
3. ETL - Extract transactional data , Data Integration, Loading data into the warehouse
OLAP - Introduction to OLAP, types of OLAP
Reporting - Assessment of current needs and status ,Data source connection capabilities ,Scheduled Reports ,Automated report delivery, Parameter driven reports ,Web based reporting
None
10
NA
4. COGNOS 8: Metadata Modeling/ Query Studio, Report Studio, Analysis Studio/Metric Studio, Security/ Administration. DATA MANAGER
COGNOS 8
Demo 20
25
Total
45 Hours
5. SQL SERVER 2005 BI:
Introduction to SQL Server 2005 BI, ETL, OLAP and Reporting.
SSIS
SSAS
SSRS
Demo 7
8
Total
15 Hours
6.

INFORMATICA 8.1.1

ETL - Introduction to Informatica Powercenter 8.1.1 Architecture Powercenter 8.1.1 Server tools _Powercenter 8.1.1 Client tools Design and Execution process

Source Object Definitions, Target Object Definitions, Transfromation Basic Concepts, Mappings, Reusable Tasks, Session Tasks, Non-Reusable Tasks, Monitoring Workflows, Data Flow Rules – Terminology

POWERCENTER
Demo 10
15
Total
25 Hours
7. BUSINESS OBJECTS XI:
Designer, Web Intelligence, Desk Intelligence, Security/ Administration.
BO WEB INTELLIGENCE XI R2
Demo 8
8
Total
16 Hours
8. PROJECTS: Hands-on projects on Telecom Domain which includes ETL, OLAP and Reporting. TELECOM DOMAIN
NA
25