Kimball Methodology

Bottom-up dimensional modeling for business intelligence

What is the Kimball Methodology?

The Kimball Methodology, developed by Ralph Kimball, is a bottom-up approach to data warehouse design that focuses on delivering business value quickly through dimensional modeling. It emphasizes building data marts for specific business processes that can be integrated through conformed dimensions.

At its core, Kimball's approach is business process-centric, organizing data around key business activities (like orders, shipments, or payments) rather than organizational departments. This methodology prioritizes usability, query performance, and rapid delivery of analytics capabilities.

Core Principles

Bottom-Up Development

Start with individual data marts addressing specific business processes. Each mart delivers immediate value and can be developed incrementally. Over time, these marts integrate into an enterprise-wide data warehouse through conformed dimensions.

Dimensional Modeling

Use star schemas with fact tables (measurements) surrounded by dimension tables (context). This denormalized structure optimizes query performance and makes data intuitive for business users to understand and navigate.

Business Process Focus

Organize data around business processes (events) rather than departments. A process like "Order Fulfillment" crosses multiple departments but represents a cohesive analytical subject requiring integrated data.

Conformed Dimensions

Shared dimensions across data marts ensure consistency and enable cross-process analysis. A customer dimension used in sales and service marts has identical structure and meaning, allowing unified reporting.

Dimensional Modeling Concepts

Star Schema Design
The foundation of Kimball dimensional modeling

A star schema consists of a central fact table containing measurements, surrounded by dimension tables providing descriptive context. The schema resembles a star with the fact table at the center.

Example: Sales Star Schema

Fact Table: Sales_Fact

date_key, product_key, customer_key, store_key, quantity, amount, cost

Dimension: Date

date_key, date, month, quarter, year, day_of_week

Dimension: Product

product_key, name, category, brand, SKU

Dimension: Customer

customer_key, name, segment, region, join_date

Dimension: Store

store_key, name, city, state, manager, size

Benefits of Star Schema:

  • Simple, intuitive structure easily understood by business users
  • Optimized for query performance with fewer joins
  • Supports flexible, ad-hoc analysis
  • Easily accommodates new dimensions and facts

Kimball Lifecycle Methodology

Project Implementation Approach

The Kimball Lifecycle is a comprehensive project management framework for data warehouse implementations:

1
1. Program/Project Planning

Define scope, resources, and overall project plan

2
2. Business Requirements Definition

Understand business processes, KPIs, and analytical needs

3
3. Technology Track

Design technical architecture, select tools, and infrastructure

4
4. Data Track

Design dimensional models, develop ETL processes, implement data quality

5
5. BI Application Track

Build reports, dashboards, and analytical applications

6
6. Deployment

Release to production, train users, and support adoption

7
7. Maintenance & Growth

Monitor, optimize, and expand based on evolving needs

Enterprise Bus Matrix
The Bus Matrix is a key planning tool in the Kimball methodology for managing conformed dimensions across the enterprise.

Advantages of Kimball Approach

Faster Time to Value
Bottom-up approach delivers working data marts quickly, providing immediate business value and ROI while building toward enterprise warehouse.
Business User Friendly
Dimensional models are intuitive and align with how business users think about data, reducing training needs and increasing adoption.
Query Performance
Denormalized star schemas with fewer joins deliver superior query performance compared to highly normalized structures.
Flexibility
Easy to add new dimensions, facts, and data marts without disrupting existing structures, supporting evolving business needs.