Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

Discover how to maintain and update balanced scorecards and performance dashboards with SQL Server Reporting Services

Complementing the bestselling Balanced Scorecards and Operational Dashboards with Microsoft Excel (9780470386811), this indispensable book shows you how to create maintainable and dynamically updated scorecards and performance dashboards using Microsoft’s premier reporting tool for the enterprise: SQL Server Reporting Services. The book begins with coverage of performance management methods and metrics and then moves on to introduce you to techniques for developing and delivering both a dashboard and balanced scorecard using Reporting Services. The authors assume very limited knowledge of Reporting Services, allowing you to gradually progress through more advanced topics and solutions.

• Shows you how to build a simple dashboard and balanced scorecard utilizing helpful examples
• Discusses formatting controls and labels, paging, and conditional formatting
• Introduces the skills necessary to make Reporting Services dashboards and scorecards interactive
• Covers the visual aspect of dashboards and scorecards and shows how to design and implement dashboards and scorecards in Reporting Services for mobile devices
• Explains how to apply the techniques covered earlier in the book for specific business applications

This book sets itself apart from other titles with its comprehensive and invaluable coverage of key strategies and techniques for effectively using SQL Reporting Services to create scorecards and dashboards.

Table of Contents

Part 1: Foundations of Dashboards and Balanced Scorecards
Chapter 1: Introduction to Balanced Scorecards
Chapter 2: Planning Your Dashboard and Scorecard Initiative

Part 2: Building and Extending Dashboards and Balanced Scorecards
Chapter 3: Building Your First Dashboard and Balanced Scorecard
Chapter 4: Enhancing Your Dashboard and Balanced Scorecard
Chapter 5: Interactive Dashboards and Balanced Scorecards
Chapter 6: Visual Dashboards and Balanced Scorecards
Chapter 7: Mobile Dashboards and
Chapter 8: Extending Dashboards and Balanced Scorecards with Custom Code
Chapter 9: Publishing Dashboards and Balanced Scorecards

Part 3: Dashboards and Balanced Scorecards in Action
Chapter 10: Dashboards
Chapter 11: Strategy and Process Maps
Chapter 12: Balanced Scorecards Case Study
Chapter 13: Decision-making Charts
Chapter 14: Forecasting Trends