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.