SQL Server Business Intelligence (BI) is designed to help organisations extract
the value from their data. It provides a scalable business intelligence (BI) platform
optimized for data integration, reporting, and analysis, enabling organizations
to deliver intelligence where users want it.
It is based on three key principles:
Integrate – data from multiple sources can be integrated to provide
a holistic view of the business.
Report – create, manage and deliver server based reports which
provide key decision makers within your organisation with the relevant information
to make the correct decisions. BI delivers a rich, personalized user experience,
enabling more users throughout the organization to drive action from the insight
they gain through an extensible and embeddable architecture that is optimized for
Microsoft Office interoperability.
Analyse – enable deep insight into the key factors impacting your
organisation.
SQL Server BI functionality breaks down into the following main areas: