Cognos Training

IBM Cognos Syllabus

 

Data Warehouse Introduction

  • Basic Concepts of data warehousing
  • Data warehouse architectures
  • Some characteristics of data warehouse data
  • The reconciled data layer
  • Data transformation

Overview of Business Intelligence

  • What is Business Intelligence
  • Why is BI important and where can we use it
  • Components of BI
  • 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 Systems

Overview of Cognos 10.1 BI and Architecture

  • Introduce Cognos 10.1 BI
  • Examine the different studios in Cognos 10.1 BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos 10.1 BI
  • Understand Cognos multi layered architecture

Cognos 10.1 BI Administration

  • Create and modify a data source
  • Create database backups
  • Understand roles users and groups
  • Specify permission settings

Cognos 10.1 Connection

  • What is Cognos connection
  • Examine Cognos connection UI elements – create a URL, Login, Logoff
  • Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent and Page Properties
  • Navigation – Public and Private Folder
  • Open reports with report name, Go to links, Run reports from a view
  • Run Reports – Prompt Pages, Printing a report and Open in excel
  • View the run history of a report and historical reports
  • Closing and creating quick links to reports – my folder
  • Shortcut and browser bookmark
  • 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.1 Framework Manager (metadata modelling)

  • 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 metadata 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 and modify package
  • Controlling access to metadata
  • Explore package publish package
  • Guideline for modelling metadata
  • Best practices – presentation and database layers
  • Merge metadata
  • Perform calculations and filer

Cognos 10.1 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
  • Drill through reports

Cognos 10.1 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.1 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
  • Formatting a report
  • Report layout guidelines
  • Fonts, styles, header, footer and orders
  • Insert objects
  • Swap columns and rows
  • 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
Quick Enroll