WEEK 1 DISCUSSION NOTES

Topic: Introduction to Data Warehousing

1.0 Learning Objectives

By the end of this topic, students should be able to:

• Define data warehousing and data warehouses.

• Explain the characteristics of a data warehouse.
• Describe the architecture and components of a data warehouse.
• Differentiate between operational databases and data warehouses.
• Explain the importance and applications of data warehousing.

2.0 Introduction

Organizations generate large amounts of data every day from transactions, websites, mobile
applications, and business operations. Managing and analyzing this data is important for
effective decision-making. Data warehousing provides a centralized system for storing and
analyzing data from multiple sources.

A data warehouse helps organizations transform raw data into meaningful information for
strategic planning, forecasting, reporting, and business intelligence.

3.0 Definition of Data Warehousing

Data warehousing is the process of collecting, integrating, storing, and managing data from
multiple sources to support business analysis and decision-making.

A data warehouse is a centralized repository that stores historical and integrated data for
analysis and reporting purposes.

According to Bill Inmon, a data warehouse is:

“A subject-oriented, integrated, time-variant, and non-volatile collection of data in support of

management’s decision-making process.”

4.0 Characteristics of a Data Warehouse

4.1 Subject-Oriented

A data warehouse is organized around major business subjects such as:

• Sales
• Customers
• Products
• Finance

Unlike operational databases that focus on daily transactions, data warehouses focus on
analysis by subject area.

1
4.2 Integrated

Data from different systems and departments is combined into a consistent format.

Example:

• Different departments may store customer gender as:

o “M/F”
o “Male/Female”
o “1/0”

In the data warehouse, this information is standardized.

4.3 Time-Variant

Data warehouses store historical data over long periods.

Example:

• Sales records from the last 5 years can be analyzed to identify trends.

This helps organizations perform forecasting and trend analysis.

4.4 Non-Volatile

Data in a warehouse is stable and not frequently updated or deleted.

Once data is loaded:

• It is mainly used for querying and analysis.

• It remains unchanged for consistency.

5.0 Operational Databases vs Data Warehouses

Operational Database (OLTP) Data Warehouse (OLAP)

Supports daily operations Supports decision-making
Current data Historical data
Highly normalized Usually denormalized
Frequent updates Periodic updates
Fast transaction processing Complex analytical queries

6.0 Components of a Data Warehouse

6.1 Data Sources

These are systems that provide raw data:

2
 • Transactional databases
• ERP systems
• CRM systems
• Web applications
• External data sources

6.2 ETL Process

ETL stands for:

• Extraction
• Transformation
• Loading

Extraction

Data is collected from various sources.

Transformation

Data is cleaned, standardized, and converted into a usable format.

Loading

Processed data is stored in the warehouse.

6.3 Data Storage

This is the central repository where integrated data is stored for analysis.

6.4 Metadata

Metadata describes the structure and meaning of data.

It provides information about:

• Data source
• Format
• Relationships
• Data definitions

6.5 OLAP Tools

Online Analytical Processing (OLAP) tools help users:

• Analyze data
• Generate reports
• Perform multidimensional analysis

Examples:

3
 • Slice and dice
• Drill-down
• Roll-up

6.6 Reporting and Visualization Tools

These tools help users visualize and interpret data.

Examples:

• Power BI
• Tableau
• Google Data Studio

WEEK 1 QUIZ – SET 1

Section A: Short Answer Questions

1. Define a data warehouse.

2. State four characteristics of a data warehouse.
3. Differentiate between OLTP and OLAP systems.
4. Explain the ETL process.
5. What is metadata?