SQL Server BI

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:

• Reporting Services
• Integration Services
• Analysis Services