Data Warehousing Fundamentals: 
A Roadmap to Success
Pia Kankkunen, Consultant, SMG Finland
 

This course, designed for beginners and novices of data warehousing, examines and establishes the fundamental theories, concepts, techniques and terminology that are essential for every business and information technology professional. Students are introduced to best practice approaches and structures for data warehouse development and implementation. Common definitions and characteristics of data warehouses, data warehousing architectures, readiness issues and mistakes to avoid also receive special emphasis.

This course concentrates on data warehousing deliverables independently of any specific methods, but within the framework of best practices. It focuses on understanding deliverables that may be produced throughout the data warehousing process and discusses reasons for producing them.

This course closes with exploration of practical next steps the student can take. These include steps to further develop knowledge and skills, to position oneself for success and to get started with data warehousing.

TOPICS INCLUDE:

• Data Warehousing Fundamentals — Concepts and Definitions
• Data Warehousing Processes — Components and Alternative Structures
• Data Warehousing Success Factors
• Deliverables of Data Warehouse Architecture
• Deliverables of Data Warehouse Implementation
• Deliverables of Data Warehouse Operation
• Starting and Sustaining a Data Warehousing Initiative

Upon completion of this course, students will be able to: 
 

• Understand the fundamental concepts, terminology, and processes of data warehousing. 
• Use this prerequisite knowledge and understanding to obtain maximum value from other TDWI educational offerings. 
• Identify success and risk factors of data warehousing. 
• Identify classes of data warehousing technology. 
• Describe the deliverables of data warehouse architecture, implementation, and operation. 
• Place deliverables within the context of a comprehensive data warehousing process. 
• Understand associations and dependencies among data warehousing deliverables. 
• Make informed judgments about the importance of each deliverable. 
• Take practical steps to begin a successful data warehousing effort.

AGENDA:

• Introduction to data warehousing
• Project oriented deliverables
• Implementation deliverables
• Operation deliverables
• Next steps to data warehousing

DATA WAREHOUSING FUNDAMENTALS KIT
Attendees of this course will receive TDWIs Fundamentals Kit, which includes: course material, Glossary, Case Study Summaries, Readiness Survey, TDWI Process Flyer, Best Practices Summaries and other quick start reference materials.