End-User Analysis

Creating and Using Data Warehouses

Creating and Using Data Warehouses

End-User Analysis

Microsoft® SQL Server™ 2000 and its components provide an open environment for access to data warehouse data. This offers opportunities for independent software vendors to develop sophisticated data analysis and presentation applications for end users. Many third-party client applications that work with SQL Server 2000 and its components are available.

SQL Server 2000 also integrates well with Microsoft Office 2000 to provide end users with easy to use tools for analyzing data warehouse data. Using components of Microsoft Office 2000 you can query SQL Server 2000 databases to incorporate data warehouse data into Microsoft Excel spreadsheets, Microsoft Access databases, or other documents. Excel 2000 PivotTables® can connect directly to SQL Server 2000 Analysis Services cubes to explore data, and users can create local cubes to take with them when offline from the data warehouse.