Welcome To Eazygurus

Cognos

Course Name        :   COGNOS 10 Data warehousing
Duration                 :  35 hrs

STUDENTS ENROLLED

    Ø  INTRODUCTION TO DATAWARE HOUSING (DWH)

    • ·     Introduction to DWH
    • ·     Characteristics of DWH
    • ·     OLTP Vs OLAP Databases
    • ·     Different Approaches of DWH (Kimball Vs Inmon)
    • ·     Data mart Vs Data Warehouse
    • ·     Fact Table Vs Dimension Table
    • ·     Types Of Facts
    • ·     Types Of Dimensions
    • ·     ETL
    • ·     Staging Area
    • ·     Concepts of Schemas (Star schema & Snowflake schema)
    • ·     CLP Modeling
    • ·     Industry leading ETL and Reporting tools
    Ø  INTRODUCTION TO COGNOS

    • ·     Cognos Vs other OLAP tools
    • ·     Cognos components (Modeling & Reporting)
    Ø  COGNOS CONNECTIONS

    • ·     Personalize Cognos Connection
    • ·     Create and manage portals, shortcuts, report views..etc
    • ·     Scheduling Reports
    • ·     Various Options in Cognos Connection

    Ø  REPORT STUDIO

    • ·     Report Studio User Interface
    • ·     Types Of Reports-Creating List, Cross Tab, Chart etc..
    • ·     Report templates, formatting Reports – fonts, style, header, footer, boarder etc..
    • ·     Page set
    • ·     Filters and  Prompts
    • ·     Working with Queries
    • ·     Cascading Prompt
    • ·     Types of Prompts
    • ·     Types of Variables
    • ·     Conditional Block
    • ·     Query Calculations & Layout Calculations & Layout Component Reference
    • ·     Conditional Formatting
    • ·     Master Details
    • ·     Drill through
    • ·     Setting Burst Options
    • ·     Report Validation
    • ·     Reports Run with Options
    • ·     Set Operators-Union, Join, Intersect, Exception
    • ·     Components and their properties.
    Ø  QUERY STUDIO

    • ·     Introduction
    • ·     About Ad-hoc Reports
    • ·     Types of Report(List, Cross Tab, Chart Reports & Others)
    • ·     Applying Filter & Calculations
    • ·     Sorting, Grouping, Sections & Aggregate Functions
    • ·     Run and Manage reports
    Ø  ANALYSIS STUDIO

    • ·     Insert Data
    • ·     Nest Data
    • ·     Replace Data
    • ·     Sort Data
    • ·     Explore Data
    • ·     Change the measure
    • ·     Drill down for Details
      • Hide Items
      • Insert a calculation
      • Save a custom set
      • Define a filter
      • Compare sets of data
      • Context Filter

    Ø  EVENT STUDIO

    • •    Creating Agents •    Adding Event conditions •    Task and Task execution rules •    Scheduling Agents
    Ø  FRAMEWORK MANAGER

    • About Framework Manager
    • Framework Manager, Metadata Modeling
    • Usage property
    • Creating Model & Namespace (Layers)
    • Importing Metadata
    • Naming convention for objects in a project
    • Creating Query Subjects & Query Items
    • Setting Cardinalities
    • Publishing Package

    Ø Business Insight in Cognos 10 Ø Business Insight Advanced in Cognos 10 Ø Active Reports in Cognos 10

    • Decks and Data Decks
    • Tab Controls and Data Tab Controls
    • Button Bars and Data Button Bars
    • Toggle Button Bars and Data Toggle Button Bars
    • Radio Button Groups and Data Radio Button Groups
    • Check Box Groups and Data Check Box Groups
    • Drop-Down Lists and Data Drop-Down Lists
    • List Boxes and Data List Boxes
    • Buttons

    Key Benefits:

    • –>  Exposure to real time scenarios.
    • –>  Job oriented training program.
    • –>  Training in an enterprise highly focused in recruitment.
    • –>  Resume Preparation and Interview Tips
    • –>  Q & A
    • –>  Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.