Contact Us: 91-988 502 2027Email: info@svrtechnologies.com

Course Name: Cognos

Trainer: Kalyan Chakravarthi

Duration: 30 sessions

Each Session: 1 Hour

Version: Cognos V10

Note: The entire Training will be on COGNOS 10 comparing with older version 8.4

1. Introduction to Data warehousing?2. Introduction to Business

Intelligence?3. Who needs Data warehousing?4. Why Data warehousing is required?5. Data warehousing Architecture6. Differ OLTP & OLAP?7. Data Mart –Need, Advantages8. ETL - Process

Session 1 – 4: Introduction to Data warehousing

9. What is a Dimension?10. What are Facts?11. Star Schema?12. Snowflake Schema?13. Dimension Modeling?14. Slowly changing Dimensions?15. Conformed Dimension?

1. Architecture2. Cognos Suit walks through3. Cognos Features, Need & Importance.

Session 5: About Cognos 10 BI

1. Walk through elements on the screen2. Manage Folders (Public & My folders)3. How to connect to different Data Source4. Import and Export of Package (Deployment)5. Set up Scheduling of Reports

Session 6: Cognos Connection

1. Introduction about Frame work Manager2. Workflow of Frame work Manager 3. Designing a Project4. Working with Data Sources5. Designing and preparing Metadata Model6. Working with Packages

Session 7: Frame Work Manager

1. Introduction2. About Ad-hoc Reports3. Reporting using Query Studio (List, Crosstab, Chart Reports & others)4. Working with Data (Applying Filters, Prompts & Calculations, Sorting,

Grouping & Sections)

Session 8: Query Studio

1. Business Insight2. Business Insight Advanced3. Active Reports

Session 9: New Features in Cognos 10

1. Overview of Cognos 8 Components2. comparison with cognos10

Session 10: Report Studio

1. Type of Report Templates2. Creating List, Crosstab, Chart & Others Reports3. Introduction to Filters (creating, editing &removing filters)4. Parameters & Prompts (Definition, Creating prompt Page& Usage of

Multiple prompts in Reports)5. Formatting Reports (Fonts, styles, Header &Footers)6. Types of Prompts (Select& search, Tree, generated prompt, Date,

Time)

Session 11: Introduction to Report Studio

1. Conditional Blocks – Need, usage2. Conditional Formatting3. Complex Reports (Master Detailed, Drill Through reports)4. Introduction to Query Explorer (Building reports using queries,

joins…)5. How to use HTML & JAVA scripts in Reports-Need, Importance6. Import7. Many more Advanced Reports

Session 12: Cognos 10 Advanced Reporting Topics

1. Import & Export XML Reports2. Open Reports from XML3. Creating, Editing Queries4. Workflow of how report runs in backend.5. How to create portal Pages

Session 13: XML & Other

1. About Analysis Studio2. Insert Data3. Explore Data4. Types of Reports 5. Drill up & Drill down for Detail

Session 14: Analysis Studio

1. Introduction to Event Studio2. Discuss Event Studio window3. Events, Agents, Tasks.

Session 15: Event Studio

Thank you