Creating and Using Data Warehouses Download the archived PDF Table of contents Creating and Using Data Warehouses Overview SQL Server 2000 Tools for Data Warehouses Parts of a Data Warehouse Data Marts Relational Databases Data Sources Data Preparation Area Presentation Services End-User Analysis Creating a Data Warehouse Designing a Data Warehouse Using Dimensional Modeling Fact Tables Aggregation Tables Dimension Tables Indexes Creating the Data Preparation Area Creating the Data Warehouse Database Extracting Data from Operational Systems Cleansing and Transforming Data Loading Data into the Data Warehouse Database Preparing Presentation Information Distributing Data to Data Marts Using a Data Warehouse SQL Queries OLAP and Data Mining English Query Microsoft Office 2000 Web Access and Reporting Offline OLAP Cubes Third-Party Applications Custom Applications Maintaining a Data Warehouse Updating Data Warehouse Data Scheduling Data Updates Synchronizing OLAP Cubes Updating Data Marts Administering a Data Warehouse Backing Up Data Warehouse Data Automating Data Warehouse Tasks Tuning Data Warehouse Performance next page