Tags » Data Warehouse Architecture

Universal Data Vault: Hyper-Generalized Data Vault -- Review of John Giles' Case Study

I recently came across an interesting data-modeling case study.  John Giles, who wrote it, is also the author of the insightful and — for us data geeks — entertaining book, ‘The Nimble Elephant’.  919 more words

Lean Thinking

Lean Data Warehouse via Data Vault

Today, businesses want a data warehouse to be Lean.  In contrast to many traditional data warehouses, a Lean Data Warehouse is simple, fast to deliver, automatable, free of over-complex dependencies,  adaptive to business change, and thus quickly profitable.  83 more words

Lean Thinking

Using Scoped Assignments with Periodic Snapshot Fact Tables

A common design approach to deal with something like store inventory, is to use periodic snapshot fact tables. You decide what grain (daily/weekly/monthly) you need, and build your periodic snapshot in the following manner: 730 more words

Business Intelligence

Data Warehouse (Part 2)

Pada postingan kali ini aku mau melanjutkan pembahasan tentang data warehouse yaitu tentang proses ETL (Extraction, transformation, load) dan arsitektur data warehouse. Postingan sebelumnya tentang definisi data warehouse, karakteristik data warehouse, kegunaan data warehouse serta perbedaan data warehouse dengan database bisa dilihat  386 more words


Data warehouse Architecture

The Data warehouse and it’s architecture varies depending upon the components included in its organization. Roughly we can classify into 3 types of architecture:

Data Warehouse Architecture (Basic): 135 more words

To stage or not to stage - that is the question

The question whether data should be staged when performing any ETL or import process is certainly not new, and there are probably as many opinions as there are people who have asked the question. 549 more words

Business Intelligence

Data Warehousing

In this Information Age, we are constantly flooded with information therefore its becomes very important to integrate all these data and transform this integrated data into a more useful data store, this is where Data Warehousing comes into the picture. 513 more words