Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

Enterprise Report Examples

Each user is likely to have favorite reports to make timely and effective business decisions, and although it is not possible to cover a whole gamut of reports in this book, some common ideas can help you think through practical applications of SSRS.

Scorecard reports are frequently used in today's businesses and provide information for each manager on how well his group is doing as compared to the goals set for the group. Usually, a scorecard implements a "traffic light" type of highlight or a "gauge" indicator. Values on the scorecard are highlighted in green when the group is meeting its goals, in yellow when the group is doing so-so, and in red when the group's performance requires immediate attention. Scorecard reports can take advantage of the key performance indicators (KPIs) features of Analysis Services 2008. Gauges and charts have been significantly enhanced in SQL Reporting Services 2008 by the acquisition of the Dundas Gauge and Chart controls by Microsoft.

When users are looking to combine a comprehensive set of business health and "speed" gauges (scorecard) and related information in a small space, a dashboard is used to accomplish this goal. A dashboard provides a short, typically one-page, summary view of a business (much like a car's dashboard summarizes a car's status) and allows drill down through the items on the top page to retrieve detailed information. SharePoint is an excellent platform to host dashboards and greatly simplifies arranging reports in a meaningful fashion on a page.

Today, when everybody is so short on time, it might be easy to miss an information point that could prove fatal for a business. Exception reporting is what comes to the rescue of a time-constrained user. Unlike regularly scheduled reports or summaries provided by scorecards, exception reports are created and delivered to a user when an unusual event occurs. An exception report removes the "noise" created in periodic reports, focusing instead on mission-critical anomalies. An example of such an anomaly could be a sudden drop in daily sales for a particular region.

Other typical reports include various views of sales (geographic, demographic, product, promotion breakdowns), inventory, customer satisfaction, production, services, and financial information.

  • + Share This
  • 🔖 Save To Your Account