Data Warehouse Certifications from DWAI

Data Warehouse Association of India
Online

Price on request
You can also call the Study Centre
01140... More

Important information

  • Certificate
  • Online
  • 70 hours of study
Description

To learn indepth processes and designing of Datawarehousing and business intelligence architechture.
Suitable for: Freshers who wish to make there careers in the following: Database management Data Warehouse Business intelligence Data analyst business analyst Business analytics Customer Analytics Database programming Database Modeliing

Important information

Frequent Asked Questions

· Requirements

Basic knowledge of Databases like Sql server, access etc

Course programme

A) BEGINNER’S MODULE (Level-I)

RDBMS CONCEPTS:-

INTRODUCTION TO DATABASE

· Data Types

· DML (Data Manipulation Language)

    • Select
    • Insert
    • Delete
    • Update

· DDL (Data Definition Language)

    • Alter
    • Create
    • Drop
    • Truncate

· DCL (Data Control Language)

    • Grant
    • Revoke

· TCL (Transaction Control language)

Outline Module 3: Planning REQUIREMENTS DEVELOPMENT PROCESS

Outline Module 4: Requirements Gathering Process

MAIN MODULE : Important knowledge

Module Final: Learning Business intelligence research program

· Bandings ( Key Performance Indicators/ KP Matrices)

· Numeric

· Parametric

· Date

· Discrete

· Objects

· Cross tabulations

· Field statistics

· Venn diagram’s

· Multidimensional Cross tabulations

· Session properties

· Import session items

· Export session items

· Report generation

CRM (Customer Relationship Management)

· Alerts

· Performance Measures

· Score fields

· Score bandings

· Time dimensions