Tags » Data Warehouse Architecture

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.  31 more words

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

Basis Data

Data warehouse Architecture

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

Data Warehouse Architecture (Basic): 136 more words