Data Warehouse Sizing Calculator

A data warehouse is a specialized database that is optimized for analysis, reporting and decision support at both the tactical and strategic levels. Data warehouses make sense because the data in production systems –  such as ERP systems – is stored and managed in ways that make analysis difficult. Creating new reports is therefore a time-consuming process that requires highly trained programmers who know how and where to access the required data. In contrast, with a data warehouse the process of creating new reports is relatively quick and easy, and can be done by department-level users with no need to involve the IT department. Sometimes the content of a data warehouse is partitioned by function into department-specific databases, often referred to as “data marts.”

This Data Warehouse Sizing Calculator helps you estimate the memory size required for a data warehousing project involving data from as many as 5 business units, each with as many as 5 relevant DBs, and each DB with as many as 10 relevant fields.

The process for using this calculator is as follows:

Step 1: Determine which business units will be contributing data.

Step 2: Identify which DBs controlled by that business unit have relevant data.

Step 3: Within each DB, identify the relevant rows.

Step 4: Determine the average length (number of characters) in each of these rows.

Step 5: Enter the data.

The attached Zip file includes:

• Intro Page.doc

• Cover Sheet and Terms.pdf

• Data Warehouse Sizing Calculator.xls

Related Knowledge Network Content

•Data Warehousing For Dummies Excerpt

•Data Warehousing ETL Checklist

•Ten Worst Practices of the Unsuccessful Data Warehouse Project Manager