---
title: "Importance, uses and characteristics of DW"
subject: "Data Mining"
chapter: 1
key: "semester_7/data_mining:dw-importance-uses-characteristics"
source: https://www.bctengineer.com/q/semester_7/data_mining/dw-importance-uses-characteristics
site: BCT Engineering
---

# Importance, uses and characteristics of DW

Data Mining · Chapter 1: Introduction

- Asked in: year not given, 2+2+6 marks
- Video: [Lec - 2: Introduction to Data Warehouse🏺 with Examples](https://www.youtube.com/watch?v=NphMcnU8ymU) — Gate Smashers
- Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14
- Page: https://www.bctengineer.com/q/semester_7/data_mining/dw-importance-uses-characteristics
- Whole chapter: https://www.bctengineer.com/md/semester_7/data_mining/chapter-1

## Question

Explain the importance and uses of Data Warehouse with its characteristics.

## Short answer

A data warehouse integrates historical data from disparate sources, providing a consistent view for analysis; it is subject-oriented, integrated, time-variant, and non-volatile. It is used for reporting, OLAP, data mining, and trend forecasting, aiding decisions in banking, retail, and healthcare.

## Answer

#### Importance
- Gives a single, integrated, consistent view of the whole organisation's data.
- Supports faster and better decisions with historical data.
- Keeps heavy analysis away from operational systems, which stay fast.
- Improves data quality through cleaning and standardisation.
- Provides a competitive advantage: finding trends, customer needs and new opportunities.
- Gives high return on investment through better planning and cost control.

#### Uses
- Reporting and executive dashboards.
- OLAP: multidimensional analysis such as sales by region, product and time.
- Data mining: segmentation, prediction, association analysis and fraud detection.
- Trend analysis and forecasting; budgeting and planning.
- Examples: retail (market basket), banking (risk), telecom (churn), health (outcomes), government (planning).

#### Characteristics
- **Subject-oriented**: organised around major subjects such as customer, product, sales, not around day-to-day operations.
- **Integrated**: data from many sources is made consistent in naming, units, formats and encoding.
- **Time-variant**: data is kept as historical snapshots (5-10 years); every record has a time element.
- **Non-volatile**: data is loaded and read, but not updated or deleted in place; only refreshed periodically.
- **Large volume** of historical data, stored in dimensional form.
- **Decision-support oriented**: optimised for read-heavy, complex queries.

## Check yourself

The answer's key points as multiple-choice questions, with the correct option and why.

1. Why does a warehouse keep operational systems fast?
   A. It deletes operational data
   B. It runs heavy analysis away from operational systems
   C. It reduces users
   D. It replaces them
   Answer: B. Analysis is offloaded to the warehouse. (Key point: Importance)

2. What does time-variant mean?
   A. Data has no dates
   B. Data is kept as historical snapshots and every record has a time element
   C. Data is overwritten daily
   D. Only today's data is stored
   Answer: B. Warehouses hold 5-10 years of snapshots with time elements. (Key point: Time-variant)

3. What does integrated mean?
   A. Data is encrypted
   B. Data is summarised only
   C. Data from many sources is made consistent in naming, units, formats and encoding
   D. Data stored in one file
   Answer: C. Integration removes inconsistencies between sources. (Key point: Integrated)

## Related in Data Mining

- [Data warehouse and its characteristics](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-define-characteristics) — Data Mining, chapter 1
- [DW characteristics vs operational database](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-characteristics-vs-operational) — Data Mining, chapter 1
- [Data mining vs DW and applications](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adm-vs-dw-applications) — Data Mining, chapter 1
- [Data warehouse, data mart and need](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Awarehouse-datamart-need) — Data Mining, chapter 1
- [Data warehouse architecture and components](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-architecture-components) — Data Mining, chapter 1
- [Data warehouse schemas](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Adw-schema-types) — Data Mining, chapter 1

## Related in other subjects

- [Data warehouse and data mining](https://www.bctengineer.com/question.md?key=semester_8%2Finformation_system%3Adata-warehouse-data-mining) — Information System, chapter 4, asked 2×
- [Hybrid data in big data warehouse](https://www.bctengineer.com/question.md?key=semester_8%2Fbig_data_technologies%3Ahybrid-data-warehouse) — Big Data Technologies, chapter 1
- [Explosive characteristics; TNT preparation and uses](https://www.bctengineer.com/question.md?key=semester_2%2Fengineering_chemistry%3Aexplosive-characteristics-tnt) — Engineering Chemistry, chapter 7
- [Contour characteristics and uses of contour map](https://www.bctengineer.com/question.md?key=semester_4%2Fsurveying_ii%3Acontour-characteristics-uses) — Surveying II, chapter 4