Online Solvers ( SINCE 2005 ) : Call US: +1 339 368 6489 (USA) | +91 - 880 138 6489 (INDIA)

Pioneer In Online Training.
Online Training By Real Time Industry Experts with Professionalism and Commitment.

Cognos Online Training


Cognos Course Content:
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

Copyright © 2010 Online Solvers. All Rights Reserved