IBM Cognos Analytics Training

• How to deal with Advanced Report Authoring?
• How to manage Relational Data Modeling through two real-time projects?
• Why should we consider Data Warehousing solutions?
• How to develop Multi-dimensional reports in Query Studio?
• How to design data models using Cognos metadata layer?
• How to identify problem SQL statements and tune SQL performance problems?
• How to monitor performance instances using Enterprise Manager?
• How to develop cubes to provide ROLAP capability using Powerplay transformer?
• How to develop professional dashboards using Cognos report studio?
• How to customize report outputs by using report views?
• How to create a list, grouped list, and crosstab reports?

• Recorded Videos After Training
• Digital Learning Material
• Course Completion Certificate
• 24x7 After Training Support

• Software Developers
• Web Developers
• Professionals from Analyst back
• Graduates who are looking for a career in Cognos

• Knowledge of SQL basics
• A deep level familiarty with data warehouse concepts

• Multisoft Systems will provide you with a training completion certificate after completing this IBM Cognos Analytics Training

Module 1: Data Warehouse Basics

• Why should we consider Data Warehousing solutions?
• Definition of Data Warehouse
• Characteristics of DWH
• Difference between DW’s and OLTP
• DWH Life Cycle
• DWH Architecture
• Dimensions & Facts
• Star Schema & Snowflake Schema Design

Module 2: Building Cubes and Views

• What is IBM Cognos Analytics?
• Examine IBM Cognos Analytics UI elements
• Run and view reports
• View the run history of a report
• Organize content with folders and shortcuts
• Customize report outputs by using report views
• Schedule single and multiple reports
• Backups-Export of Cognos Content
• Create a Data source
• Deployment
• Users, Groups and Roles

Module 3: Introduction to Query Studio

• List the packages available for reporting
• Understand report types
• Add and save data to ad hoc reports
• View data by using charts

Module 4: Create Reports in Query Studio

• Create a list, grouped list, and crosstab reports
• Calculate and sort report data

Module 5: Enhance Reports in Query Studio

• Highlight report items using conditional styles
• Focus the scope of a report using filters
• Format report objects

Module 6: IBM Cognos Framework Manager: Relational Metadata Modeling

• Introduction to Framework Manager
• User Interface, Navigation, Objects
• https://mindmajix.com © Mindmajix Technologies Inc. All Rights Reserved Page No. 5
• Create a list, grouped list, and crosstab reports
• Calculate and sort report data
• 4. Create Reports in Query Studio
• 5. Enhance Reports in Query Studio
• Highlight report items using conditional styles
• Focus the scope of a report using filters
• Format report objects
• Designing Project
• Create project
• Importing Metadata
• Working with Data Source Connections
• Create and Modify Data Sources
• Preparing Relational Metadata for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects
• Working with Query Items
• Supporting Multilingual Metadata
• Adding Business Rules
• Organizing the Model
• Verify Model
• Set Governors
• Create or Modify Package
• Publish Package
• Object Data and package security
• Making Metadata Available to Report Authors
• Edit Governors
• Guidelines for Modeling Metadata
• DMR model - Regular Dimensions, Measure Dimensions, Scope Relationship

Module 7: Advanced Report Authoring

• Introduction to the Reporting Application 
• Create List Reports 
• Focus Reports Using Filters 
• Create Cross Tab Reports
• Present Data Graphically
• Focus Reports Using Prompts
• Extend Reports Using Calculations
• Design Effective Reports 
• Customize Reports with Conditional Forming 
• Drill-Through from One Report to Another 
• Examine the Report Specification 
• Create Reports Based on Query Relationships 
• Distribute Reports Through Bursting 
• Active Reports

Module 8: Advanced Report Authoring 

• Analysis Studio Fundamentals 
• Tools for Investigation in Analysis Studio 
• Nest Data in Cross Tabs in Analysis Studio 
• Build Advanced Cross Tabs in Analysis Studio 
• Focus with Filtersin Analysis Studio 

Module 9: Event Studio - Work Space

• Data Warehousing concepts ppt
• Cognos Connection ppt along with screenshots
• Query studio ppt along with screenshots
• Query Studio Topics for Practice Doc
• Report studio ppt along with screenshots
• Report Studio Topics for Practice Doc
• Framework Manager ppt along with screenshots
• Analysis Studio ppt along with screenshots