SQL2000 Decision Analysis - OLAP Setup and Application

Author: Lin Hongyu
Publisher:
Publish Date: 2001-08-01
Features: In recent years, the concept and technology of Knowledge Databases (Knowledge Database-KDD) have become popular, leading to the emergence of many concepts and corresponding software tools. The processing capabilities and acquisition costs of these tools vary significantly. This book guides you on how to leverage existing database servers and software tools to establish an internal database analysis mechanism for your enterprise by using Analysis Services in Microsoft SQL Server 2000, along with front-end analysis tools like Excel and Web. The author begins with the concept of data warehousing and gradually leads users through the process of building OLAP analysis databases, establishing multidimensional data cubes, and data mining models. It explains how to use front-end analysis tools such as Excel and Web to analyze the results. This allows you not only to process the data required for decision analysis in the least amount of time but also to obtain various analysis results as the best reference for business decisions.