COGNOS TRAINING

Below is the detailed course outline of Cognos 8 training. For further information, contact guideoncognos@gmail.com.

1. Overview of Business Intelligence

                      i.        What is Business Intelligence

                     ii.        Importance & Uses of BI

                    iii.        Components of BI

                    iv.        Business Intelligence Roadmap

2. Overview of Data Warehousing

                      i.        What is Data Warehouse

                     ii.        OLTP and OLAP systems

                    iii.        Data Warehouse Architecture

                    iv.        Star Schema

3. Cognos 8 BI introduction

                      i.        Cognos Architecture

                     ii.        Installation of Cognos 8 BI

                    iii.        Configuring Cognos 8 BI

                    iv.        Different studios in Cognos 8 BI

4. Cognos 8 BI Administration

                      i.        Create and Modify Data Sources

                     ii.        Create Users, Roles and Groups

                    iii.        Define permission/security settings

5. Cognos Connection QuickTour

                      i.        Navigation - Public and Private Folder

                     ii.        Scheduling – Report, format options, job

                    iii.        Create URL, Portals, Pages, Report views

                    iv.        Cognos Configuration, Content Store

                     v.        Security setup and Deployment(import,export)

6. Cognos Query Studio

                      I.        Introduction to Query Studio

                     II.        Create Reports (List, Crosstab, Charts, Grouped List)

                    III.        Report Layout and formatting

                   IV.        Sorting, Grouping & Subtotals

                    V.        Applying Filters, Prompts & Calculations

                   VI.        Drill Through Reports

                  VII.        Run and Manage Reports

7. Cognos Analysis Studio

                      I.        Introduction to Analysis Studio

                     II.        Creating a basic Analysis

                    III.        Insert data, Nest data

                   IV.        Exploring data

                    V.        Change measure, Drill down

                   VI.        Insert a calculation, Sharing data

8. Cognos Report Studio

                      I.        Introduction to Report Studio

                     II.        Creating List, Crosstab, Chart, Repeater, Maps

                    III.        Formatting Reports

                   IV.        Creating prompts, filters, calculations

                    V.        Conditional formatting

                   VI.        Master detail and drill through reports

                  VII.        Report bursting

                 VIII.        Setting Variables

                   IX.        Set operators

                    X.        Report functions & Report validation

9. Cognos Framework Manager

                      I.        Introduction to Framework Manager

                 (User Interface, Navigation, Objects, Metadata modeling)

                     II.        Creating Model & Namespace (Layers)

                    III.        Importing Metadata

                   IV.        Creating Query Subjects & Query Items

                    V.        Creating Relationships & setting cardinalities

                   VI.        Verify model, publishing package

                  VII.        Add Business Rules & Set Governors

                 VIII.        Assigning package level security

                   IX.        Calculations & Filters

10. Cognos Event Studio

 

                      I.        Introduction to Event Studio

                     II.        Creating Agents

                    III.        Specify an Event condition

                   IV.        Scheduling Agent