1. INTRODUCTION TO DATAWARE HOUSING (DWH)

· Introduction to DWH

· Characteristics of DWH

· OLTP Vs OLAP Databases

· Different Approaches of DWH (Kimball Vs Inman)

· Data mart Vs Data Warehouse

· Fact Table Vs Dimension Table

· Types Of Facts

· Types Of Dimensions

· ETL

· Staging Area

· Concepts of Schemas (Star schema & Snowflake schema)

· CLP Modeling

· Industry leading ETL and Reporting tools

2. INTRODUCTION TO COGNOs

· About Cogon’s

· 3 – Tier Architecture

· Cogon’s Release (EP series7, Report net , Cogno’s 8.0/8.1/8.2/8.3) and their differences

· Features of Cogon’s 8.4

· Cogno’s Vs other OLAP tools

· Cogno’s components (Modeling & Reporting)

3. COGNOS CONNECTIONS

· Personalize Cognos Connection

· Create and manage portals, shortcuts, report views..etc

· Running the Report Burn

· Scheduling Reports

· Various Options in Cognos Connection

4. REPORT STUDIO

· Report Studio User Interface

· Creating, Save and run reports

· Managing Reports.

· Creating list, Cross Tab etc.

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

· Filters, Parameters and Prompts

· Subtotals and Calculations

· Working with Queries

· Generating and Creating Prompt Page

· Types Of Reports

· Types of Prompts

· Types of Variables

· Query Calculations & Layout Calculations

· Filters and Dynamic Filters

· Conditional Block

· Conditional Formatting

· Master Details

· Cascading Prompt

· Operators

· Setting Burst Options

· Drill through

· Setting Variables

· Report Functions

· Report Validation

· Reports Run with Options

· Different types of Reports with various functionalities

· Unions

· Joins

· Components and there properties.