Home » sharepoint » sharepoint_1 » Leverage SQL Reporting Services to build Useful Business Intelligence from Corporate Data

Leverage SQL Reporting Services to build Useful Business Intelligence from Corporate Data

As noted by Steve Miller for Information Management Blogs on April 5, 2010, “[m]easurement, of course, is the stuff of traditional BI, on steroids with the current data explosion.” Of course, Microsoft plays a major role in this explosive proliferation of data, whereby all sorts of information now “gush up” to business & IT management under the aegis of “Business Intelligence” or BI.

Rehmani Consulting Inc offers a unique set of 13 video tutorials on SQL Reporting Services on SharePoint-Videos.com. Each of these tutorials is authored by Bruce Herz, a SharePoint consultant who has worked with SharePoint for over 10 years, beginning with the Microsoft® Office 60 Minute Intranet Kit, which was the ancestor of SharePoint 1.0 Team Services.

These tutorials are specific to SQL Reporting Services. Therefore, individuals will benefit from these tutorials regardless of whether or not they are looking for training from a SharePoint perspective, or not. Nevertheless, three of the videos provide instruction specific to working with SQL Reporting Services within a SharePoint environment:

  • “Working with Report Parts and Data Sets”
  • “Installing SQL 2008 Reporting Services R2 Add-In for SharePoint 2010” and
  • “Introduction to SQL Reporting Services 2008 R2 and Report Builder 3.0”

SQL Reporting Services enhance the usefulness of SQL data by packaging the data into reports, charts, etc that are readily intelligible to a business audience while, at the same time, remaining useful to IT management. It is fair, therefore, to posit that SQL Reporting Services contribute to collaboration within the enterprise. After all, once data is rendered intelligible there is something on the table for everyone to discuss. There are few, if any, better enterprise foundation platforms than SharePoint that can provide an optimum setting for the business collaboration that can ensue from the availability of useful data.

Of course, for IT management that opts to build useful BI, then determining whether to exclude or include data based upon an assessment of the manageability of specific information makes sense. For this IT management group, our video tutorials on Taxonomy, BCS, and SharePoint Designer will make further sense. Rendering information “visible” across a global business, or other large organization
from an enterprise SharePoint foundation with Taxonomy makes perfect sense. Bringing remote data into the SharePoint data repository with BCS or web services built with SharePoint Designer makes further sense. After all, mountains of structured data are still, nevertheless, intimidating, and to a large extent, impenetrable.

We offer at SharePoint-Videos.com a unique and deep amount of substantial training on the various versions of SharePoint as well as its features. If you are planning on a significant role for SharePoint within your business, then you should take a look at incorporating access to SQL Reporting Services from SharePoint and, in turn, incorporating reports, charts, etc into a searchable document repository that can product useful BI. If you would like to hear more about how our video training can be offered within your SharePoint plan, then please either call us at (630) 786-7026, or Contact Us. We will be happy to elaborate with suggestions and tips for including a video training component in your offer.

© Rehmani Consulting Inc, 2011 All Rights Reserved