TRAINING CLASSES CONDUCTING ON COGNOS COURSE @ ELEGANT

Data Warehousing Concepts
1. What is a data warehouse
2. Data warehouse Architecture
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a Staging Area)
Data Warehouse Architecture (with a Staging Area and Data Marts)
3. Data Warehousing Schemas
Star Schema
Snowflake Schema
4. Data Marts
5. Data Warehouse Objects
Fact Tables
Dimension Tables
Unique Identifiers
Relationships
6. Hierarchies
7. Levels
8. Types Of Facts
Additive
Semi-Additive
Non-Additive
9. Slowly Changing Dimensions (SCD)
Type 1
Type 2
Type 3
10. OLAP
MOLAP
ROLAP
HOLAP
11. OLTP
12. Factless Fact Table
13. Junk Dimension
14. Confirmed Dimension
15. Role Playing Dimension
16. Surrogate Keys





Framework Manager
1. Creating a project
2. Namespace
3. Query Subjects
Data source Query Subject
Model Query Subject
Stored Procedure Query Subject
4. Query Items
5. Folders
6. Importing Tables/Views
7. Usage Properties
8. Relationships
9. Cardinality
10. Filters
Static Filters
Embedded Filters
Standalone Filters
Dynamic Filters
Parameterized Filters
11. Calculations
12. Packages
13. Data source
14. Publishing Packages
15. Security
Data Level Security
Object Level Security
Package Level Security

Advanced Topics:

1. Parameter Maps
2. Determinants
3. Loops & Traps

DMR Modeling:

1. Regular dimensions
2. Hierarchies
3. Levels
4. Measures
5. Define scope


Report Studio

Report studio Navigation
1. Page Explorer
Report Pages
Prompt Pages
Classes
2. Query Explorer
Queries
Query
Join
Union
Intersect
Except
SQL
MDX
Filters
Detail Filters
Summary Filters
Slicer
3. Condition Explorer
4. Properties Pane
5. Work space
6. Source
7. Data Items
8. Tool Box
Text Item
Block
Table
Field Set
Query Calculation
Layout Calculation
Image
Crosstab Space
Crosstab Space (With Fact Cells)
List
Crosstab
Chart
Map
Repeater Table
Repeater
Singleton
Conditional Blocks
HTML Item
Rich Text Item
Hyperlink
Hyperlink Button
Date
Time
As of Time Expression
Page Number
Row Number
Layout Component Reference
Metric Studio Diagram
Table of Contents
Table of Contents Entry
Bookmark
Text Box Prompt
Value Prompt
Select & Search Prompt
Date & Time Prompt
Date Prompt
Time Prompt
Interval Prompt
Tree Prompt
Generated Prompt
Prompt Button

Report Studio Exercises

9. Dynamic Columns
10. Conditional rendering of report objects
11. Conditional Formatting
12. Drill-throughs
13. Drill-up and Drill-down
14. Bursting
15. Scheduling by trigger

Contact us for more details
ELEGANT IT SERVICES
9 8 8 6 5 4 1264
Email:[email protected]
Website:www.elegantits
ervices.com