BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Cognos Online Training

Cognos Online Training

sub-banner960x200

COGNOS 10.2 Online Training Course Topics

Course Duration: 4-5 Weeks

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

INTRODUCTION TO COGNOS

  •     About Cognos 8.4
  •     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)
  •      Different cognos services

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

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

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

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

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

EVENT STUDIO

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