Microsoft Business Intelligence

Meet the business intelligence needs of executives and employees while minimizing associated IT management issues and cost with Microsoft Business Intelligence solutions. Available as part of the familiar Microsoft Office and Microsoft SharePoint Server products, and built on the powerful Microsoft SQL Server platform. Take advantage of the following Microsoft Business Intelligence capabilities to connect people to data and to each other, while easing the burden on IT staff and maintaining proper governance.


Your employees often use office productivity tools such as Microsoft Excel to pull together and analyze data to help make daily decisions. Although these tools offer flexibility and speed over relying on the IT department to help pull data together for them, data integrity is often at risk. With the self-service capabilities offered by Microsoft Business Intelligence solutions, employees can continue to use the tools they prefer, while giving the IT department the ability to monitor, manage, and govern the data and solutions that end users work with, so that the integrity of data and the stability of the system can be maintained.

Dashboards and Scorecards

Provide access to information and performance monitoring from virtually any data source across the organization through interactive, content-driven dashboards and scorecards that combine data from multiple systems into a single browser-based experience. Dashboards enable users with advanced filtering, analytics and data exploration from within the browser, allowing them to find answers to question and the root cause behind performance measures. Because these capabilities ship as part of SharePoint Server, you can utilize current investments to deploy dashboards and scorecards broadly across your organization while benefiting from ease of central management and administration.


Through SharePoint Server, employees can more easily connect and collaborate with each other, find peers with subject expertise , and share content to make better informed and more agile business decisions. Employees can share their own business reports and analysis in a centralized, managed, and secure environment. They can effortlessly find information across unstructured sources (blogs, wikis, presentations, documents) as well as structured sources (reports, spreadsheets, analytical systems) all from one environment. Providing seamless end-to-end business collaboration for increased user productivity and decision making.


The market share-leading reporting solution from Microsoft, Microsoft SQL Server Reporting Services is the solution of choice for businesses that require enterprise reporting capabilities. Because Reporting Services ships with SQL Server, you can fully utilize your current investments to access and combine data from virtually any data source to meet the reporting needs of your business. Covering the full range of reporting through highly intuitive ad-hoc reporting for business users as well as providing powerful report authoring environments for IT professionals and developers. Microsoft also offer agility and choice by extending reporting into the cloud through Microsoft SQL Azure Reporting, allowing you to take advantage of the accessibility and elasticity of the cloud.


The best analysts, and often the best assets, in most organizations are those who love to dig into the data and really understand why the business is performing the way it is. They may complete a financial modeling exercise to predict future revenue or drill into sales data to understand why a store in one region is outperforming all the other stores. Because Microsoft SQL Server Analysis Services ships with SQL Server, you can fully utilize your current investments to pull together analytical models from virtually any data source across your organization with the industry’s leading OLAP solution. Users can access these analytical capabilities through the familiar Microsoft Excel and SharePoint Server environments, extending the reach to more employees throughout the organization.

Predictive Analytics and Data Mining

Dig deeper to deduce knowledge. Move beyond simple data analysis to identify hidden trends, problems, or relationships in the data. After insights are extracted from patterns, clusters, and trends, people can better identify the root cause of problems and predict future outcomes. Microsoft builds these powerful data mining capabilities into SQL Server Analysis Services, allowing you to fully utilize your current investments in SQL Server to surface predictive analytics in your reports, dashboards, and scorecards to provide deeper insights to more employees. Through the Data Mining Add-ins for Excel we make the power of data mining available through the familiar and intuitive Excel experience, making these capabilities accessible to a broader range of users.

Data Integration and Data Warehousing

Store and connect information securely, and make the extraction, transformation, and loading processes easier by using Microsoft data ware-housing solutions. Organizations can reduce long-term storage requirements and generate reports faster because these solutions aggregate, compress, and store data in a dynamic, scalable, integrated system. Mission-critical applications require nonstop access to data. Meet your business continuity goals with Microsoft SQL Server 2008 R2 high-availability technologies, which offers high scalability and performance at low cost through massively parallel processing(MPP).

 Read more