Training Enquiry

Cognos Training


Course Name : Cognos                                                                    24*7 Technical Support
Duration         : 35 hours
Faculty            : Realtime experience

           Sun trainings is a best online center in Hyderabad. We are providing very best online training on Cognos.
Course Content:

INTRODUCTION

Introduction To Dataware Housing

• Introduction to Dataware Housing
• Characteristics of Dataware Housing
• 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

Tier Architecture

• Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3)
• 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
• Static 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 (separate course not included in this package)

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