Data Warehousing at SQL Book

An Introduction to Data Warehouses and Data Warehousing

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.

 

Data warehouse scripts

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.