Data ware house concepts and Cognos Training-Online Training
Data ware house concepts and Cognos Training-Online Training
Duration: 4weeks (week ends, 4hrs/day)
Pre Requisite: Oracle (SQL)
Data Warehousing Concepts:
* Introduction to Data Warehouse
* OLTP & OLAP Databases
* Data Warehouse Life Cycle - Architecture
* Data Cleansing, ETL, Meta Data
* Reporting Tools: ROLAP, MOLAP, HOLAP
* Data Warehouses, Data Marts and Business Intelligence
* Characteristics of Data Warehouse
* Data Mining! Knowledge Discovery in Databases
Drill up & Drill Down
Slicing & Dicing
Data Warehouse Modeling (Logical & Physical)
* E-R Modeling and Normalization
* Relational Modeling and Dimensional Modeling
* Designing Star Schema, Snowflake Schema
* Galaxy / Multi-Star Schema
* Dimension Tables, Fact Tables (Dimensions, Details & Measures)
* Surrogate Key, Conformed Dimension and Critical Columns.
COGNOS ENTERPRISE REPORTING SUITE 7.3 (MOLAP Reporting Tool)
* Introduction to COGNOS Reporting Suite
Impromptu Administrator, Power Play Transformer, Power Play,
Cognos Server Administrator (IWR Server and Power Play Server)
Cognos Access Manager, Cognos Up front
* Cognos Suite Architecture
* Impromptu Administrator
Creating and Designing Catalogs
Security issues: Folders, User Profiles
* Creating Impromptu Reports
Creating basic report, sub-reports and Cross tab reports.
Filters, Grouping and Sorting Data in the IMR report
* Power Play Transformer
Transformer Fundamentals and Development Process
Building and Creating a Transformer Model
Time Dimension, Multiple Data Sources, Measures and Power Cubes
* Power Play Report Builder
Data Exploring, Reporting and Data Analyzing
Calculations, Cross Tab Reports, Chart and Graphs
Drilling, Slicing & Dicing and Sub Reports
* Cognos Server Administrator and Cognos Upfront
Working with Cognos Upfront Portal
Publish and distribute a report as HTML and PDF
Publish a report to Upfront
COGNOS 8 SERIES
* Frame Work Manager
* Cognos Connection
* Report Studio
* Query Studio 8.1
contact us indiantagore@yahoo.com
Data ware house concepts and Cognos Training-Online Training
Contact Info: indiantagore@yahoo.com
---------------------------------------------------------------