Real Time Experts
4.9 out of 5 based on 337 Reviews
Cognos Course Syllabus
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 10 BI introduction
i. Cognos Architecture
ii. Installation of Cognos 10 BI
iii. Configuring Cognos 10 BI
iv. Different studios in Cognos 10 BI
4. Cognos 10 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
10. 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