Geoinsys map

View Larger Map

Course contents updated on July 2010

Data Warehouse Concepts

Introduction of Data Warehouse

Need arise of DWH

OLTP V/S DWH

OLTP V/s OLAP

Data Warehouse /Data Marts Architecture

Staging/without Staging

Dimensions (Simple and Confirm)

Fact (Simple, fact less, coverage, confirm)

Warehouse Implementation Methods

STAR SCHEMA

SNOW FLAKE SCHEMA

Difference between STAR and SNOW FLAKE Schema.

Other terminologies Cleansing, Purging etc.

Database Modeling Tool (Erwin)

Introduction of Erwin

Designing Methods

Logical Designing

Physical Designing

Introduction of ER-Modeling

Introduction of Dimension Modeling

Difference between ER-Modeling and Dimension Modeling

Implementation of ER-Model

Implementation of Dimension Model

Forward Engineering and Reverse Engineering

Introduction of various Database Components

E T L Informatica Power Center 8.6

1. Power Center Components

a) Designer

b) Repository Manager

c) Workflow Manager

d) Workflow Monitor

2. Informatica Concepts and Overview

a) Informatica Architecture.

b) Source Qualifier

c) Target Qualifier

d) Transformations

e) Mappings

f) Mapplets

g) Sessions

h) Tasks

3. Sources

a) Working with relational Sources

b) Working with Flat Files

4. Targets

a) Working with Relational Targets

b) Working with Flat file Targets

5. Transformations

a) Expression

b) Lookup

c) Sequence Generator

d) Filter

e) Joiner

f) Sorter

g)Stored Procedural

h) Router

i) Aggregator

j) Active and Passive Transformations

k) Update Strategy

l) Data Concatenation

m) Debugging Mappings

6. Mappings & Mapplets

a) Mapping Variables & Parameters

b) Creating Cubes & Dimensions

c) Working with Mapping Wizards

7. Workflow Manger

a) Server Architecture

b) Workflows, Worklets & Sessions

c) Tasks, Assignments, Events, Command etc,

8. Performance Tuning

a) Informatica Tuning (Source, target, mapping & Session)

Including Parameter file ,Unix scripts to run ,Scheduling ,Pre session and Post session.

9. Project - Case Study

Cognos 8.4

Overview of Business Intelligence

What is Business Intelligence
Why is BI Important and where can we use it
Components of BI
Business Intelligence Roadmap

Overview of Data Warehousing
What is Data Warehouse, Why do we need it
Data Warehouse Architecture and its components
Define Star Schema - Fact and Dimensions
Understand OLTP and OLAP Systems


Overview of Cognos 8.4 BI and Architecture
Introduce Cognos 8 BI
Examine the different studios in Cognos 8 BI
Identify the different data sources within the studios
Highlight key capabilities of Cognos 8 BI
Understand Cognos Multi Layered architecture

Cognos 8.4 Installations and Configuration

Installing Cognos 8.4
Install Database (MS SQL)
Install Framework Manager
Install Cognos BI Application
Setting up the Environment
Configuring Cognos 8.4
Setting up Samples in Cognos 8.4
Uninstalling Cognos 8.4

Cognos 8.4 BI Administration

Create and Modify a Data Source
Create Database backups
Understand Roles, Users and Groups
Specify Permission Settings

Cognos 8.4 Framework Manager (Metadata Modeling)
Introduction to Framework Manager
Framework Manager Basics
User Interface, Navigation, Objects
Planning the project and data model. Framework Manager Workflow
Naming Conventions for objects in a project
Designing Project
Create project
Importing Metadata from one and more sources
Exporting Metadata
Data Sources
Working with Data Source Connections
Create and Modify Data Sources
Improve Performance by setting Query Processing Type
Preparing Relational Metadata for use in Reports
Verifying Relationships
Working with Dimensions
Working with Query Subjects- Data, Model and Stored Procedure Query Subject
Working with Query Items- Set Usage and Aggregate Property
Making Metadata Available to Report Authors
Verify Model
Set Governors
Improving Performance
Create or Modify Package
Controlling access to Metadata
Explore Package
Publish Package
Guideline for Modeling Metadata
Best Practices – Presentation and Database layers
Merge Metadata
Perform Calculations and Filters

Cognos 8.4 Connection

What is Cognos Connection
Examine Cognos Connection UI elements – Create a URL, Login, Logoff
Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
Navigation- Public and Private Folder
Open reports with Report Name, Go to Links, Run Reports from a View
Run Reports- Prompt Pages, Printing a report and Open in Excel
View the run history of a report and Historical Reports
Closing and Creating Quick links to Reports – My Folder Shortcut and Browser Bookmark
Personalize Cognos Connection
Backups- Export of Cognos, Content Store or select items for Backups
Restore an exported Backup
Create and Customize a Page and share a single page with Multiple Users

Cognos 8.4 Query Studio
Introduction to Query Studio
Create Reports (List, Grouped List, Crosstab, Charts)
Changing the Appearance of Reports (Format)
Sorting and Grouping
Filters and Prompts
Subtotals and Calculations
Run and Manage Reports
Drill Through reports

Cognos 8.4 Analysis Studio
Introduction to Analysis Studio
Creating a Basic Analysis
Working with data in Crosstab
Exploring Data
Limiting Data
Calculating Data
Sharing Data


Cognos 8.4 Report Studio
Introduction to Report Studio
Report Studio User Interface
Creating, Save and Run Reports
Report Templates
Managing Reports
Types of Reports
List Reports
Crosstab Reports
Charts
Formatting a Report
Report Layout Guidelines
Fonts, Styles, Header, Footer and Borders
Insert objects
Swap Columns and Rows
Working with Data
Filters, Parameters and Prompts
Sorting and Grouping
Subtotals and Calculations
Working with Queries
Working with Reports
Managing changes in the Package
Conditional Formatting
Drill-through Reports
Drill-up/Drill-down Reports
Master-Detail Reports
Scheduling Reports

Cognos 8.4 Event Studio
Introduction to Event Studio
Studio User Interface
Creating, Save and Run Agents

Create agents

Different tasks

Task Execution rules

Cognos 8.4 Metric Studio
Introduction to Report Studio

Cognos 8 Power Play Transformer (Power Cube Modeling)

Fundamentals
What is Cognos Transformer
Understanding Power Play Data Sources
Starting and Navigating Transformer
Importing your source Data
Creating your Power Cube

Building the Time Dimension
Create the Time Dimension Manually
Building a Transformer Model
Performance Considerations
Build Model with AutoDesign
Modify Property sheets for Dimensions, Levels and Categories
Build Model without AutoDesign
Create New Dimensions from Source Data
Creating Exception Dimensions from Source Data
Specify a Level Label

SAS

About the SAS

Steps of SAS

MODULE 1) BASE SAS:

a) SAS system options

b) SAS statements

c) SAS data set options

d) SAS functions

e) SAS date formats

f)SAS ODS formats

g) SAS input statements options and methods

h) SAS infile statements options and usage

i) BASE SAS Procedures and SAS/STAT procedures.

MODULE 2) SAS / MACRO

MODULE 3) SAS /SQL

MODULE 4) SAS /ACCESS

MODULE 5) SAS/ODS.

MODULE 6) SAS/GRAPH