Course Content:

1.Introduction to Dataware Housing (DWH) 2. Introduction to Cognos

Introduction to DWH

Characteristics of DWH

OLTP Vs OLAP Databases

Different Approaches of DWH (Kimball Vs Inmon)

Data mart Vs Data Warehouse

Fact Table Vs Dimension Table

Concepts of Schemas (Star schema & Snowflake schema)

3 – Tier Architecture

3.Cognos installation and configuration 4.Query Studio


About Ad-hoc Reports

Types of Report(List, Cross Tab, Chart Reports & Others)

Applying Filters, Prompts & Calculations

Sorting, Grouping, Sections & Aggregate Functions

Run and Manage reports

5.Report Studio 6.Framework Manager

Type of Report Templates

Creating list, Cross Tab, Chart & Other Reports

Report templates, formatting Reports – fonts, style, header, footer, boarder…etc

Generating and Creating Prompt Page

Types of Prompts

Query Calculations & Layout Calculations

Static Filters and Dynamic Filters

Conditional Block

Conditional Formatting

Master Details

Cascading Prompt

HTML Items & Hyperlinks

Set Operators

Setting Burst Options

Drill through

Drill up & Drill down

Setting Variables

Report Functions

Report Validation

Reports Run with Options (separate course not included in this package)

About Framework Manager

Framework Manager, Metadata Modeling

Creating Model & Namespace (Layers)

Importing Metadata

Naming convention for objects in a project

Creating Query Subjects & Query Items

Merging Query Subjects

Creating Relationships & Setting Cardinalities

Creating Parameter Maps & Macros

Creating of Model Filters, Prompts & Calculations

Add Business Rules and Set Governors

Assigning package level security

Publishing Package

7.Analysis Studio