At a Glance; Introduction; Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform; Business Intelligence Concepts; Key Performance Indicators; Scorecards; Dashboards; SSRS for Business Intelligence, Practically; Getting the Data Right; Prepare the Data; Use Views and Stored Procedures; Views; Stored Procedures; Some Ideas on Source Data Definition; Real-World Data; Designing SQL Server Reports for Business Intelligence; Presentation; Design; Layout; Interface and Interactivity; Multi-Purposing; The Sample Database; Preparing Your Environment

Creating an SSDT ProjectAdding a Shared Datasource; Add Shared Datasets; Configuring Parameters; Code and Stored Procedures; Reusability; The CarSales_Reports Database; Book Audience; How Best to Use This Book; Conclusion; Chapter 2: KPIs and Scorecards; What Are Key Performance Indicators?; KPI Value; KPI Goal; KPI Status; KPI Status Thresholds; Threshold Flags; KPI Trends; KPI Trend Thresholds and Flags; A Simple KPI; The Source Data; How the Code Works; Building the KPI; How It Works; A More Complex KPI Using Sparklines; The Source Data; How the Code Works; Building the KPI; How It Works

Gauge-Based KPIsThe Source Data; How the Code Works; Building the Gauge-Based KPI; How It Works; Hints and Tips; Text-Based KPIs; A Simple Text-Based KPI; The Source Data; How the Code Works; Building a Text-Based KPI; How It Works; A Complex Text-Based KPI; The Source Data; How the Code Works; Building a Complex Text-Based KPI; How It Works; Conclusion; Chapter 3: Gauges for Business Intelligence; Gauge Elements; Data for Gauges; Gauge Development; Classic Gauges; The Source Data; How the Code Works; Building the Gauge; How It Works; Hints and Tips; Using Multiple Pointers in Gauges

The Source DataHow the Code Works; Creating the Gauge; How It Works; Varying the Pointer Types and Assembling Gauges; The Source Data; How the Code Works; Building the Gauge; How It Works; Hints and Tips; Gauges with Multiple Elements; The Source Data; Creating the Gauge; How It Works; Hints and Tips; Less Traditional Gauges; Thermometers; The Source Data; How the Code Works; Building the Thermometer; How It Works; Hints and Tips; Sub-Gauges; The Source Data; How the Code Works; Creating Gauges with Sub-Gauges; How It Works; Hints and Tips; Interesting Tricks with Gauges; The Source Data

How the Code WorksCreating and Assembling the Gauges; How It Works; Hints and Tips; Conclusion; Chapter 4: Charts for Business Intelligence; Some Chart Presentation Ideas; Charts to Compare Metrics with Targets; Basic Target Comparison Charts; The Source Data; How the Code Works; Building the Chart; How It Works; An Advanced KPI Chart; The Source Data; How the Code Works; Building the Chart; How It Works; Ordering Chart Elements; The Source Data; How the Code Works; Building the Chart; How It Works; Superposed Bar Charts; The Source Data; Creating the Chart; How It Works; Hints and Tips