Cognos

Cognos 8.4 Course Content : Course Duration – 30hrs

  1. 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
    • Concepts of Schemas (Star schema & Snowflake schema)
    • Industry leading ETL and Reporting tools
  2. Introduction to Cognos

    • About Cognos 8.4
    • 3 – Tier Architecture
    • Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)
    • Features of Cognos 8.4
    • Cognos Vs other OLAP tools
    • Cognos components (Modeling & Reporting)
    • Different cognos services
  3. Cognos Connections

    • Personalize cognos connection
    • Create and manage portals, shortcuts, report views.etc
    • Working with Cognos configuration, content Store
    • How to Connect to different Data Sources
    • Security setup
    • Import and Export of Package (Deployment)
    • Running the Report Burn
    • Scheduling Reports
  4. 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
  5. 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
  6. Report Studio

    • Type of Report Templates
    • Creating list, Cross Tab, Chart, repeater, Maps & 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)
  7. Analysis Studio

    • Insert Data
    • Change the number of Visible Items
    • 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
  8. Event Studio

    • Creating Agents
    • Adding Event conditions
    • Task and Task execution rules
    • Scheduling Agents