Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which Microsoft SQL Server 2000 features can I use for building cubes and performing data analysis?

April 26, 2017analysis building Cubes Data features Microsoft Performing SQL Server

0

Posted

Which Microsoft SQL Server 2000 features can I use for building cubes and performing data analysis?

1 Answer

0

Posted

A. Cubes can be built and managed with Analysis Services. Analysis Services is included with the Enterprise, Standard, and Developer editions of SQL Server 2000. For more information on the capabilities of SQL Server and Analysis Services, see the SQL Server 2000 Web site. Regarding data analysis, the Microsoft Data Analyzer allows you to perform detailed analysis of multidimensional data; publish and share data with other Microsoft Office products including Microsoft Excel, Microsoft PowerPoint, or to the Web; and query and filter your data to get just the information you need. Data Analyzer is also tightly integrated with Microsoft Analysis Services, which enables improved database analysis capabilities. See the Data Analyzer Web site for more information.