Designed for use by database administrators and application developers, Analysis Services lets anyone with SQL and Microsoft Visual Basic programming experience use OLAP tools to create custom analysis applications. Integrated data mining services will help your company sift through large data sets to uncover hidden patterns and make valuable predictions about future business trends. In combination with Microsoft Commerce Server, SQL Server 2000 will store and analyze click-stream data collected from the Web. In addition to enabling you to extend your analysis capabilities to partners outside the firewall, these features deliver new value by creating opportunities to sell access to your database to new customers over the Web. Closed Loop Analysis.
Analysis is one thing.
Microsoft OLAP Actions, a new feature of Analysis Services, extends the power of business analysis with new functionality that allows knowledge workers to take the conclusions they reach and use them to automatically drive business processes. Great Scalability, Incomparable Performance Recognizing that scalability and performance are among the most critical issues that database administrators face today, the SQL Server 2000 development team focused heavily on building new features into this version of SQL Server that guarantee outstanding speed and scalability. Evidence of their success is found in industry-standard benchmark tests, which demonstrate convincingly that SQL Server 2000 supports more users, handles more queries in less time, and achieves better scalability, all while running on incredibly affordable systems. Under the most demanding reporting scenarios, indexed views can mean dramatic performance gains. Data Transformation Services.