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

Data Warehousing

Video Description

This video will show you how to build and maintain a data warehouse. The data warehouse is the single version of the truth. Learn about the different types of data warehouses such as geographically distributed data warehouses, exploration data warehouses, and global data warehouses. We reveal the critical success factors necessary for a data warehouse. We explore how to build a robust architecture including staging areas, system of records, data marts, data warehouse monitors, and the resource governor. We discuss data warehouse project management including milestones and methodology. We explore how to handle non-traditional data in a warehouse, such as documents, profile records, and dormant data. We cover how data warehousing relates to other enterprise initiatives such as Customer Relationship Management (CRM), Operational Data Stores (ODS), and Enterprise Resource Planning (ERP). We go through many examples, including a train company, steel company, and communications company. We discuss the various types of users of the data warehouse, including Farmers, Miners, Explorers, and Tourists.