Data Warehousing at SQL Book

This series of articles introduces the main concepts, aims and requirements of building a data warehouse to service your organisations needs.

An Introduction to Data Warehouses and Data Warehousing
The terms Data Warehouse and Data Warehousing are used frequently today but can cover a wide range of concepts and processes. This article aims to give an introduction to the different areas of Data Warehousing.

Considering the business requirements of the Data Warehouse
An Introduction to Data Warehouses and Data Warehousing Part 2 - Considering the business requirements of the Data Warehouse

Designing the Data Warehouse structure - Dimensional Modelling
After analysing business requirements of the Data Warehouse the next stage in building the Data Warehouse is to design the logical model using dimensional modelling.

ETL - Extract Transform Load
The Extract Transform Load (ETL) design process is perhaps the most time consuming stage of the Data Warehouse project. This article outlines the main ideas and processed that are undertaken by ETL.

Find scripts here that perform common data warehousing tasks, such as ETL routines, creation of dimension tables etc.

SQL script for creating date dimension table for a data warehouse
Almost all data warehouses enable the user to analyse and summarize data in sectors of time. This article demonstrates a SQL script that can be used to create and populate a date dimension table.

SQL script for data cleaning peoples names to be the correct case
Data warehouse data may contain names in different formats, e.g. all upper case, all lower case, capitalised first letter, mixed case etc. This article demonstrates a data cleaning SQL script that 'repairs' these different name formats.