Cognos Course Curriculum

 Cognos Course Curriculum

    Overview of Cognos 8 BI

• Introduce Cognos 8 BI

• Describe IBM Cognos 8 BI components

• Describe IBM Cognos 8 architecture at a high level

    Cognos 8 Installation and Configuration

• Components used by Cognos 8

• Server Components

• Modeling Components

• Installing Cognos 8

• Setting up the Environment

• Configuring Cognos 8

• Setting up Samples

• Uninstalling Cognos 8

    Cognos 8 BI Admin

• Configuration of third party security at Cognos level

• Define IBM Cognos 8 groups and roles

• Assign the Roles to Users or Groups

    Cognos 8 Framework Manager

• Introduction to Framework Manager

• Framework Manager Basics

• User Interface, Navigation, Objects

• Planning the project and data model

• Naming Conventions for objects in a project

• Designing Project

• Create project

• Importing Metadata

• Exporting Metadata

• Multi-user Modeling

• Segmenting and Linking

• Create Model Documentation

• 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

• Working with Query Items

• Supporting Multilingual Metadata

• Adding Business Rules

• Organizing the Model

• Making Metadata Available to Report Authors

• Verify Model

• Set Governors

• Improving Performance

• Create or Modify Package

• Controlling access to Metadata

• Explore Package

• Publish Package

• Guideline for Modeling Metadata

• Scenarios

• New Objects - Determinants, Regular Dimensions, Measure Dimensions, Scope Relationship-Dimensional Modeling of Relational Data Sources

     Cognos 8 Query Studio

• 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

    Cognos 8 Report Studio

• Introduction to Report Studio

• Report Studio User Interface

• Creating, Save and Run Reports

• Report Templates

• Managing Reports

• Formatting a Report

• Report Layout Guidelines

• Fonts, Styles, Header, Footer and Borders

• Insert objects

• Apply Table Styles

• Swap Columns and Rows

• Create Additional Advanced Reports

• create a report that displays summarized data before

• detailed data

• highlight alternate rows in a list report

• use single data items to summarize report information

• save reports to server file system

• Drill-through Reports

• Drill-up/Drill-down Reports

• Master-Detail Reports

• Scheduling Reports

• Working with Data

• Filters, Parameters and Prompts

• Sorting and Grouping

• Subtotals and Calculations

• Working with Queries

• Create Query Models

• build query models and then connect them to the report layout

• add filters and prompts to a report using the query model

• edit an SQL statement to author custom queries

• Create Advanced Dynamic Reports

• filter reports on session parameter values

• navigate a briefing book using a table of contents

• create dynamic headers and title that reflect report data

• let users navigate to specific locations in reports

• create a customer invoice report

    Cognos Power Play Transformer

• Transformer Fundamentals

• Discuss the basics of OLAP analysis

• Review Transformer capabilities and its role in IBM Cognos 8 BI

• Discuss Transformer components

• Define categories and members

• Transformer Development Process

• Data Sources in Transformer

• Building a Model

• Define Dimensions, Levels and Measures

• Time Dimensions, Relative Time

    Types of Security

• Data Level

• Objective Level

• Package level

• SQL Generated by Cognos 8

• Understanding Dimensional Queries

• Resolving Ambiguously Identified Dimensions and Facts

• Resolving Queries that should not have been split

• Resolving Queries that are split in the wrong place

    Cognos 8 Connection

• Examine Cognos Connection

• Run and view reports

• View the run history of a report

• Organize content with folders and shortcuts

• Customize report outputs by using report views

• Schedule single and multiple reports

• Personalize Cognos Connection

• Creation of Portal pages

• Design Effective Prompts

• control report displays using prompts

• specify conditional formatting values using prompts

• create a report that formats based on prompts selection

• create a sorted and filtered report based on prompt selection

• Currency Conversion

• Create Power Cube

• Advanced Dimensional Modeling

• Applying Security

• Drill Through

• Optimizing Power Cubes

• Deployment of Power Cubes to the Cognos Connection

    Cognos 8 Analysis Studio

• Introduction to Analysis Studio

• Creating a Basic Analysis

• Working with data in Crosstab

• Exploring Data

• Limiting Data

• Calculating Data

• Sharing Data