Categories
Data Warehouse

Have You Built Your Audit Dimension Yet?

One of the most effective tools for managing data quality and data governance, as well as giving business users confidence in the data warehouse results, is the audit dimension. We often attach an audit dimension to every fact table so that business users can choose to illuminate the provenance and confidence in their queries and reports. Simply put, the audit dimension elevates metadata to the status of ordinary data and makes this metadata available at the top level of any BI tool user interface.

via Design Tip #164 Have You Built Your Audit Dimension Yet? – Kimball Group.

Categories
Data Warehouse

Dimensional Modeling Techniques – Kimball Group

Ralph Kimball introduced the data warehouse/business intelligence industry to dimensional modeling in 1996 with his seminal book, The Data Warehouse Toolkit.  Since then, the Kimball Group has extended the portfolio of best practices.Drawn from The Data Warehouse Toolkit, Third Edition, the “official” Kimball dimensional modeling techniques are described on the following links and attached .pdf:

via Dimensional Modeling Techniques – Kimball Group.

Categories
Uncategorized

Extreme Status Tracking For Real Time Customer Analysis

Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.

via IntelligentEnterprise : Kimball University: Extreme Status Tracking For Real Time Customer Analysis (printable version).

Categories
Data Warehouse

Practical Steps for Designing a Dimensional Model

What does it take to develop a robust dimensional model? Here's how to get from requirements-gathering to final approval in a process that will ferret out the good, bad and ugly realities of your source data and help you avoid surprises, delays and cost overruns.

via IntelligentEnterprise : Kimball University: Practical Steps for Designing a Dimensional Model (printable version).

Categories
Data Warehouse

Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3

How do you deal with changing dimensions? Hybrid approaches fill gaps left by the three fundamental techniques

via IntelligentEnterprise : Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3 (printable version).

Categories
Data Warehouse

The 10 Essential Rules of Dimensional Modeling

Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and youll confuse users and run into data warehousing brick walls.

via IntelligentEnterprise : Kimball University: The 10 Essential Rules of Dimensional Modeling printable version.