COGNOS

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons  for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases

Architecture of Date Warehouse

  • Process flow In DWH
  • Components of Architecture
  • Source, Integration Layer, Staging Area.

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

Data Marts and Star Schema Design

  • Definition of Star Schema
  • Data Marts Reasons for Construction
  • Replacement of Data Mart With Warehouse
  • Design process
  • Design of Dimension and Facts
  • Snow Flake Star Schema
  • Summary Tables
  • Slowly Changing Dimensions
  • Non Additive Facts
  • Conformed Dimensions
  • Types of OLAP ROLAP, DOLAP, HOLAP, MOLAP

COGNOS 10

  • Cognos 10 Architecture:-

 

  • User Interfaces
    • Cognos connection
    • Query studio , Report studio, Analysis studio, Event studio
    • Frame work manager
  • Cognos 10 servers
    • Content manager
    • Dispatcher
    • Content store
  • Work Flow
  • Creating Models and Packages
  • Authoring Reports

 

Frame Work Manager:-

Designing  a Project-

  • Naming conventions for objects in a project
  • Connecting to Data sources
  • Create a data source connection
  • Importing Meta data
  • Preparing Meta data for using reports
  • Verifying relationships
  • Working with query subjects
  • Modifying the properties of query items

            -Format query items
-Define a prompt control
-Modifying how query items are aggregated

  • Adding business rules
  • Creating calculations and Filters
  • Using prompt values to filter data
  • Creating a business view of the model

-Use short cuts
-Create a folder or name space
-Create a query item folder

  • Dimension models
  • Specify dimension information
  • Create a star schema grouping
  • Create the package
  • Publishing a package
  • Verify a model and Set governors

Changing the Appearance of the reports

  • Applying filters
  • Shorting data
  • Custom groups
  • Group identical values
  • Calculations
  • Producing reports in various formats

 Report Studio :-

  • Working in Cognos report Studio
  • The User interface
  • Basic report structure
  • Working with objects
  • Creating and managing reports
  • Types of reports
  • List reports
  • Cross tab reports
  • Charts and repeaters
  • Formatting a report
  • Swapping rows and columns
  • Working with data
  • Filter data
  • Sort data
  • Create sections
  • Adding Prompts
  • Working with queries
  • Drilling through Cognos reports
  • Report studio objects and properties
  • A work shop on framework manager
  • Query studio and report studio

 

Query Studio:-

  • Using query studio
  • Creating a report
  • Report types
  • List reports
  • Grouped List reports
  • Cross tab reports
  • Charts

Analysis Studio:-

      • Analysis studio
      • Creating Basic Analysis
      • Working with Items in the Cross Tab

Event Studio:-

      • New Event
      • Ongoing Event
      • Ceased Event
      • No Event
      •  

Cognos Transfomer:-

      • Creating Cubes