Page 85 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes 5.8 Summary

A web-based report, the Microsoft Business Intelligence platform is an ideal service to
provide fast, reliable reporting services.
A number of BI tools, such as Cognos PowerPlay, have robust analytical capabilities that
allow specialized users in companies to quickly perform complicated database analysis.

Office XP devices such as Excel are high on the usability scale because they enable business
users to support BI purposes through the use of desktop tools they are already familiar
with.
Companies can use the SQL Server 2000 for the Oracle Customer kit to link the two
databases and alleviate the task of managing the two databases.
Microsoft’s BI platform can positively influence expertise management by facilitating the
task designing and deployment phase of a BI task as well as simplifying the task of
ongoing scheme administration.

Companies using Microsoft’s BI devices can make it cheaper for users to access data,
simplify the task of data mining and analysis, and enable employees to make enterprise
decisions that decrease charges or improve profitability.
Microsoft’s business intelligence platform strategy is rooted in its database proposing:
SQL Server 2000. SQL Server 2000 is the anchor storage and query expertise behind.NET
servers.

Business Intelligence Development Studio is Microsoft Visual Studio 2008 with project
types that are specific to SQL Server business intelligence.

Data extraction is the act or process of retrieving data from data sources for further data
processing.

5.9 Keywords

Business Intelligence (BI): Business Intelligence (BI) is a set of theories, methodologies, processes,
architectures, and technologies that transform raw data into meaningful and useful information
for business purposes.
Data Extraction: Data extraction is the act or process of retrieving data out of (usually unstructured
or poorly structured) data sources for further data processing or data storage (data migration).
Data Mining (DM): Data mining (the analysis step of the “Knowledge Discovery in Databases”
process, or KDD), an interdisciplinary subfield of computer science, is the computational process
of discovering patterns in large data sets involving methods at the intersection of artificial
intelligence, machine learning, statistics, and database systems.

Data Warehousing: In computing, a data warehouse or enterprise data warehouse (DW, DWH,
or EDW) is a database used for reporting and data analysis.

Decision Support Systems (DSS): A decision support system (DSS) is a computer program
application that analyses business data and presents it so that users can make business decisions
more easily.

80 LOVELY PROFESSIONAL UNIVERSITY