Microsoft SQL and Business Intelligence


Why do we need BI? Is Enterprise Resource Planning System not enough?

The Enterprise Resource Planning-ERP, e.g., Microsoft Dynamics AX (AXAPTA), are designed for management of a structured business process, but for detailed analysis business intelligence (BI) tools, such as provided by MS Analysis Services, are more suitable.

What is Business Intelligence?

The term Business Intelligence (BI) is used in the field of information technologies when it comes to providing information for decision – making, so, this is the business data analysis for the purpose of data transformation into information for more accurate decision – making. BI gives an opportunity to users to analyze interactively and dynamically the crucially important data — data panels, analysis view and reports.

Why Microsoft SQL? Is it the best way to manage data?

Microsoft SQL Server 2008 R2 includes comprehensive BI tools in standard installation. Wide array of features, availablity of training, no additional products to install enables you to obtain powerful BI solution with low costs (total-cost-of-ownership – TCO).

What are the main advantages of the latest Microsoft SQL 2008 R2?

The latest R2 edition of Microsoft SQL 2008 is the most powerful version of SQL Server ever appeared.

What is Microsoft SQL Analysis Services

Microsoft SQL Server Analysis Services (SSAS) provide the on-line analytical processing (OLAP) and data mining functionality business intelligence solutions. Analysis Services support OLAP thereby enabling to develop, create and manage multidimensional structures that contain data summarized from other data sources, e.g., from the relational database. For data mining solutions Analysis Services enable to execute, develop and visualize the data mining models obtained from other data sources by using the standardized data mining algorithms of a particular sector.

What is Microsoft SQL Reporting Service

SQL Server Reporting Services provide completely ready-made tools and services that help to develop, introduce and manage reports at your enterprise, as well as the programming tools that enable to expand and adjust reports.

Reporting Services is a server-based report platform that offers in-depth reporting functionality from different data sources. Reporting Services include a complete tool set in order to develop, manage and distribute reports and API, thereby enabling the developers to integrate or expand data and report processing for every user. The Reporting Services tools operate in Microsoft Visual Studio environment and are completely integrated with SQL Server tools and components.

Using Reporting Services you can develop interactive tables, diagrams or freeform reports from the relational, Multidimensional or XML data sources. You can publish reports, plan the report generation or also generate reports by running the process. Reporting Services can also create ad hoc reports based on predefined models. You can choose any of various viewing formats, export to other application software and subscribe for reports. The created reports can be opened by using the Internet connection, as well as Microsoft Windows application software or SharePoint site. Reporting Services is the key to your business data.

For more information