COGNOS 10 BI TRAINING IN NOIDA

COGNOS DATA WAREHOUSING

• Introduction to DATA WAREHOUSING
• DATA WAREHOUSING CONCEPTS
• DIFFERENCES BETWEEN TRANSECTION DATA AND WAREHOUSING DATA
• DATA WAREHOUSING ARCHITECTURE
• source data,staging data and target data
• olap types
• MOLAP,ROLAP,HOLAP
• OPERATIONAL AND DATA STORE(ODS)
• METADATA AND DATA MINING
• DIFFERENCES BETWEEN DATA MART AND DATA WAREHOUSE
• SCHEMAS USED IN DATA WAREHOUSING
• SLOWLY CHANGING DIMENSIONS
• REAL TIME DATA WAREHOUSE

DATABASE DESIGN AND DATA MODELLING

• ENTITY-RELATIONAL MODEL(E-R MODEL) FOR TRANSACTIONAL DATABASE
• DEFINING ENTITIES AND THEIR RELATIONSHIP
• DISTRIBUTION OF ATTRIBUTES UNDER ENTITES
• NORMALIZATION OF ENTITES
• CONVERSION OF LOGICAL MODAL INTO PHYSICAL MODEL
• MODELING LOGICAL E-R MODEL USING ERWIN TOOL
• DESCRIPTION ABOUT STRUCTURED QUERY LANGUAGE
• CASE STUDIES

DIMENSIONAL MODEL FOR DATAWAREHOUSING

• DEFINE DIMEENSIONS AND MEASURES
• DEFINING LEVELS AN DHIERARCHIES
• GRANULARITY OF DATA
• DESCRIPTION ABOUT SNOW FLAK SCHEMA
• DIMENSION ABOUT SNOW FLAK SCHEMA
• DIMENSION TABLE EAND FACT TABLE
• FACTLESS FACT TABLE
• ADDITIVE MEASURES, NON-ADDITIVE AND SEMI-ADDITIVE
• NORMALIZATION AND DENOMALIZATION
• MANY tO MANY DIMENSIONS
• CASE STUDIES

OLAP USING COGNOS 10 BI

• INTRODUCTION OF DATA WAREHOUSING PROCESS
• DETAILED EXPLANATION ABOUT OLTP SYSTEM
• DETAILED EXPLANATION ABOUT OLAP SYSTEM
• EXPLANATION OF DWH LIFE CYCLE
• DETAILED EXPLANATION OF OLAP LIFE TYPES
• DETAILED EXPLANATION OF COGNOS 10 BI ARCHITECTURE
• EXPLANATION OF OLAP TYPES
• DETAILED EXPLANATION OF DIMENSIONS MODELING
• DETAILED EXPLANATION OF STAR AND SNOW FLAK SCHEMA

DEVELOPER ROLES INCLUDING

• RESPONSIBLE FOR BUIDING DATABASE AND IMPORTING DATABASE
• MODELS OR APPLICATIONS FOR END -USER INCLUDE DATA MART DEVELOPEMENT
• METADATA AND OLAP MODLES
• ADMINSTRATION HANDLING

CREATING PACKAGE AND MODELS BY USING COGNOS 10BI FRAME WORK MANAGER

• COGNOS 10BI FRAMEWORK MANAGER: DESIGNING METADATA MODELS
• DESCRIPTION ABOUT BUSINESS IDEAS
• CREATING RELATIONSHIP BETWEEN FACTS AND DIMENSIONS
• WORKING ON GOVERNORS AND DETERMINANTS
• CREATION OF PACKAGE ACCORDING TO THE BUSINESS REQUIREMENTS
• PUBLISHING PACKAGE

CREATING OF POWER CUBES USING IBM COGNOS TRANSFORMER

• CREATIONS HIERARCHIES AND THE LEVELS
• CREATION OF CUSTOM VIEWS
• WORKING ON TIME HIERARCHIES
• CREATING AND PUBLISHING THE POWER CUBES
• CREATION OF REPORTS IN ANALYSIS FOR CUBE DATA

GENERATING REPORTS WITH REPORTS STUDIO

• AUTHORING PROFESSIONAL REPORTS
• AUTHORING REPORTS WITH MULTI DIMENSIONAL DATA
• WORKING WITH MASTER DETAILED , DRILL THROUGH AND DATE REPORTS
• WORKING WITH YTD, MTD, QTD ETC
• GENERATING REPORTS WITH BURST OPTIONS
• SCHEDULING REPORTS USING BI SERVER

GENERATING REPORTS WITH ANALYSIS STUDIO

• GENRATING CHARTS AND MULTI-DIMENSIONAL REPORTS USING COGNOS BI SUITE
• DRILL DOWN AND DRILL UP PROCESS
• PUBLISHING REPORT ANALYSIS AND REVIEW

GENERATING REPORTS WITH EVENT STUDIO

• CREATING ,SCHEDULING AND MANAGING REPORTS
• CREATING OF AGENTS AND SPECIFYING EVENT CONDITION
• TROUBLESHOOTING ON EVENT STUDIO

GENERATING OF DASHBOARD BOARD USING BUSINESS INSIGHT

• CREATION OF END USER REPORTS USING BUSINESS INSIGHT
• MERGING OF REPORTS ACCORDING TO BUSINESS REQUIREMENTS
• COGNOS BI ADMINISTRATION AND USER CREATION WITH PRIVILEGES