Agile Data Warehouse Design

Agile Data Warehouse Design

Released November 2015
Publisher(s): Infinite Skills
ISBN: 9781771374095

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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
    2. About The Author
    3. What Is A Data Warehouse?
    4. Comparing Operational Applications And Data Warehouses
  2. Data Warehouse Overview
    1. Development Approach
    2. Data Sources
    3. Staging Tables
    4. Data Warehouse Model
    5. Data Warehouse Design
    6. Data Warehouse Data
    7. End User Access, Old Data, And Metadata Management
    8. Introduction To The Case Study
  3. Data Sources
    1. Data Modeling Review - Part 1
    2. Data Modeling Review - Part 2
    3. Data Sources Overview
    4. Source Data: Menu Definition
    5. Source Data: Miscellaneous Metadata
    6. Source Data: Customer Order
    7. Source Data: Customer Account
    8. Source Data: Customer Prospect
    9. Source Data: Vendor Procurement
    10. Case Study: Assess Source Data
  4. Staging Tables
    1. Staging Tables Overview
    2. Case Study: Create Staging Model
  5. Data Warehouse Modeling Basics
    1. The Star Schema
    2. Dimension
    3. Fact
    4. Surrogate Keys
    5. The Bus Architecture
    6. Dimensional Modeling And Agile Development
    7. Practical Tips
    8. Self Assessment Test
    9. Case Study: Business Requirements
    10. Case Study: Bus Architecture
  6. Recurrent Dimensions
    1. Date
    2. Time
    3. Customer
    4. Account
    5. Employee
    6. Unit of Measure
    7. Product
    8. Currency
    9. Audit
    10. Case Study: Initial Warehouse Model - Part 1
    11. Case Study: Initial Warehouse Model - Part 2
    12. Case Study: Initial Warehouse Model - Part 3
  7. DW Modeling - Advanced Dimension
    1. Kinds of Conformed Dimensions
    2. Junk Dimension
    3. Degenerate Dimension
    4. Slowly Changing Dimension - Part 1
    5. Slowly Changing Dimension - Part 2
    6. Snowflake, Outrigger, and Bridge
    7. Swappable Dimension
    8. Master Dimension
    9. Hierarchy
    10. Practical Tips
    11. Self Assessment Test
    12. Case Study: Elaborate Dimensions
  8. DW Modeling - Advanced Fact
    1. Kinds Of Facts
    2. Transaction Fact
    3. Periodic Snapshot
    4. Accumulating Snapshot
    5. Aggregate Fact
    6. Consolidated Fact
    7. Practical Tips
    8. Case Study: Elaborate Facts
  9. Data Warehouse Modeling Recap
    1. Warehouse Modeling Review
    2. Common Warehouse Modeling Mistakes
  10. Data Warehouse Design
    1. Conceptual, Logical, Physical Models
    2. System Attributes - Part 1
    3. System Attributes - Part 2
    4. Data Types And Domains
    5. Nullability
    6. Constraints
    7. Data Warehouse Tuning - Part 1
    8. Data Warehouse Tuning - Part 2
    9. Views - Part 1
    10. Views - Part 2
    11. Miscellaneous Aspects Of Design
    12. Practical Tips
    13. Self Assessment Test
    14. Case Study: Create Staging SQL
    15. Case Study: Execute Staging SQL
    16. Case Study: Create Warehouse SQL
    17. Case Study: Execute Warehouse SQL
  11. Data Warehouse Data
    1. Warehouse Data Overview
    2. Source-To-Target Mappings
    3. Data Profiling
    4. Loading Staging Tables - Part 1
    5. Loading Staging Tables - Part 2
    6. Loading The Date and Time Dimensions - Part 1
    7. Loading The Date and Time Dimensions - Part 2
    8. Initial Warehouse Loading: Dimensions
    9. Initial Warehouse Loading: Facts
    10. Updating The Warehouse
    11. Warehouse Data Processing And Agile Development
    12. Case Study: Load Warehouse Data
  12. End User Access
    1. End User Access Overview
    2. Case Study: Analyze Data - Part 1
    3. Case Study: Analyze Data - Part 2
  13. Data And Metadata Management
    1. Offload Of Old Data
    2. Metadata Management
  14. Conclusion
    1. Course Wrap-Up

Product information

  • Title: Agile Data Warehouse Design
  • Author(s):
  • Release date: November 2015
  • Publisher(s): Infinite Skills
  • ISBN: 9781771374095