Introduction to Data Warehouse

Why take this course?

After completing this course, you will be able to
  • describe the characteristics of Data Warehouses that distinguish them from operational databases.
  • examine the architectural alternatives for implementing Data Warehouses and Data Marts.
  • recognize the benefits of using the RAD approach for Data Warehouse development.
  • understand the importance of Metadata in the success of the warehouse initiative.
  • assess the hardware and software architecture options to consider when implementing the warehouse.
  • make important decisions to resolve issues that affect the warehouse implementation and management.
1 Day : Fee - $ 697.00 (CAD) : ? Multi-seat - $ 497.00 (CAD)
Sorry, no classes are currently scheduled
Contact us to arrange your preferred location and date
This course explains the key concepts of Data Warehousing and examines the architectural choices, delivery techniques and enabling technologies that are most effective for Data Warehouse delivery.
Who should attend?
Business and systems analysts who plan to attend IB Learning's Data Warehouse Design Workshop as well as business managers who are responsible for planning and managing Data Warehouse projects, and other managers who want to know how Data Warehousing will help them.
Any prerequisites?
You don't need any experience in systems development, but a basic understanding of Information Technology would help.

What topics are covered?

Introduction
  • Today's Business
  • IT Challenges
  • Data Warehouse
Characteristics of a Data Warehouse
  • Role of Data Warehouse
  • Distinguishing Characteristics
  • Basic Characteristics
  • Data Marts
  • Information Distribution System
Data Architecture
  • Overview
  • Departmental Data Warehouse
  • Enterprise Data Warehouse
  • EDW with Dependent Data Marts
  • Selecting the Right Architecture
  • Data Warehouse Users
Methodology
  • Data Warehouse Development
  • Development Phases
Metadata
  • Introduction
  • Categories of Metadata
  • Examples
  • Metadata Repository
  • Practical Considerations
Technology Architecture
  • What is Technology Architecture?
  • A Typical DW Architecture
  • DW Technology Components
  • Extract/Transformation/Load Facility
  • Data Cleansing Facility
  • Staging Area
  • Metadata Repository
  • Data Storage
  • Database Alternatives
  • DW Technology Components
  • Latest Trend
Management and Implementation
  • Important Decisions
  • Critical Success Factors
  • Obstacles to Success
  • Team Dynamics
  • Team Composition
  • Monitoring the Data Warehouse
  • Selling the Concept