Overview of Data warehousing Concepts
ETL Concepts
Business Intelligence Concepts
Reporting Concepts
Dimensional Modeling
SQL Joins
Introduction to Cognos
Cognos 10.2 BI Architecture

Cognos 10.2 BI Installation Procedure
Cognos 10.2 BI Configuration

Introduction to Framework Manager

Create a project
Create a Data Source
Create New Query Subject
Create New Query Item
Create Calculations
Create Filters
Create Relationships
Create Business View
Create Model based Query
Merging Query Subjects
Shortcuts
Create Packages

Determinants
Regular Dimension
Measure Dimension
Scope

Macros
Session Parameters
Parameter Maps
Prompts

Object Security
Query Subject Security
Package Security
Data Security

Log on to Cognos Connection
Models and Packages
Create a URL
Create a shortcut
Properties of an Entry
Search for an Entry
Bookmark an Entry
Personalize the portal
Creating folders
Scheduling reports and jobs
Job Monitoring
Cognos Access Permissions Overview
Security Set up to Objects

Query Studio Overview
The basic functionality
Creating a new report
Data icons

Modifying and formatting your report
Grouping data; collapsing/expanding
your report; and sections
Creating a custom group
Page breaks; Page size
Sorting data
Drill up and drill down
Navigate to a new report
Best practices

Data selection
Combining filters
Data calculations

Crosstab reports
Charts

Report Studio Overview
Report Studio capabilities and basics
Report types and templates
Running reports

Defining the toolbars
Viewing a report
Explorer bars
Report structure
Adding report objects
Displaying data
Creating queries

Using lists and crosstabs
Sorting
Grouping
Report sections
Summarizing, Aggregation

Report functions
Stand alone, embedded
Detail and summary filters
Prompt objects
Prompt pages

Styling
Free standing objects
Tables
Alignment, spacing, object size
Headers and Footers
Page Sets

Masterb- Detail Reports
Conditional Blocks
Conditional Formatting Using Variables
Component Lay out Reference funtionality
Report blocks
Using tables
Aligning objects within containers
Object types; unlocking an object
Adding report pages
Hyperlinks
Report layouts/displaying standard report
information
Reusing objects
List page headers and overall header
Page sets

Drill-through
Distribute reports via E-Mail (Bursting)

Charts
Maps
Repeaters

Analysis Studio capabilities
Analysis Studio basics

Analysis Studio user interface
Searching for your data & moving your selections to the work area
Inserting data into the work area
Defining crosstabs with nested, stacked a other sets
Modifying your crosstab

Hiding / excluding a row or column
Specifying top or bottom values of a set
Suppressing zero totals and null values
Custom sets
Using context (in the overview area)
User-defined filters

Running a report with different output options
Sorting a report
Showing values as percentages
Report options
Drill down and drill up
Drill –through
Importing an Analysis Studio report into Report Studio
Charts

Adding tasks
Executing rules
Scheduling the agent

Work Space Interface
Work Space Tool Box Objects
Dashboard Creation

Doubts Clarification

Add and manage a data source
Distribute data and create a distribution list and contacts
Deploy IBM Cognos BI content
Maintain the IBM Cognos BI content store
Customize the appearance of IBM Cognos BI
Manage packages in IBM Cognos Connection
Create roles
Add members and define access permissions
Set capabilities
Create folders
Define access to entries
Create an export
Create an import

Mindmajix offers advanced Cognos interview questions and answers along with Cognos resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.