documentation.HELP! Creating and Using Data Warehouses Documentation

Creating and Using Data Warehouses

Creating and Using Data Warehouses

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

Menu

  • Homepage

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

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.