Introduction to Data Warehousing Training

This Data Warehousing course teaches attendees the theories, concepts, domains, techniques, and terminology essential for every business and information technology professional involved in data warehousing. Students also learn best practices for data warehouse development and implementation.

This course focuses on data warehouse deliverables independent of specific methods and understanding deliverables. Students learn common definitions and characteristics of data warehouses, data warehouse architectures, readiness issues, incremental data warehouse project planning, data warehouse strategy, and mistakes to avoid all receive special emphasis.

Course Details


2 days


No prior knowledge is presumed.

Target Audience

  • Professionals interested in Data Science and its various roles
  • Individuals working in data analysis, statistics, or programming fields looking to transition into Data Science
  • Managers or team leaders seeking a better understanding of Data Science roles for effective team organization
  • Students or researchers interested in the latest developments in the Data Science field

Skills Gained

  • Understand and apply the concepts, processes and principles of data warehousing
  • Identify the components of a data warehouse architecture
  • Be familiar with data warehouse terminology
  • Identify success and risk factors of data warehousing
  • Place deliverables within the context of a comprehensive data warehousing process
  • Take practical steps to begin a success data warehousing initiative
Course Outline
  • 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
    • Implementation Deliverables
      • Outcomes from analysis
      • Outcomes from design
      • Outcomes from construction
      • Outcomes from deployment
      • Operational Deliverables
      • Service level agreements
      • Outcomes of usage
      • DW monitoring
      • DW governance
    • Maintaining the DW
      • Incremental DW releases
      • Follow-up to DW
      • On-going assessment
      • Post mortem and lessons learned
      • Managing consultants
      • Managing the vendor
      • Getting started with data warehousing