COGNOS BI 10.2 – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us


IBM Cognos BI Training in Bangalore

Cognos 10.2 Training by Industry Experts having 10+ yrs exp.

Cognos Training Duration : 10 weekends 

Cognos Course Syllabus

Data warehousing Basic Concepts

  1. Introduction to data warehousing
  2. Difference Between OLTP Vs OLAP
  3. What dimensional modeling ?
  4. What is dimension ?
  5. What is fact ?
  6. Types of schemas in data warehousing
  • Star Schema
  • Snow flake Schema
  • Hybrid Schema

7.  What is slowly changing dimension ? Types of Slowly Changing dimensions ?

  • SCD I
  • SCD II

8. What is confirmed dimensions ?

9. What is fact less fact table ? and types of Facts

Framework Manager

1. Overview of IBM Cognos BI

  • Describe IBM Cognos 10 BI Components
  • Describe IBM Cognos 10 BI Architecture at a high level
  • Define IBM Cognos 10 Groups and Roles

2. Gather requirements

  • Examine key modeling recommendations
  • Define reporting requirements
  • Explore data sources to identify data access strategies

3. Create a baseline project

  • Examine the IBM Cognos 10 and Framework Manager work flow processes
  • Define a project and its structure
  • Describe the Framework Manager Environment
  • Create a baseline project
  • Enhance the model with additional metadata

4. Prepare reusable metadata

  • Verify the relationships and query item properties

5. Identify Reporting Issues

  • Describe multi-fact queries and full outer joins are appropriate
  • Describe how IBM Cognos 10 uses cardinality
  • Identify reporting traps
  • Use tools to analyze the model

6. Virtual Star Schemas

  • Identify the advantages of modeling metadata as a star schema
  • Model in layers
  • Create aliases to avoid ambiguous joins
  • Merge the query subjects to create as view behavior

7. Consolidate metadata

  • Create virtual facts to simplify writing queries
  • Create a virtual dimensions to resolve fact-to-fact joins
  • Create a consolidated modeling layer for presentation purposes
  • Consolidate snowflake dimensions with model query subjects
  • Simplify facts by hiding unnecessary codes

8. Calculations & Filters

  • Use calculations to create commonly needed query items for authors
  • Use static filters to reduce the data returned
  • Use macros and parameters in calculations and filters to dynamically control the data returned

9. Implement a time dimension

  • Make time based queries simple to author by implementing a time dimension
  • Resolve confusion caused by multiple relationships between a time dimension and another table

10. Specify Determinants

  • Use determinants to specify multiple levels of granularity and prevent double counting

11. Create the presentation view

  • Identify the dimensions associated with a fact table
  • Identify Conformed Vs non conformed dimensions
  • Create a star schema groupings to provide authors with logical groupings of query subjects
  • Rapidly create a model using the Model Design Accelerator

Report Studio

  1. Introduction to reporting application
  • Examine report studio and its interface
  • Explore report types
  • Create a simple , sorted, and formatted report
  • Explore how data items are added to queries

2. Create List reports

  • Format, group, and sort list reports
  • Describe options for aggregating data
  • Create a multi fact query
  • Create a report with repeated data

3. Focus reports Using Filters

  • Create filters to narrow the focus of reports
  • Examine detail and summary filters
  • Determine when to apply filters on aggregate data

4. Create crosstab reports

  • Format and sort crosstab reports
  • Convert a list to a crosstab
  • Create a complex crosstabs using drag and drop functionality
  • Create crosstabs using unrelated data items

5. Present data graphically

  • Create charts containing peer and nested columns
  • Present data using new chart type options
  • Add context to charts
  • Create and reuse custom chart palettes
  • Present key data in a single dashboard report

6. Focuses reports using prompts

  • Identify various prompt types
  • Use parameters and prompts to focus data
  • Search for prompt types
  • Customize prompts to facilitate users choices
  • Navigate between pages
  • Display users prompt selections in the report
  • Implement casting prompts

7. Extend reports using Calculations

  • Create calculations based on data in the data source
  • Add runtime information to the reports
  • Create expressions  using functions
  • Discusses report templates
  • Add pages to a report
  • Choose options to handle reports with no available data

8. Drill through from one report to another

  • Let users navigate from a specific report to a target report
  • Pass parameter values to filter the data in drill through targets

9. Implement Master Detail relationship 

Analysis Studio

  1. Analysis studio fundaments
  • Define the fundamental terms  of analysis studio
  • Explain how to insert objects
  • Define & create sets
  • Identify the work area, overview area, and properties pane

2. Tools for investigation in analysis studio

  • Employ drilling down and up to different levels of detail
  • Apply changes to rows, columns, and measures in the analysis
  • Explain how to change the display of data
  • Use charts to display data graphically

3. Nest data in crosstabs in analysis studio

  • Apply depth to rows and columns by nesting data
  • Recognize drill behavior in nested rows and columns
  • Demonstrate how to swap nested levels

4. Build advanced crosstabs in analysis studio

  • Demonstrate how to view a complete level of data
  • Design a crosstab without retrieving data
  • Compare multiple measures
  • Apply stacked sets to the crosstab
  • Construct an asymmetrical crosstab
  • Compose a custom sort

5. Focus with filters in analysis studio

  • Apply filters using expressions
  • Apply filters using context area
  • Create top and bottom lists
  • Use several techniques to remove rows and columns

6. Extend the analysis

  • Apply summary calculations
  • Apply item based calculations
  • Practice ranking items
  • Demonstrate how to customize the report display

Query Studio

  1. Introduction to query studio
  • Examine query studio
  • Open adhoc reports
  • Add data to adhoc reports
  • Examine report types
  • Examine charting

2. Create reports in query studio

  • Create list, grouped list, and crosstab reports
  • Use prompts to specify filter criteria
  • Create custom groups
  • Format data
  • Calculate and sort report data

3. Explore and modify reports in query studio

  • Run a report in query studio
  • Explore run options
  • Render reports in HTML, PDF, and CSV format
  • Format report elements
  • Create report views
  • View report outputs 

Business Insight

  1. Explore, Navigate, and create dashboards
  • Business Scenario
  • What is business insight
  • Examine Business Insight interface
  • Dashboard content
  • Define widgets
  • Add report content to dashboard
  • Align and rearrange widgets in the dashboard
  • Add tools to dashboard 

Business Insight Advanced

  1. Examine Business Insight Advanced
  • Business Scenario
  • What is business insight advanced
  • Explore the user interface
  • Design the report layout
  • View your data
  • Define the report layout

2. Create a report

  • Business Scenario
  • Goal of reporting
  • List Report Example
  • Crosstab Report Format
  • Crosstab Example
  • Chart Report format
  • Basic Chart Types
  • Pie Chart Example
  • Column Chart Example
  • Scatter chart Example
  • Financial Reports
  • Combination Reports
  • Same data with multiple business cases
  • Create a calculation
  • Calculation Example 


  1. Introduction to transformer
  2. Purpose of transformer
  3. Difference b/w  transformer model Vs Framework Manager Model
  4. Explore the transformer interface
  5. How to refresh the cube
  6. How to publish the cube in cognos connection

• Active Reports

• Introduction to Dash boarding

• Deck and Data Deck

• Static Prompts

• Dynamic Prompts

Our Courses