Cognos Online Training

Home / Cognos Online Training

Cognos Online Training Course

 Duration: 4 Weeks

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
●    Concepts of Schemas (Star schema & Snowflake schema)
●    Industry leading ETL and Reporting tools

 

INTRODUCTION TO COGNOS

●    About Cognos 8.4
●    3 – Tier Architecture
●    Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences
●    Features of Cognos 8.4
●    Cognos Vs other OLAP tools
●    Cognos components (Modeling & Reporting)
●    Different cognos services

 

COGNOS CONNECTIONS

●    Personalize cognos connection
●    Create and manage portals, shortcuts, report views..etc
●    Working with Cognos configuration, content Store
●    How to Connect to different Data Sources
●    Security setup
●    Import and Export of Package (Deployment)
●    Running the Report Burn
●    Scheduling Reports

 

FRAMEWORK MANAGER

●    About Framework Manager
●    Framework Manager, Metadata Modeling
●    Creation of Interface and Usage
●    Creating Model & Namespace (Layers)
●    Importing Metadata
●    Naming convention for objects in a project
●    Creating Query Subjects & Query Items
●    Merging Query Subjects
●    Creating Relationships & Setting Cardinalities
●    Creating Parameter Maps & Macros
●    Creating of Model Filters, Prompts & Calculations
●    Add Business Rules and Set Governors
●    Assigning package level security
●    Improving performance
●    Publishing Package

 

QUERY STUDIO

●    Introduction
●    About Ad-hoc Reports
●    Types of Report(List, Cross Tab, Chart Reports & Others)
●    Applying Filters, Prompts & Calculations
●    Sorting, Grouping, Sections & Aggregate Functions
●    Run and Manage reports

 

REPORT STUDIO

●    Type of Report Templates
●    Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
●    Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
●    Generating and Creating Prompt Page
●    Types of Prompts
●    Query Calculations & Layout Calculations
●    Filters and Dynamic Filters
●    Conditional Block
●    Conditional Formatting
●    Master Details
●    Cascading Prompt
●    HTML Items & Hyperlinks
●    Set Operators
●    Setting Burst Options
●    Drill through
●    Drill up &  Drill down
●    Setting Variables
●    Report Functions
●    Report Validation
●    Reports Run with Options

 

ANALYSIS STUDIO

●    Insert Data
●    Change the number of Visible Items
●    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
●    Using Dynamic Context

 

EVENT STUDIO

●    Creating Agents
●   Adding Event conditions
●    Task and Task execution rules
●    Scheduling Agents