Regular readers know we stress the importance of focusing on business requirements when designing dimensional data models to support the data warehouse/business intelligence (DW/BI) environment. As described in Design Tip #157, it is critical to include business partners in the dimensional design process. But including business representatives on the design team obviously increases the size […]
Yearly Archives: 2013
Our website and books are loaded with guidance about designing dimensional models for the data warehouse/business intelligence (DW/BI) presentation area. But dimensional modeling concepts go beyond the design of databases that are simple and fast. You should think dimensionally at other critical junctures of a DW/BI project. When gathering requirements for a DW/BI initiative, you […]
The Kimball Group has always stressed the importance of keeping a keen eye on the business requirements when designing dimensional data models for the data warehouse/business intelligence (DW/BI) environment. Gathering business requirements is typically undertaken just prior to beginning the dimensional data model design process. Design Tip #110 is a reminder of requirements gathering do’s […]
Many organizations are embracing agile development techniques for their DW/BI implementations. While we strongly concur with agile’s focus on business collaboration to deliver value via incremental initiatives, we’ve also witnessed agile’s “dark side.” Some teams get myopically focused on a narrowly-defined set of business requirements. They extract a limited amount of source data to develop […]
Keeping tight control over the scope of your data warehouse/business intelligence (DW/BI) program is an important ingredient for success. Surprisingly, in some organizations it’s equally important to ensure that the program doesn’t suffer the theft of its scope after an otherwise good plan has been developed. It’s nearly impossible to tackle everything at once in […]
Ralph introduced the concept of slowly changing dimension (SCD) attributes in 1996. Dimensional modelers, in conjunction with the business’s data governance representatives, must specify the data warehouse’s response to operational attribute value changes. Most Kimball readers are familiar with the core SCD approaches: type 1 (overwrite), type 2 (add a row), and type 3 (add […]