Microsoft Office 2000

Creating and Using Data Warehouses

Creating and Using Data Warehouses

Microsoft Office 2000

Data warehouse data in a Microsoft® SQL Server™ 2000 database can be accessed by Microsoft Office components such as Microsoft Excel or Microsoft Access. However, the volume of data in most data warehouses often dictates that special queries or data tables be created and maintained to support the use of these components by end users. Such special queries and tables must be created and maintained as part of the data warehouse.

One exception is the integration of Excel PivotTables® with SQL Server 2000 Analysis Services. When Analysis Services is used to create and manage OLAP data, end users can easily connect to cubes through an Analysis server and analyze data online or create cubes on their local computer for offline use. For more information, see the Microsoft Office 2000 documentation.