Cognos

  • 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
  • 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 PowerPlay 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 PowerCubes
  • Deployment of PowerCubes 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

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.