Conversations with Data Warehouse Experts – Chris Webb

A Data Warehouse is a database that supports enterprise reporting and analysis. A well-designed data warehouse uses accepted data modelling and management techniques to provide an integrated data source that makes it easy to build reports and analyses. A data warehouse should exhibit the following four characteristics: At the heart of a data warehouse is…

Dimensional modeling is a data modeling technique used to model the presentation layer of a data warehouse. It focuses on delivering simplicity and query performance for the end user. It allows users to easily understand and navigate the data available for reporting and ad hoc analysis. A dimensional model supports high-performance aggregated queries and performs…

When faced with a new Enterprise Data Warehouse development, it’s hard to know where to start. Many people make the mistake of starting with some reporting requirements. Unfortunately, this leads to narrow silos that can’t accommodate new requirements. Initially, it’s better to anchor your high-level design to the core business processes of the business. If…