The main objective of this course is to give a complete overview of full life cycle (SDLC) of a Vila warehouse project.

• Concepts of Warehouse

• Warehouse Database and Transactional Database

• Architecture of Warehouse

• Pre-requisites of Warehousing

• Advantages and Implementation of Warehousing

• Defining of Entity relations

• Entity definition and types

• Entity Attributes

• Entity Relation Model Designing for a Transactional Database

Creating An E-R Model- Normalization process 

• Design of Database logically and physically

• Creation of Logical Model using ERWIN data modeler

• Creation of Physical Model using ERWIN data modeler

• Data model, subject and Domains

• Applying business and Integrity constraints

• Generating database script and creating a database

ERWIN

The course starts with fundamentals of Data warehousing. ERWIN 4.1 data modeler tool will be taught during this period. The main parts covered are:

• Definition of a Data warehouse

• Difference between a transactional based system and a data warehouse system

• How to create a dimensional model from a transactional system

• Creation of STAR and SNOWFLAKE schema

• Latest modeling technique like Business Dimensional Modeling (BDM)

• How to create data model ERWIN 4.1

• How to forward Engineer ERWIN data model to create DDL scripts

• How to reverse Engineer ERWIN model

• Complete example and assignment of creating a Retail Dimensional model in ERWIN

INFORMATICA

 ETL- INFORMATICA Server Setup

• Power Center Repository Manager

  o    Repository creation

• Connecting to New Repository

  o    Create Folder

  o    Edit Folder

  o    Delete Folder

• Manage users, groups, and privileges

• Source and Target dependencies

• Mapping dependencies

Power Center Designer

• Defining Sources and Source types

• Defining Targets for Staging databases

• Defining Targets for Staging Warehouse

• Creating Multi-Dimensional Cubes

• Source analyzer tool

• Warehouse designer tool

• Transformation developer tool

• Mapplet designer tool

• Designer Data Staging

Power Center Workflow Manager

• Setting up server for Repository

• Task developer tool

• Work let designer tool

• Workflow designer tool

• Working with Sessions, Sources and Targets

• Monitoring workflow

• Performance tuning

OLAP (Online Analytical Processing Report Presentations)

• Introduction to OLAP

• Relational, Multi- Dimensional, Hybrid OLAP’s

• OLAP Architecture

• Reports and Types of Reports 

Business Objects

Supervisor Tool

• Creating OLAP Repository and Supervisor user

• Database connections

• Defining groups and users                                                                                 

• Defining privileges and profiles

• Broadcast agent setup

• Setting up user connection sessions

Designer Tool

• Creating universe, universe settings

• Testing universes

• Defining classes, objects, object types

• Advantages of user-defined classes, objects

• Designer enhancements 

• Generating reports

• Formatting reports

• Analysis methods

• Slice and Dice analysis

• Drill analysis

• Enhancements of Reports

COGNOS

Impromptu Administrator

• Database connection

• Creating catalog, Catalog folders

• Testing Catalog

• Creating conditions, calculations and prompts

• Creating users and allocating privilege

• Creating and formatting impromptu reports

• Creating impromptu query definition 

• Creating model files

• Creating new dimensions and measures

• Editing dimensions

• Measures in Model files

• Creating power cubes

• Setting power cube properties

• Testing power cubes

• Connecting power cubes to repositories

• Creating reports

• Formatting reports

• Drill analysis-using reports

• Cognos portfolio tool

• Cognos script editor (Macros)

• Scheduling using cognos scheduler tool                 

DATA STAGE

 Introduction

• Role of Data stage

  o    Extraction

  o    Transformation

  o    Loading tool in data warehouse development

• Using the client side Data stage tool set

  o    Designer

  o    Director

  o    Manager

  o    Administrator

• Importing, exporting and understanding Repository metadata

• Using parameters/ Variables within Data stage jobs and routines

• Job/batch scheduling and execution 

• Configuring data stage.

• Data stage administrator.

• Server properties.

• Data stage project administration.

  o    Adding projects, deleting projects

  o    Moving projects

  o    Cleaning up project files

  o    Project properties

• Data stage manager overview

• Managing the Data stage repository

• Managing table definitions

• Managing Data elements

• Managing jobs and job sequences            

• Managing shared containers

• Managing stages

• About data stage

• Data stage projects

• Data stage jobs

  o    Server jobs

  o    Shared Containers

  o    Job sequences

Data Stage Director

• Starting the Data stage director.

• Data stage director window.

• Job status details.

• Running Data stage jobs

  o    Setting job options

  o    Validating a job

  o    Running a job

  o    Stopping a job  

Micro Strategy

• Introduction to creation of project

• Schema object creation

  o   Facts

  o    Attributes

  o    Hiewarchies

• Introduction to advance reporting

• Advanced metrics

• Advanced filters

• Advanced prompts

• Drill maps

• Report data options

• Project and desktop preferences

• VLDB properties

• Project duplication wizard