ARIEL TECHNOLOGIES INDIA PVT LTD

IT TRAINING & DEVELOPMENT

DATA WAREHOUSING Training contents

Introduction to Data warehousing

·         Who needs Data warehouse?

·         Why Data warehouse is required?

·         Types of Systems

·         Maintenance of Data warehouse

·         Data warehousing Life cycle

·         Data warehousing Testing Ute Cycle

·         Source

Data warehousing Architecture

·         Integration Layer

·         Staging Area

·         Targets

·         Analysis & Reporting

·         HPQS

·         Introduction

·         Data Modelling

·         Different Phases of Modelling

·         What Is a Dimension?

·         Multi-Dimensional Modelling

·         What are Facts?

·         Multi-Dimensional Model

·         Hierarchies

·         OLAP

·         MOLAP

·         ROLAP

·         HOLAP

·         Cubes and its Functions

·         Star Schema

·         Fact Table

·         Dimensional Tables

·         Snow flake Schema

·         Fact less Fact Table

·         Confirmed Dimensions

·         Introduction to Erwin

Data Modelling Tools

·         Forward Engineering

·         Reverse Engineering

·         Update Model, Alter database

·         Complete compare

Real Time Project