Cognos

Home  >>  Courses  >>  Cognos

Originally a Canadian-based business intelligence and performance management software solutions provider, Cognos was acquired by IBM in 2007 and has since had its software renamed as Cognos Business Intelligence and Financial Performance Management, or Cognos BI and FPM for short.

Cognos software is currently used to help businesses gain a better understanding of their financial performance strengths and weaknesses as well as help set targets and effectively allocate the resources necessary to achieve those goals.

COURSE CONTENTS

1. Introduction to Datawarehousing

  • Introduction to DWH
  • Characteristics of DWH
  • OLTP vs OLAP Databases
  • Different approaches of DWH (Kimbal 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)

2. Introduction to Cognos

  • About Cognos
  • 3-Tier Architecture
  • Features of Cognos 10
  • Cognos vs other OLAP tools
  • Cognos components (Modeling & Reporting)

3. Cognos Connections

  • What is Cognos Connection
  • Examine Cognos Connection UI elements
  • Personalize Cognos Connection
  • Backups – Export of Cognos Content
  • Restore an exported Backup
  • Create and manage portals, shortcuts, report views etc
  • Running the Report Burn
  • Scheduling Reports
  • Various Options in Cognos Connection
  • Cognos Connection Administrator roles

4. Cognos Dashboard Components

  • Business Insight Dashboard
  • Business Insight Advanced Dashboard
  • Dashboard Creation

5. Report Studio

  • Report Studio User Interface
  • Create, 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, Prompts & Variables
  • Query Calculations & Layout Calculations
  • Filters and Dynamic Filters
  • Conditional Block & Conditional Formatting
  • Master Details
  • Page Break
  • Cascading Prompt
  • Operators
  • Setting Burst Options
  • Drill Down – Drill Up – Drill Through
  • Setting Variables
  • Report Functions & Validation1
  • Reports Run with Options
  • Different Types of Reports with Various Functionalities
  • Unions
  • Joins
  • Active Reports & Active Report Controls in 10

6. Query Studio

  • Introduction
  • About Ad-hoc Reports
  • Types of Reports (List, Cross Tab, Chart Reports & Others)
  • Applying Filters, Prompts & Calculations
  • Sorting, Grouping, Sections & Aggregate Functions
  • Run & Manage Reports

7. Analysis Studio

  • Insert, Nest, Replace, Sort & Explore Data
  • Change the measure
  • Drill down for Details
  • Hide Items
  • Insert Calculation
  • Define a Filter

8. Framework Manager

  • Introduction & Basics to Framework Manager
  • User interface, Navigation, Objects
  • Planning the project and data model, FM workflow
  • Naming conventions for objects in a Project
  • Designing project, Creating a Project
  • Importing Metadata, working with data sources
  • Framework Manager, Metadata Modeling
  • Creating Model & Namespace (Layers)
  • Naming convention for objects in a project
  • Verify relationships, resolve traps
  • Working with Dimensions
  • Working with query subjects
  • Creating Query Subjects & Query Items
  • Merging Query Subjects
  • Creating Relationships & Setting Cardinalities
  • Creating Parameter Maps & Macros
  • Creating of Model Filters & Calculations
  • Add Business Rules and Set Governors
  • Assigning package level security
  • Improving performance
  • Publishing Package

9. Transformer Cubes & Work with Cubes

  • Cognos 10 Cube Creation using Transformer
  • Different aspects of Cognos Cube
  • Levels, Categories, Dimension, and Measures in Transformer
  • Publish Transformer Cube into Cognos Connection

Related Tags

cognos training institutes hyderabad
cognos certification training hyderabad
cognos planning training in hyderabad
cognos schools in hyderabad
cognos coaching in hyderabad
cognos course in hyderabad
cognos training in ameerpet