ETL Course

Cognos Course Detail

COGNOS Course Content @ Learning Hub

INTRODUCTION TO DATAWARE HOUSING (DWH)

  • 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
  • Types Of Facts
  • Types Of Dimensions
  • ETL
  • Staging Area
  • Concepts of Schemas (Star schema & Snowflake schema)
  • CLP Modeling
  • Industry leading ETL and Reporting tools

    • INTRODUCTION TO COGNOS

  • About Cognos
  • 3 – Tier Architecture
  • Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences
  • Features of Cognos 8.4
  • Cognos Vs other OLAP tools
  • Cognos components (Modeling & Reporting)

    • COGNOS CONNECTIONS

    • Personalize Cognos Connection
  • Create and manage portals, shortcuts, report views..etc
  • Running the Report Burn
  • Scheduling Reports
  • Various Options in Cognos Connection

    • 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.

    • QUERY STUDIO

  • Introduction
  • 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

    • ANALYSIS STUDIO

  • Insert Data
  • Nest Data
  • Replace Data
  • Sort Data
  • Explore Data
  • Change the measure
  • Drill down for Details
  • Hide Items
  • Insert a calculation
  • Save a custom set
  • Define a filter
  • Compare sets of data
  • Using Dynamic Context

    • FRAMEWORK MANAGER

  • About Framework Manager
  • Framework Manager, Metadata Modeling
  • Creation of Interface and Usage
  • 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
  • Improving performance
  • Publishing Package