IBM Cognos 10 Business Intelligence Training

IBM Cognos 10 Business Intelligence Training

What’s new Cognos 10 BI

  • Overview of Business
  • Intelligence
  • What is Business Intelligence
  • Why is B1 Important and where can we use it
  • Components of B1
  • Business Intelligence Roadmap

Overview of Data Warehousing

  • What is Data Warehouse,
  • Why do we need it
  • Data Warehouse Architecture and its components
  • Define Star Schema – Fact and Dimensions
  • Understand OLTP and OLAP System

Overview of Cognos 10 BI and Architecture

  • Introduce Cognos 10 B1
  • What’s new Cognos 10 B1
  • Examine the different studios in Cognos 10 B1
  • Identify the different data sources within the studios
  • Highlight key cap abilities of Cognos 10 B1
  • Understand Cognos Multi Layered architecture

Cognos 10 Installations and Configuration

  • Setting up the Environment
  • Configuring Cognos 10
  • Setting up Samples in Cognos 10
  • Uninstalling Cognos 10 Entry Properties: General Properties, Permissions, Report Query, Analysis, Job, Agent and
  • Personalize Cognos Connection
  • Backups- Export of Cognos, Content.
  • Store or select items for Backups
  • Restore an exported Backup
  • Create and Customize a Page and share a single page with Multiple Users

Cognos 10 BI Administration

  • Introduction to Report Studio Report Studio User Interface
  • Create and Modify a Data Source
  • Creating, Save and Run Reports
  • Create Database backups
  • Report Templates
  • Understand Roles, Users and Groups
  • Managing Reports
  • Specify Permission Settings
  • Types of Reports

Cognos 10 Connection

  • Active Reports List Reports
  • Administration
  • Fonts, Styles, Header, Footer and Borders
  • What is Cognos Connection
  • Insert objects
  • Examine Cognos Connection UI elements , Create a URL, Login, Logoff
  • Swap Columns and Rows Working with Data
  • Filters, Parameters and Prompts

Cognos 10 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 10 Analysis Studio

  • Introduction to Analysis Studio
  • Creating a Basic Analysis
  • Working with data in Crosstab Exploring Data
  • Limiting Data
  • Calculating Data
  • Sharing Data

Cognos 10 Report Studio

  • Introduction to Report Studio Report Studio User Interface
  • Creating, Save and Run Reports
  • Report Templates
  • Managing Reports
  • Types of Reports
  • Active Reports List Reports
  • Fonts, Styles, Header, Footer and Borders
  • Insert objects
  • Swap Columns and Rows Working with Data
  • Filters, Parameters and Prompts
  • Uninstalling Cognos 10 Entry Properties: General Properties, Permissions, Report Query, Analysis, Job, Agent and
  • Personalize Cognos Connection
  • Backups- Export of Cognos, Content.
  • Store or select items for Backups
  • Restore an exported Backup
  • Create and Customize a Page and share a single page with Multiple Users
  • 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

Cognos 10 Framework Manager

Introduction to Framework Manager

Framework Manager Basics

User Interface, Navigation, Objects

Planning the project and data model.

Framework Manager Workflow

Naming Conventions for objects in a project Designing Project

Create project

  • Importing Metadata from one and more sources
  • Exporting Metadata Data Sources
  • Working with Data Source Connections
  • Create and Modify Data Sources
  • Improve Performance by setting Query Processing Type
  • Preparing Relational Meta data for use in Reports
  • Verifying Relationships
  • Working with Dimensions
  • Working with Query Subjects- Data, Model and Stored Procedure Query Subject
  • Working with Query Items- Set Usage and Aggregate Property
  • 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
  • Best Practices, Presentation and Database layers
  • Merge Metadata
  • Perform Calculations and Filters

IBM COGNOS DASHBOARDS
IBM COGNOS PORTAL PAGES
IBM COGNOS WORKSPACE
IBM COGNOS WORKSPACE ADVANCE
Note: All above topics will cover in real time oriented with in real time cognos server


Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message