Microsoft SQL Server 2005 exercises leadership in the business intelligence (BI) filed by virtue of scalability, data integration, development tools, powerful analysis ability, etc. Via real-time crucial information transmission, the business intelligence of Microsoft SQL Server 2005 is realized. Owing to the business intelligence of Microsoft SQL Server, staffs, information workers and even CEOs can effectively manage data, so as to make better decisions. Moreover, more value will be brought to the already-have applications of enterprises (even on different platforms) via the functions of Microsoft SQL Server, such as data integration, data analysis and data reporting. Compared with previous Microsoft SQL Server versions, business intelligence of Microsoft SQL Server 2005 is promoted, and we can see it from the following aspects:
Being an integrated business intelligence platform, Microsoft SQL Server 2005 provides users all features, tools and functions serving typical or innovative data analysis applications. SQL Server 2005 Business Intelligence provides an end-to-end BI application integration:
Design: based on Visual Studio 2005, Business Intelligence Development Studio is the first integration development environment specially designed for business intelligent system developers.
Data Integration: since "Data Transformation Service"(DTS) has been rewritten, present DTS can perform data integration, transformation and synthesis of oversized data. Business Intelligence Development Studio makes software package establishment and debugging more vivid. DTS, Analysis Services and Reporting Services provide online casino a seamless data view for data from heterogeneous data resources.
Data analysis: the data mining function provided by Microsoft is easy to use all along. Nowadays, the function data mining is optimized to a large extent with the introduction of other vital algorithms (including association rule, time series, regression tree, etc). The boundary between relational database and multidimensional database is blurred by Microsoft Server 2005, so users can save data into both relational database and multidimensional database. However, new functions are also added to the Analysis Services: MDX script, key performance indicator frame and other advanced business analysis methods.
Data reporting: the usage range of Reporting Services of Microsoft Business Intelligence is expanded to cover business users who use the data analysis function. Being an enterprise-level reporting environment, Reporting Services performs report insertion and management via Web services. Users can set and submit reports in personalized forms via interactive and printing options. Then, the report in the form of data resource will be delivered to downstream business intelligence so that the complicated data analysis will cover a wider range. Microsoft SQL Server 2005 is equipped with the new reporting tool: Report Builder.
Data management: SQL Server Management Studio is responsible for all SQL Server 2005 component management.