Contents
Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform
Business Intelligence Concepts
SSRS for Business Intelligence, Practically
Use Views and Stored Procedures
Some Ideas on Source Data Definition
Designing SQL Server Reports for Business Intelligence
Chapter 2: KPIs and Scorecards
What Are Key Performance Indicators?
A More Complex KPI Using Sparklines
Building a Complex Text-Based KPI
Chapter 3: Gauges for Business Intelligence
Using Multiple Pointers in Gauges
Varying the Pointer Types and Assembling Gauges
Creating Gauges with Sub-Gauges
Interesting Tricks with Gauges
Creating and Assembling the Gauges
Chapter 4: Charts for Business Intelligence
Charts to Compare Metrics with Targets
Basic Target Comparison Charts
A Few Ideas on Using Charts for Business Intelligence
Use Multiple Charts of the Same Type
Chapter 5: Maps in Business Intelligence
Loading Geographical Data into SQL Server from Shapefiles
A Simple Map of US States with Sales
A Heat Map of European Sales by Country
Simplifying the Geographical Data
A Bubble Chart Map of English Regions
Chapter 6: Images in Business Intelligence
Exporting Embedded Images from Reports
Image Backgrounds for Text Boxes
Using Chart Borders for Gauges
Chapter 7: Assembling Dashboards and Presentations
Chapter 8: Interface Enhancements for Business Intelligence Delivery
Report Refresh and Parameter Postback
Interactive Parameter Selection
Creating a Year and Month Selector Widget
Creating Interactive Menus to Select Filter Elements
Chapter 9: Interface Enhancements
Highlighting for Data Selection
Adding a Carousel to Filter Data
Chapter 10: BI for SSRS on Tablets and Smartphones
Other Techniques for Tablet Reports
Smartphone and Tablet Report Hierarchy
Structuring the Report Hierarchy
Chapter 11: Standardizing BI Report Suites
Adding Multiple Data Sources, Datasets, or Image Files
Copying Images Between Reports
Copying Datasets Between Reports
Copying Datasets Between Reports
Loading and Importing Database Images
Using Images from a SQL Server Table
Adding a Dataset for Images to a Report
Applying Style Information from a Database Table
Chapter 12: Optimizing SSRS for Business Intelligence
Enabling Shared Datasets for Caching
Using Parameters and Filters when Caching Reports and Datasets
Pre-Caching Reports and Data Sets
Subscriptions to Load the Cache