Cognos 10.X Online Training

ONLINE COGNOS TRAINING

Cognos Course Content:


1.Introduction to Data warehousing (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