COGNOS Course Content Traning at learning hub - Pune

COGNOS Course Content Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in



Cognos Course Detail


COGNOS Course Content @ Learning Hub

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
•About Cognos
•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)
COGNOS CONNECTIONS
•Personalize Cognos Connection
•Create and manage portals, shortcuts, report views..etc
•Running the Report Burn
•Scheduling Reports
•Various Options in Cognos Connection
REPORT STUDIO
•Report Studio User Interface
•Creating, Save and run reports
•Managing Reports.
•Creating list, Cross Tab etc.
•Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
•Filters, Parameters and Prompts
•Subtotals and Calculations
•Working with Queries
•Generating and Creating Prompt Page
•Types Of Reports
•Types of Prompts
•Types of Variables
•Query Calculations & Layout Calculations
•Filters and Dynamic Filters
•Conditional Block
•Conditional Formatting
•Master Details
•Cascading Prompt
•Operators
•Setting Burst Options
•Drill through
•Setting Variables
•Report Functions
•Report Validation
•Reports Run with Options
•Different types of Reports with various functionalities
•Unions
•Joins
•Components and there properties.

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

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
•Using Dynamic Context
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

Please Contact-

Learning Hub,
S-12, Destination Centre,
2nd Floor, Above HDFC Bank,
Next to Noble Polyclinic,
MAGARPATTA CITY,
PUNE – 411013,
PH: +91- 93257-93756.
Skype id : learning.hub01
Email: learninghub01@gmail.com
www.learninghub.co.in