Home » Popular Applications » sharepoint » Compile Accurate Business Intelligence Metrics with SQL Reporting Services 2008 R2 and SharePoint Server 2010

Compile Accurate Business Intelligence Metrics with SQL Reporting Services 2008 R2 and SharePoint Server 2010

As John Lauer and a team of supporting authors at Microsoft® made clear in a white paper, “How to Choose the Right Business Intelligence [BI] Technology to Suit Your Style”, “[b]usinesses, in an effort to stay one step ahead, collect large amounts of data ranging from demographics, buyer behavior, and customer loyalty to financial and operational data. Unfortunately the data is useless for decision making, its intended purpose, without a way of organizing and displaying it as meaningful information.” Whether the objective is better project portfolio management, the compilation of useful business key performance indicators (KPIs), balanced scorecards, or executive dashboards, enterprise business aspires to quantify activities into metrics that may be reliably analyzed to summarize present business conditions and, in turn, forecast future conditions.

The important point to chew in in the above quote, as we see it, is Mr. Lauer’s observation that the data is “useless for decision making” as is. Nevertheless, enterprise business continues to maintain a keen interest in working the metrics further to derive some value. The bet that enterprise business is making is that through the process of enhancing the productivity of tasks like “organizing and displaying” the data “as meaningful information” more valuable predictive and assessment observations may be supported by BI activities based upon historical and real-time collected data.

Microsoft’s SQL Reporting Services 2008 R2 is one of several tools that Microsoft has developed for the BI market. As noted in the Introduction to Mr. Lauer’s white paper, “[a]ll of these tools can be surfaced through the familiar SharePoint Server interface”, which contributes to our interest in this topic. We offer a comprehensive set of video tutorials on Reporting Services using SharePoint 2010 and Report Builder 3.0. This set of tutorials is authored by Bruce Herz an acknowledged industry expert on the topic. The intended audience for this set of tutorials includes SharePoint Administators, developers, SQL Server Administrators, and architects. We also think it makes sense for project managers and business analysts to review this training content as they will gain an understanding of the options for presentation and compilation that are opened through the use of these tools.

We are keen to speak with enterprise businesses with a commitment to high standards for BI activities who are considering the use of SQL Server 2008 R2 within a computing environrment where preferences are for browser based data ccess and, to an extent, manipulation. You may reach us at (630) 786-7026, or Contact Us to further a discussion about our video training content.

As ever, use this link to place an order for an annual subscription to SharePoint-Videos instructional content

© Rehmani Consulting Inc, all rights reserved