Introduction to Data warehousing

• Introduction to Data warehousing?
• Introduction to Business Intelligence?
• Who needs Data warehousing?
• Why Data warehousing is required?
• Data warehousing Architecture
• Differ OLTP & OLAP?
• Data Mart –Need ,Advantages
• ETL - Process    
• What is a Dimension?
• What are Facts?
• Star Schema?
• Snowflake Schema?
• Dimension Modeling?
• Slowly changing Dimensions?
• Conformed Dimension?

Cognos 8 BI

The entire Training will be on COGNOS 10 comparing with older version (Cognos 8.4)

Cognos Concepts
About Cognos 10 BI

• Architecture
• Cognos Suit walk through
• Cognos Features, Need & Importance.

Cognos Connection

• Walk through elements on the screen
• Manage Folders(Public & My folders)
• How to Connect to different Data Source
• Import and Export of Package(Deployment)
• Set up Scheduling of Reports

Frame Work Manager

• Introduction about Frame work Manager
• Workflow of Frame work Manager
• Designing a Project
• Working with Data Sources
• Designing and preparing Metadata Model
• Working With Packages

Query Studio

• Introduction
• About Ad-hoc Reports
• Reporting using Query Studio (List, Crosstab, Chart Reports & others)
• Working with Data ( Applying Filters, Prompts & Calculations, Sorting, Grouping &Sections ……)

New Features in Cognos 10

• Business Insight
• Business Insight Advanced
• Active Reports

Report Studio
Overview of Cognos 8 Components & comparison with cognos10
Introduction to Report Studio

• Type of Report Templates
• Creating List, Crosstab, Chart & Others Reports
• Introduction to Filters(creating, editing &removing filters)
• Parameters & Prompts (Definition, Creating prompt Page& Usage of Multiple prompts in Reports)
• Formatting Reports(Fonts, styles, Header &Footers …)
• Types of Prompts (Select& search ,Tree, generated prompt, Date, Time……)

Cognos 10 Advanced Reporting Topics

• Conditional Blocks – Need ,usage
• Conditional Formatting
• Complex Reports (Master Detailed, Drill Through reports)
• Introduction to Query Explorer (Building reports using queries, joins…)
• How to use HTML & JAVA scripts in Reports-Need ,Importance
• Import
• Many more Advanced Reports

Other Topics

• Import & Export XML Reports
• Open Reports from XML
• Creating , Editing Queries
• Workflow of how report runs in backend.
• How to create portal Pages

Analysis Studio

• About Analysis Studio
• Insert Data
• Explore Data
• Types of Reports
• Drill up & Drill down for Detail

Event Studio

• Introduction to Event Studio
• Discuss Event Studio window
• Events, Agents, Tasks..

Real Time Scenarios & Many More……