O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Agile Data Warehouse Design

Video Description

In this Agile Data Warehouse Design training course, expert author Michael Blaha will teach you how to model and design a data warehouse. This course is designed for users that are already familiar with data warehouses.

You will start with a data warehouse overview, then jump into learning about data sources, such as customer order, customer account, and vendor procurement. From there, Michael teaches you about staging tables, basic data warehouse modeling, recurrent dimensions, and advanced dimension data warehouse modeling. This video tutorial also covers data warehouse design, data warehouse data, and end user access. Finally, you will learn about metadata management.

Once you have completed this computer based training course, you will be fully capable of modeling and designing your own data warehouse.

Table of Contents

  1. Getting Started
    1. About The Course 00:02:38
    2. About The Author 00:02:54
    3. What Is A Data Warehouse? 00:03:52
    4. Comparing Operational Applications And Data Warehouses 00:04:31
  2. Data Warehouse Overview
    1. Development Approach 00:03:07
    2. Data Sources 00:02:26
    3. Staging Tables 00:01:29
    4. Data Warehouse Model 00:06:57
    5. Data Warehouse Design 00:03:08
    6. Data Warehouse Data 00:02:42
    7. End User Access, Old Data, And Metadata Management 00:01:21
    8. Introduction To The Case Study 00:01:54
  3. Data Sources
    1. Data Modeling Review - Part 1 00:04:49
    2. Data Modeling Review - Part 2 00:03:29
    3. Data Sources Overview 00:02:04
    4. Source Data: Menu Definition 00:02:12
    5. Source Data: Miscellaneous Metadata 00:01:51
    6. Source Data: Customer Order 00:02:16
    7. Source Data: Customer Account 00:01:37
    8. Source Data: Customer Prospect 00:00:31
    9. Source Data: Vendor Procurement 00:01:58
    10. Case Study: Assess Source Data 00:06:36
  4. Staging Tables
    1. Staging Tables Overview 00:03:58
    2. Case Study: Create Staging Model 00:05:13
  5. Data Warehouse Modeling Basics
    1. The Star Schema 00:06:10
    2. Dimension 00:03:27
    3. Fact 00:05:03
    4. Surrogate Keys 00:03:36
    5. The Bus Architecture 00:02:53
    6. Dimensional Modeling And Agile Development 00:01:02
    7. Practical Tips 00:02:44
    8. Self Assessment Test 00:06:40
    9. Case Study: Business Requirements 00:05:04
    10. Case Study: Bus Architecture 00:04:43
  6. Recurrent Dimensions
    1. Date 00:05:45
    2. Time 00:02:53
    3. Customer 00:05:48
    4. Account 00:01:41
    5. Employee 00:03:15
    6. Unit of Measure 00:03:20
    7. Product 00:02:45
    8. Currency 00:02:39
    9. Audit 00:01:14
    10. Case Study: Initial Warehouse Model - Part 1 00:06:02
    11. Case Study: Initial Warehouse Model - Part 2 00:03:58
    12. Case Study: Initial Warehouse Model - Part 3 00:02:36
  7. DW Modeling - Advanced Dimension
    1. Kinds of Conformed Dimensions 00:01:45
    2. Junk Dimension 00:05:14
    3. Degenerate Dimension 00:05:19
    4. Slowly Changing Dimension - Part 1 00:07:40
    5. Slowly Changing Dimension - Part 2 00:05:32
    6. Snowflake, Outrigger, and Bridge 00:04:24
    7. Swappable Dimension 00:02:17
    8. Master Dimension 00:01:26
    9. Hierarchy 00:07:03
    10. Practical Tips 00:02:36
    11. Self Assessment Test 00:09:10
    12. Case Study: Elaborate Dimensions 00:03:18
  8. DW Modeling - Advanced Fact
    1. Kinds Of Facts 00:01:30
    2. Transaction Fact 00:02:28
    3. Periodic Snapshot 00:01:32
    4. Accumulating Snapshot 00:01:51
    5. Aggregate Fact 00:01:36
    6. Consolidated Fact 00:01:06
    7. Practical Tips 00:01:10
    8. Case Study: Elaborate Facts 00:04:23
  9. Data Warehouse Modeling Recap
    1. Warehouse Modeling Review 00:01:47
    2. Common Warehouse Modeling Mistakes 00:02:42
  10. Data Warehouse Design
    1. Conceptual, Logical, Physical Models 00:00:55
    2. System Attributes - Part 1 00:06:22
    3. System Attributes - Part 2 00:04:57
    4. Data Types And Domains 00:07:34
    5. Nullability 00:09:52
    6. Constraints 00:03:03
    7. Data Warehouse Tuning - Part 1 00:03:38
    8. Data Warehouse Tuning - Part 2 00:08:57
    9. Views - Part 1 00:09:24
    10. Views - Part 2 00:05:03
    11. Miscellaneous Aspects Of Design 00:02:40
    12. Practical Tips 00:01:49
    13. Self Assessment Test 00:04:48
    14. Case Study: Create Staging SQL 00:02:15
    15. Case Study: Execute Staging SQL 00:07:28
    16. Case Study: Create Warehouse SQL 00:07:45
    17. Case Study: Execute Warehouse SQL 00:01:26
  11. Data Warehouse Data
    1. Warehouse Data Overview 00:01:59
    2. Source-To-Target Mappings 00:12:18
    3. Data Profiling 00:12:55
    4. Loading Staging Tables - Part 1 00:10:38
    5. Loading Staging Tables - Part 2 00:07:53
    6. Loading The Date and Time Dimensions - Part 1 00:11:07
    7. Loading The Date and Time Dimensions - Part 2 00:05:32
    8. Initial Warehouse Loading: Dimensions 00:13:29
    9. Initial Warehouse Loading: Facts 00:15:30
    10. Updating The Warehouse 00:02:07
    11. Warehouse Data Processing And Agile Development 00:01:55
    12. Case Study: Load Warehouse Data 00:01:50
  12. End User Access
    1. End User Access Overview 00:04:29
    2. Case Study: Analyze Data - Part 1 00:12:50
    3. Case Study: Analyze Data - Part 2 00:10:34
  13. Data And Metadata Management
    1. Offload Of Old Data 00:02:07
    2. Metadata Management 00:02:43
  14. Conclusion
    1. Course Wrap-Up 00:04:42