Cognos Online Training Certification Course | Cognos TM1 Online Training in USA,UK,Canada,India

1. A1Trainings Cognos Online Training Certification Course | Cognos TM1 Online Training in USA,UK,Canada,Australia,Japan,India

2. Cognos • Cognos (Cognos Incorporated) was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 135 countries until being acquired by IBM on January 31, 2008.

3. CognosCourse Content

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

5. Cognos 8 BI • The entire Training will be on COGNOS 10 comparing with older version (Cognos 8.4)

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

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

8. 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 ……)

9. New Features in Cognos 10 • Business Insight • Business Insight Advanced • Active Reports

10. Report Studio Overview of Cognos 8 Components & comparison withcognos10 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……)

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

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

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

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

15. Contact Us • Contact Info • Address: Madhapur, Hyderabad. • Email: contact@a1trainings.com • Call us: 7680813158 • Web: www.a1trainings.com