Data Warehousing Concepts and Principles

An Introduction to the Field of Data Warehousing

One-day Course

Certificate Course

Prerequisite: None

You Will Learn:

   • Basic concepts of data warehousing
   • Common language, terminology, and definitions in data warehousing
   • Key factors that contribute to data warehousing success
   • Risk factors for data warehousing projects
   • Common approaches to data warehousing architecture
   • Data warehousing roles and responsibilities
   • Data warehouse development concepts and best practices
   • Data warehouse operations and administration considerations

Geared To:

Anyone new to data warehousing; DW teams that need to develop a common base of concepts and terminology; DW team members who need to understand the roles and responsibilities of others on their team

Module One

Data Warehousing Concepts

   • Data Warehousing Basics
     • Understanding Data, Information, and Knowledge
     • Kinds of Information Needs
     • Data Warehousing Definitions
     • Data Warehouse
     • Data Warehousing
     • Data Stores

   • The Data Warehousing Application
   • Building Blocks – Extract, Transform, and Load
   • Configuring the Application
     • three-tiers: staging, warehouse, and data marts
     • two-tiers: warehouse and data marts
     • conformed data marts
     • independent data marts

   • Contrasting Data Stores

     • Data Warehouse
     • Data Mart
     • Staging Area

  • The Data Warehousing Process
     • Architecture, Implementation, and Operation
     • Incremental Implementation with Evolving Architecture
     • The Data Warehousing Program
     • Program Planning
     • Program Charter
     • Readiness Assessment

Module Two

  Data Warehousing Architecture

   • Business Architecture
     • Business Drivers
     • Business Goals
     • Business Processes

   • Data Architecture
     • Data Analysis and Data Standards
     • Information Needs Analysis
     • Business Questions
     • Information Needs Priorities
     • Data Warehouse Subject Model
     • Fact/Qualifier Matrix
     • Target Data Store Configuration
     • Source Data Subjects & Source Data Composition
     • Metadata Requirements

   • Technology Architecture

   • Project Architecture
     •Planning for Incremental Implementation
     • Project Dependency
     • Project Decomposition
     • Timebox Techniques

   • Organizational Architecture

     • Deployment and Operations Planning
     • Training Plan
     • Support Plan
     • Communication Plan

Module Three

   Data Warehouse Implementation

   • Implementation Planning
     • Incremental Projects
     • Architectural Adjustments
     • Balancing Time, Resources, and Results

   • Warehousing Data Design
     • Logical Data Modeling
     • Relational Data Modeling
     • Dimensional Data Modeling
     • Structural Data Modeling
     • Adjusting for Time Requirements
     • Adjusting for Distribution & Security Requirements
     • Adjusting for Access & Navigation Requirements
     • Physical Design Considerations

   • Warehousing Process Design
     • Source/Target Maps
     • Data Transformation Concepts
     • Data Cleansing Concepts
     • Specifying Transformation Rules

   • Deployed Technology
     • Tool Installation
     • Technology Configuration
     • Connectivity and Access

   • Building the Data Warehouse Components
     • Data Acquisition & Load Processes
     • Ready-to-Use Databases
     • Business Analysis Applications
     • Operation Environment

   • Data Warehouse Deployment
     • Production Delivery
     • Training
     • Assigned Support Responsibilities
     • Published Policies and Procedures
     • Formal Warehouse Acceptance
     • Project Closure

Module Four

   Data Warehouse Operation

   • Business Services
     • Valuable and Sustainable Services
     • Service Environment & Culture

   • Data Warehouse Administration
     • Data Refresh
     • Managed Platforms
     • Managed Environment
     • Customer Service

   • Managed Quality

   • Managed Infrastructure

Module Five

   Summary & Conclusions

   • Common Mistakes

   • References & Resources

Course Cost                             $ 750.00


Innovative Logic’s service offerings are categorized within our four core competencies - Strategic Consulting, Data Warehousing, Business Intelligence, and Data Management. Together these four competency areas enable us to provide our clients with a strategic approach to address enterprise or departmental information integration and delivery needs by leveraging appropriate technologies and making the best business choices...

Business Intelligence (BI) is insight – insight into information that is required to make sound business decisions. BI is a key component of a successful data warehouse endeavor...

The definition of a data warehouse has taken on many meanings and interpretations throughout the years. But at its core, a data warehouse represents a consolidated view of an entity's data...

Unlike many modern methodologies, Innovative Logic Inc. has taken the extra, and unique, step of turning the "theory" into actual deliverables.