Consistent data is the Holy Grail for most data warehouse initiatives, and data stewards are the crusaders who fearlessly strive toward that goal. An active data stewardship program identifies, defines and protects data across the organization. Stewardship ensures the initial effort to populate the data warehouse is done correctly, while significantly reducing the amount of […]
Business Intelligence and Data Warehouse Articles
With the current industry buzz focused on master data management (MDM), it’s time to revisit one of the most critical elements of the Kimball method. Back in 1999, Ralph Kimball wrote an Intelligent Enterprise column entitled The Matrix. The 1999 movie of the same name spawned two sequels, but we haven’t devoted a column to […]
Alan Alda is still widely known as “Hawkeye” Pierce from the hit television series “M*A*S*H” but he’s also the long-time host of the PBS series “Scientific American Frontiers,” in which he interviews research scientists. Discussing his 11-year hosting stint on National Public Radio recently, Alda described his approach for eliciting information from brilliant scientists. His […]
How do you deal with changing dimensions? Hybrid approaches fill gaps left by the three fundamental techniques. Unlike most OLTP systems, a major objective of a data warehouse is to track history. So, accounting for change is one of the analyst’s most important responsibilities. A sales force region reassignment is a good example of a […]
Do you know the difference between dimensional modeling truth and fiction? According to Merriam-Webster, fables are fictitious statements. Unfortunately, fables about dimensional modeling circulate throughout our industry. These false claims and assertions are a distraction, especially if you’re trying to align a team. In this column, we’ll describe the root misunderstandings that perpetuate these myths so […]
Business acceptance is a bigger problem than BI/DW professionals want to admit. Here’s how to get on the right track. A recent Data Warehouse Designer column, “Data Warehouse Check-Ups” (June 12, 2004), discussed the importance of regularly casting a critical eye over your data warehouse/business intelligence (DW/BI) program. Check-ups identify early warning signs and symptoms so appropriate […]
Periodic check-ups will help you avoid letting business intelligence and data warehousing problems spin out of control. It’s human nature to resist visiting a doctor for periodic check-ups. Generally, we’d prefer to avoid being poked and prodded, having our vital signs taken, and then being told that we need to quit smoking, exercise more, or […]
The Kimball bus architecture and the Corporate Information Factory: What are the fundamental differences? Based on recent inquiries, many of you are in the midst of architecting (or rearchitecting) your data warehouse. There’s no dispute that planning your data warehouse from an enterprise perspective is a good idea, but do you need an enterprise data […]
I worked at a company called Metaphor back in the early 1980s. As part of a startup software company introducing then-cutting-edge concepts (such as folders, file drawers, and workflows on a graphical electronic desktop), I appreciated the benefits of using metaphors to represent seemingly complex concepts. Effective verbal and visual metaphors are able to convert complexity into […]
Atomic fact tables are the core foundation of any analytic environment. Business analysts thrive on atomic details because they can be easily rolled up “any which way” by grouping on one or more dimension attributes. The robust dimensionality of atomic data is extremely powerful as it supports a nearly endless combination of inquiries. However, business […]