Kimball Approach To Data Warehouse Lifecycle ((install)) Jun 2026
Everything starts with business requirements. The Kimball team insists on dimensional bus matrix —a simple spreadsheet that maps business processes (e.g., "Order Fulfillment") to common dimensions (e.g., "Date," "Product," "Customer"). This matrix becomes the master plan. It identifies which data marts to build first based on business priority, not technical convenience.
You don't need to build everything at once. The first dimensional model pays for itself; each subsequent model adds value without breaking prior work. kimball approach to data warehouse lifecycle