Cognos Training

Cognos Online Training

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)
  • Conform Dimension
  • SurraGate Key

Introduction to Cognos

  • About Cognos 8.4
  • 3 – Tier Architecture
  • Features of Cognos 8.4
  • Cognos Report net1.1Vs Cognos8 and other New Versions
  • 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
  • Creating Model & Namespace (Layers)
  • Importing Metadata
  • Creating Data source connection
  • Naming convention for objects in a project
  • Creating Query Subjects & Query Items
  • Creating Relationships & Setting Cardinalities
  • Creating of Model Filters, Prompts & Calculations
  • Add Business Rules and Set Governors
  • Assigning package level security (Not Mandatary)
  • Improving performance
  • Publishing Package
  • Creating IQD’s for Power play Transformer
  • Creating cube by using Transformer
  • Develop the dimensions and Measure dimension
  • Creating Cube and Pubish to content store.

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
  • Page Break
  • Query Calculations & Layout Calculations
  • Layout component reference
  • Generating and Creating Prompt Page
  • Setting Variables
  • Conditional Formatting
  • Types of Prompts
  • Cascading Prompt ,Generate Prompt
  • Static choice
  • Token Prompt
  • Drill through
  • Master Details
  • Conditional Block
  • HTML Items & Hyperlinks
  • Bookmark Report
  • Setting Burst Options
  • Schedulining of Reports
  • Drill up & Drill down,Tree prompt
  • Render Variable
  • Dynamic column Sorting
  • Reports Run with Options (separate course not included inthis package)
  • Around 5 Realtime reports

Analysis Studio

  • Give the Detail Description of the This Studio and Explain
  • the Some of Reports
  • Event Studio

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message