Cognos Online Training

Cognos Online Training

Cognos Online Training
Cognos Online Training

Cognos Online Training Course Content :

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 Transformer

  • Creating Cubes

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

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim