Business Intelligence & Datawarehousing - (BI & DWH)

Training/Coaching/Tuition by Accord infoMatrix Chennai View Contact

Request Info

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

Accord infoMatrix

Accord Info Matrix is a Chennai based Software Firm. Our main focus areas are Software Training and Software Development. Accord started with the ambitious aim of providing QUALITY training to Students and Corporate. We are integrated as an organization of talented trainers having extensive expertise in all facets of providing quality training.