Cognos Online Training

Cognos Online Training Course Content :

Cognos 10 Architecture

User Interfaces

Cognos connection
Query studio, Report studio, Analysis studio, Event studio
Frame work manager

Cognos 10 servers

Content manager
Dispatcher
Content store

Work Flow

Creating Models and Packages
Authoring Reports

Frame Work Manager

Designing a Project

Naming conventions for objects in a project
Connecting to Data sources
Create a data source connection
Importing Meta data
Preparing Meta data for using reports
Verifying relationships
Working with query subjects
Modifying the properties of query items
Format query items
Define a prompt control
Modifying how query items are aggregated
Adding business rules
Creating calculations and Filters
Using prompt values to filter data
Creating a business view of the model
Use short cuts
Create a folder or name space
Create a query item folder
Dimension models
Specify dimension information
Create a star schema grouping
Create the package
Publishing a package
Verify a model and Set governors

Changing the Appearance of the reports

Applying filters
Shorting data
Custom groups
Group identical values
Calculations
Producing reports in various formats

Report Studio

Working in Cognos report Studio
The User interface
Basic report structure
Working with objects
Creating and managing reports
Types of reports
List reports
Cross tab reports
Charts and repeaters
Formatting a report
Swapping rows and columns
Working with data
Filter data
Sort data
Create sections
Adding Prompts
Working with queries
Drilling through Cognos reports
Report studio objects and properties
A work shop on framework manager
Query studio and report studio

Query Studio

Using query studio
Creating a report
Report types
List reports
Grouped List reports
Cross tab reports
Charts

Analysis Studio

Analysis studio
Creating Basic Analysis
Working with Items in the Cross Tab

Event Studio

New Event
Ongoing Event
Ceased Event
No Event

Cognos Transformer

Creating Cubes

Data Warehousing Basic Concepts

Data Warehouse Definition,
Reasons for using, uses
Characteristics of DWH
OLTP Vs OLAP Databases

Architecture of Date Warehouse

Process flow In DWH
Components of Architecture
Source, Integration Layer, Staging Area.

Implementation Methodology

Kimball Methodology
Inmon Methodology

Types of Loads

First Time Load
Full Load
Incremental Load

Data Marts and Star Schema Design

Definition of Star Schema
Data Marts Reasons for Construction
Replacement of Data Mart With Warehouse
Design process
Design of Dimension and Facts
Snow Flake Star Schema
Summary Tables
Slowly Changing Dimensions
Non Additive Facts
Conformed Dimensions
Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP

Drop your query

Most Popular Courses

Achieve your career goal with industry recognised learning paths

What my Client's Say?

It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
The course was really good because it was a practical course.~ M.Radha patel
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria

Cognos Online Training