LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655
facebook twitter linkedin Google +

Cognos

Cognos Online Training

Cognos (Cognos Incorporated) was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM)software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 135 countries.[1]

Originally Quasar Systems Limited, it adopted the Cognos name in 1982. Cognos is a fragment scissored off the Latin word “cognosco,” which means “knowledge from personal experience”.[2] January 31, 2008, Cognos was officially acquired by IBM.[3] The Cognos name continues to be applied to IBM’s line of business intelligence and performance management products.

Course : Cognos 

Cognos Online training courses Content:

Introduction To Dataware Housing

  • Introduction to Dataware Housing
  • Characteristics of Dataware Housing
  • 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

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

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

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