Data Warehousing

A data warehouse is a federated repository for all the data that an enterprise's various business systems collect. Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access.

Course Duration :

45-50 hours including real time project experience

Pre Requisites

Basic understanding about database 

Course Content

  • Ø  Basic Concepts and Definitions

        • Definition of the data warehouse (DW)
        • Overall architecture of a DW
        • DW processes
        • Categories of DW technology
        • DW project and initiative types

    Ø  Project Management Deliverables

        • DW strategy
        • DW project scope
        • DW project plan
        • Managing a DW project
        • The iterative release model

    Ø  Introduction to the Dimensional Model

        • Facts
        • Dimensions
        • Star schemas
        • Snowflakes

    Ø  Architectural deliverables

        • Requirements
        • Analysis
        • Design
        • Infrastructure
        • Implementation 

Contact us