Cognos

Introduction to Data Warehousing
  • Characteristics OF DWH
  • Architecture of DWH
  • OLTP v/s OLAP
  • Concepts OF Data Marts
  • Concepts OF Metadata
  • Approaches to Data Warehousing
  • Dimensional Modeling
  • Facts & Dimensions
  • Schemas (Star & Snowflake)
Overview of Cognos 8 BI & Architecture
  • Introduce Cognos 8 BI
  • Examine the different studios in Cognos 8 BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos 8 BI
  • Components used by Cognos 8
  • Server Components
  • Modeling Components
  • Installing Cognos 8
  • Setting up the Environment (on windows OS) Configuring Cognos 8
  • Setting up Samples
  • Architecture
  • Multi-tired architecture
  • Communications
  • Workflow
  • Security
Cognos 8 Framework Manager (Metadata Modeling)
  • 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
  • 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
  • Publish Package
  • Guideline for Modeling Metadata
  • Scenarios
  • New Objects - Regular Dimensions, Measure Dimensions, Scope Relationship
  • Dimensional Modeling of Relational Data Sources
  • SQL Generated by Cognos 8
  • Understanding Dimensional Queries
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
  • Introduction to Query Studio
  • Create Reports (List, Grouped List, Crosstab, Charts)
  • Cognos 8 Query Studio Changing the Appearance of Reports (Format)
  • Sorting and Grouping
  • Filters and Prompts
  • Subtotals and Calculations
  • Run and Manage Reports
  • Drill Through reports
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
Cognos 8 Report Studio
  • Introduction to Report Studio
  • Report Studio User Interface
  • Creating, Save and Run Reports
  • Report Templates
  • Managing Reports
  • Types of Reports
  • List Reports
  • Crosstab Reports
  • Charts
  • Maps
  • Formatting a Report
  • Report Layout Guidelines
  • Fonts, Styles, Header, Footer and Borders
  • Insert objects
  • Apply Table Styles
  • Swap Columns and Rows
  • Create and Modify Classes
  • Working with Data
  • Filters, Parameters and Prompts
  • Sorting and Grouping
  • Subtotals and Calculations
  • Working with Queries
  • Working with Reports
  • Managing changes in the Package
  • Conditional Formatting
  • Drill-through Reports
  • Drill-up/Drill-down Reports
  • Master-Detail Reports
  • Scheduling Reports
SR International Solutions also provide best training in SAP Business Objects, Informatica, .NET, Sharepoint, TIBCO.