L-K

L-K Industries
blog

Outsourcing to India or Asia

We help our clients on their behalf by creating facilities or by identifying CROs in India for statistical, SAS programming, and data management support. We help in recruiting and imparting training in biostatistics and SAS programming of efficacy and safety summary tables, listings, and figures.
Corporate Training

Updated News

Congratulation Abhishek Dutta for scoring 100% in SAS certification

IISASTR aimed at providing world-class Training in the area of Research Analytics (courses offered both regular and Distance), Covering domains such as:

* SAS®/Clinical
* SAS®/Finance
* SAS®/Banking
* SAS®/Advanced Analytics
* SPSS®/Market Research
* Excel/Analytics
* Minitab

IISASTR was proud to train The Royal Bank of Scotland N.V. (RBS) for SAS training.

New course : SAS Enterprise Guide Syllabus
OUR Student Jitendra Singh(M.Tech B.Tech Dual Degree ,IIT Delhi) has Joined Associate Risk Analyst at HSBC Click here for his feedback for SAS training in Delhi
SAS Trainers
Data Warehouse syllabus


Informatica COURSES WITH DURATION AND Fee DETAILS
Duration :30 hours
Fee   :rs 15000/-

CC BRIEF TOPIC WEEKS
ITP ORACLE 9i,SQL,PL/SQL 4
DW22 DATA WAREHOUSE 5
LP LIVE PROJECT 8

 

Induction Training Program on Oracle 9i, SQL,PL/SQL

Pre-requisite: Some knowledge of programming logic

ITP1

Oracle data types, DDL, DML, DCL, TCL

ITP2

Tables, constraints

ITP3

Query Processing using operators and Buit in function

ITP4

Managing vies, synonyms, sequences and object privileges

ITP5

Table Partitioning

ITP6

Intro To PL/SQL, Cursor etc

ITP7

Creating and managing Procedures, Functions and Packages

ITP8

Creating and Managing Indexes

ITP9

Creating and managing DML Triggers on tables, Instead of triggers on views

Data Warehousing and Project Management

Bi1

Materialized Views and Dimension

Bi2

Relational and dimensional Design using ERWIN

Bi3

Informatica PowerCenter 7 Designer, Workflow Manager and Workflow Monitor

Bi4

Informatica Power Center 7 Level 1 Developer
Data Integration Concepts : PowerCenter Components and User Interface : Source Qualifier, Workflow Scheduler, Reusable Transformations, Debugger, Detail Review of the Expression, Filter, Sorter , Aggregator, Joiner, Lookup, Update Strategy, Router and Sequence Generator Transformations. Source and Target Overrides, Parameters and Variables; Self-Join; Incremental Aggregation; Dynamic Lookup Cache; Mapplets; Workflow Configuration and Techniques; Reusable Schedule for a Workflows; Session Configuration; Task and Worklets;

Bi5

Informatica PowerCenter 7 Level 11 Developer
Advance Mapping Techniques; Advance Workflow Techniques; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Partitions

PROJECT MANAGEMENT

PM1

Software Project Management Strategies & Project Management Life Cycle

PM2

Software Estimation and Function Point Analysis

PM3

Software Inspections and Defect Management

PM4

LIVE PILOT PROJECT

Cognos  COURSES WITH DURATION AND Fee DETAILS
Duration :30 hours
Fee  RS 15,000/-

 

About Cognos 8

Cognos 8 Business Intelligence (BI) offers a single, strong BI reporting and analysis product for support of analytic and enterprise reporting. The product is strong in all three areas — analytic functionality, application development, and usability with comprehensive support for unification, internationalization, and open APIs, and strong support for OLAP, query, metadata, dashboards, and scorecards. Cognos is one of a growing number of vendors — including Actuate, Business Objects, Hyperion, Microsoft, and MicroStrategy — that offer both analytic and enterprise reporting capabilities. However, Cognos 8 BI is a completely new, Web-based product that incorporates much of the functionality from Cognos legacy BI products such as PowerPlay, Metrics Manager, Impromptu, ReportNet, and others. Cognos is a leader in both analytic and enterprise reporting.

Day 1

Overview of Data warehousing  & Cognos 8 BI
Overview of Data warehousing
Dimensional Modeling
Introduction to Cognos
Examine the different studios in Cognos 8 BI
BI Architecture

Day 2

Framework Manager

Data Sources and metadata modeling
Data Modeling and relational & dimensional data
Types of Relationship in FM
Star Schema Grouping

Day 3

Framework Manager- - Continued

Creating Query Subjects/Query Items/Namespace/Filters/Folder
Properties of Query Items – Usage Property/Aggregate Property
Creating NameSpace/Project, Model and Package.
Publishing Package and Exploring Package

Day 4

Cognos Connection – Web Portal

Overview of Cognos Connection
Define Report/Run Report
Schedule Single/Multiple Report
View  Report/Run History of a Report/Report Output Version
Distribute a Report
Create Report Views/Set Preferences
Organize Content in Cognos Connection
Searching Entries in Cognos Connection

Day 5

Query Studio

Examine Query Studio
Create Reports – Lists, Grouped List, Crosstab, Charts.
Sorting, Grouping, Filter
Add Calculated/Summarized Data
Conditional Formatting/Advanced Filters
Format a Report

Day 6

Report Studio

Examine Report Studio
Studio Interface with templates
Types and formats of reports
Explorer Bar/Properties Pane and Variables
Examine the Report Specification
Layout Components/Query Components
Query Model/Tabular Sql

  Formal shoe , Casual shoe, Party shoe , Online purchase shoe

Outsourcing to India or Asia

We help our clients on their behalf by creating facilities or by identifying CROs in India for statistical, SAS programming, and data management support. We help in recruiting and imparting training in biostatistics and SAS programming of efficacy and safety summary tables, listings, and figures.
Corporate Training

Updated News

Congratulation Abhishek Dutta for scoring 100% in SAS certification

IISASTR aimed at providing world-class Training in the area of Research Analytics (courses offered both regular and Distance), Covering domains such as:

* SAS®/Clinical
* SAS®/Finance
* SAS®/Banking
* SAS®/Advanced Analytics
* SPSS®/Market Research
* Excel/Analytics
* Minitab

IISASTR was proud to train The Royal Bank of Scotland N.V. (RBS) for SAS training.

New course : SAS Enterprise Guide Syllabus
OUR Student Jitendra Singh(M.Tech B.Tech Dual Degree ,IIT Delhi) has Joined Associate Risk Analyst at HSBC Click here for his feedback for SAS training in Delhi
SAS Trainers