TDWI Data Warehousing Concepts and Principles: An Introduction to the Field of Data Warehousing

9:00 am - 5:00 pm

CBIP

Prerequisite: None

Preview Course Materials | Course Outline

This introductory-level course provides an overview of the activities, processes, and products involved in building a data warehouse. From business architecture to databases and access tools, the course examines the deliverables of data warehousing programs and discusses the resources and skills needed to produce them. While much of a data warehousing effort is expended in development projects, this course broadens the perspective from project to program and examines architecture and operations deliverables as well as those of development projects. The course emphasizes the common language, concepts, and understanding necessary to enable effective teamwork and achieve data warehousing success.

The data-to-value chain describes the transition from data to value as DATA —> INFORMATION —> KNOWLEDGE —> ACTION —> OUTCOME —> VALUE. This course focuses on those parts of the data-to-value chain that begin with data and end with information.

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