Cognos 8.4 Training @ ONLINE - Cognos 8.4 Course Content

1.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

2. Introduction to Cognos

• About Cognos 8.4
• 3 – 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

3.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

4.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

5.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

6.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)

7.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

8.Event Studio

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

Thanks a bunch in advance for accepting our services.

Tek Cognos,
608,Chaitanya Chambers,
Chaitanyapuri,
Dilsukh Nagar,
Hyderabad – 500060
tekcognos@gmail.com
9702303456

Tek Cognos,
608,Chaitanya Chambers,
Chaitanyapuri,
Dilsukh Nagar,
Hyderabad – 500060
tekcognos@gmail.com
9948521536