Cognos Training Certification

What is Business Intelligence Why BI is important and where it can be used
Components of BI
Business Intelligence Roadmap

What are Data warehouse and why do we need it Data warehouse architecture and its components
Define star schema – fact and dimensions
Understand OLTP and OLAP Systems

Introduce Cognos 10.1 BI Examine the Various studios in Cognos 10.1 BI
Identify the various data sources within the studios
Highlight key capabilities of Cognos 10.1 BI
Understand Cognos multi layered architecture

Create and modify a data source Create database backups
Understand roles users and groups
Specify permission settings

What is Cognos connection Examine Cognos connection UI elements – generate a URL, Login, Logoff
Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent and the Page Properties
Navigation – Public and Private Folder
Open reports with the report name, Go to the links, Run reports from a view
Run Reports – Prompt Pages, Printing a report and the Open in excel
View the run history of an report and the historical reports
Closing and generating quick links to reports – my folder
Shortcut and browser bookmark
Personalize Cognos connection
Backups – Export of Cognos
Content store or select items for backups
Restore an exported backup
Make and customize a page and share a single page with multiple users

Introduction to framework manager Framework manager basics
User interface, navigation, objects
Planning the project and the data model, framework manager workflow
Naming conventions for objects in a project
Designing project
Create project
Importing metadata from one and more sources
Exporting metadata
Data sources
Working with data source connections
Create and modify data sources
Improve performance by setting query processing type
Preparing relational metadata for use in reports
Verifying relationships
Working with dimensions
Working with query
Subjects – data, model and the stored procedure query subject
Working with the query items- set usage and the aggregate property
Making metadata available to report authors
Verify model
Set governors
Improving performance
Create and modify package
Controlling access to metadata
Explore package publish package
Guideline for modelling metadata
Best practices – presentation and database layers
Merge metadata
Perform calculations and filer

Introduction to query studio Create reports (List, Grouped List, Crosstab, Charts)
Changing the appearance of reports (Format)
Sorting and grouping
Filters and prompts
Subtotals and calculations
Run and manage reports
Drill through reports

Introduction to Analysis Studio Creating a basic analysis
Working with data in cross tab
Exploring data
Limiting data
Calculating data
Sharing data

Introduction to report studio Report studio user interface
Creating, save and run reports
Report templates
Managing reports
Types of reports
List reports
Cross tab reports charts
Formatting a report
Report layout guidelines
Fonts, styles, header, footer and orders
Insert objects
Swap columns and rows
Working with data
Filters, parameters and prompts
Sorting and grouping
Subtotals and calculations
Working with queries
Working with reports
Managing changes in the package
Conditional formatting
Drill-through reports
Drill-up / drill-down reports
Master-detail reports
Scheduling reports

Each and every class is recorded so if you missed any class you can review the recordings and clarify any doubts with the trainer in next class.

Yes, we don’t assure 100% placement assistance. We are tied up with some corporate companies so when they have a requirement we send your profiles to them.

Yes, we provide demo before starting any training in which you can clear all your doubts before starting training.

Our trainers are real time experts who are presently working on particular platform on which they are providing training.

You can call our customer care 24/7

Max of the students get satisfied with our training, if you are not then we provide a specialised training in return.