COGNOS COURSE CONTENT TRANING AT LEARNING HUB MAGARPATTA CITY /FC ROAD PUNE (+91 93257 93756) WWW.LE IN 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