Business Intelligence & Datawarehousing - (BI & DWH)

Accord info Matrix Offers Best Business Intelligence & Datawarehousing Training in Chennai. We offer Internships in Real -Life Business Applications of our clients. Students are given practical Training in the below mentioned syllabus. The Syllabus can be customized according to individual needs.

Datawarehousing

• What is Data Warehouse?

• Characteristics of Data warehouse

• What is Data warehousing?

• Principles of Data warehouse

• Benefits of DWH

• HPQS

• Approaches of Data warehousing

• Normalization and De-normalization

• DWH Modeling

• Dimension table

• Fact Table

• Aggregate table

• Schemas

• Star Schema

• Snoflake schema

• Basic Data Model Objects

• Identifying

• Non-identifying

• Display Levels

• Subjects Area

• Star Scheme

• Snowflake Schema

• Type of Fact Tables:

• Cumulative

• Snapshot

• Fact less fact

• Types of Facts

• Additive

• Semi Additive

• Non Additive

• Confirmed Dimension

• Confirmed Fact

• Degenerated Dimension Casual Dimension

• ODS

• Cube

• Hierachies

• Slowly Changing Dimension Concepts

• OLAP's

ERWIN

• Geeting Started

• Erwin workplace

• Model Explorer

• Dockable

• Toolbars

• Stored Display Tabs

• Basic Data model Objects

• Identifying

• Non-identifying

• Display Levels

• Subject Area

Informatica

• Introducation to Informatica

• Products of Informatica

• Difference between power mart and Power center

• Installation of Informatica

• Configuring Informatica

• Configuring Informatica Repository Server

• Creating & Configuring Repository

• Configuring Informatica Server

• Configuration Temp Server (Workflow Manager)

• Informatica Client Tools

• Designer (Components)

• Source Analyzer

• Workflow Manager (Components)

• Workflow Monitor

• Repository Manager

• Repository Server Admin Console

• Informatica Server Tools

• Repositiry Server

• Server

• Transformations

• Source Qualifier

• Filter

• Expression

• Aggregator

• Joiner

• Router

• Rank

• Sorter

• Sequence Generator

• Union Xml Source Qualifier

• Lookup (Connected/Unconnected)

• Stored Procedure (Connected/Unconnected)

• Update strategy

• Transactioncontrol

• Normalizer

• Application Source Qualifier

• Application Multi – group Source Qualifier

• Custom

• Mapplet Input

• Mapplet Output

• Midstream XML Generator

• Midstream XML Parser

• Concepts

• SQL Override

• Working with files (Sources, Target)

• File Repository Concepts

• Constrained Based Loading

• Parameters

• Mapping Parameters

• Mapping Variables

• Session Parameters

• Incremental Aggregator

• application Source Qualifier

• Debugging

• Slowly Changing Dimension

Business Objects

• BO Reporting Tool

• The Query Panel

• Turning Tables To chart

• Formatting Cells/Tables

• The Structure View

• Insertion of Rows or Columns

• Breaks

• Sections

• Ranking Filter

• Alerters

• Crosstabs

• Grouping

• Slice? And – Data

• Drill

• Exporting DatawarehousingData providers

• Master/Detail Reports

• Introdution to BO Designer

• Simple Universe and Object Creation

• Creating Hierarchy

• Resolving Loops and SQL Problems

• Supervisor

Business Objects

• Introduction to web intelligence

• Getting Started with info view

• Viewing Documents in Info view

• Creating New Documents with queries

• Restrictinf Data returned by a Query

• Displaying information in different ways

• Enhancing report presentation

• Formatting Reports

• Creating Formulae and cariables

COGNOS

• Congos Impromptu

• Power play Window

• Transformer

CONGNOS Reportnet

• Congnos Reportnet an Architecture

• Cognos connection

• Report Studio

• Query Studio

• Frame work manager