Section 1: (Installation and Configuration)
- Web Server
- Database Server (SQL Server, Oracle)
- Cognos 8.4 Components (BI Server, BI Modeling, BI Transformer)
- Configuring all three servers
Section 2: (SQL)
- Basic SQL introduction
- Understanding of SQL Queries, Joins, Views,etc
- SQL tasks
Section 3: (Overview)
- Introduction of BI Components
- High-Level BI Architecture
- User Groups and Roles
- Data Flow through a BI System
Section 4: (Web portal)
- Introduction to BI Reporting and the sample data
- Importing packages and sample reports
- Introduction to Report Studio, Query Studio, Analysis Studio and Event Studio
|
|
Sections 5: (Reporting Tools)
- Cognos Administration and Securities
- Report Studio (Basic and Advanced)
- Query Studio
- Analysis Studio
- Event Studio
- Cognos Go! Office
Section 6: (Modeling Tools)
- Framework Manager Modeling concepts - Relational and Dimensional
- Transformer Modeling concepts
Section 7: (Modeling and Reporting Tasks)
- Build FM Models and Transformer Models
- Create reports according to the given specifications (Relational and Dimensional)
|
|