IBM Cognos BI Online Training


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

Online Training Courses Online Training Courses