Microsoft Business Intelligence

Business Intelligence (BI) tools allow you to quickly, effectively, and economically access, analyze, report, and share the information you need to achieve corporate objectives.

Microsoft Business Intelligence is a complete, fully integrated set of technologies that can help reduce the complexity of organizing and distributing information and lead to competitive advantages, better decisions, and an improved bottom line. Microsoft BI is delivered through three layers or workloads designed to provide a consolidated, comprehensive data source and tools to help improve decision making.

  • Data Warehousing
  • Reporting and Analysis
  • Performance Management

MS SQL Server

Microsoft SQL Server is an integral part of Microsoft Business Intelligence strategy and can help organizations improve their data process. SQL Server 2005 offers an enterprise-ready and proven relational engine that can store huge amounts of data, support high query loads, high performance, and clustering, and scale to the largest enterprise needs.

SQL Server provides organizations with three core BI components:

  • Microsoft SQL Server Integration Services brings your data together from all your disparate sources. This powerful ETL tool can help you synthesize new data, enrich it in a high-performance way, and reload it back into SQL Server 2005. Integration Services is built to work in heterogeneous environments and with virtually any data source within your organization.
  • Microsoft SQL Server Analysis Services adds additional value to your data by placing complex calculations and key performance indicators (KPIs) into the system. Enrich your organization with centralized and shared business logic. Analysis Services also reorganizes data in a hierarchical way that makes sense to decision makers and supports their reporting and analysis needs
  • Microsoft SQL Server Reporting Services helps your end users retrieve and publish data. Reporting Services helps make data easily accessible to a large number of users.

PerformancePoint Server

Microsoft Office PerformancePoint Server 2007 makes corporate-level decision making possible by providing informational views that consolidate all your corporate data. Built on SQL Server 2005 and the 2007 Microsoft Office System, Office PerformancePoint Server 2007 helps make BI better in three key ways:

  • PerformancePoint Monitoring brings to market the next evolution of Microsoft Business Scorecard Manager 2005. Define and use scorecards, dashboards, and key performance indicators (KPIs) to help drive accountability and alignment across your organization.
  • PerformancePoint Analytics is the next version of ProClarity Analytics and helps you easily analyze and identify trends, opportunities, and threats in your data. Capture and share that information throughout your organization.
  • PerformancePoint Planning offers a new set of capabilities that will be released with Office PerformancePoint Server 2007 and will help simplify business planning, budgeting, and forecasting.