Building Performance Dashboards and Balanced Scorecards 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. This book 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; and explains how to apply the techniques covered earlier in the book for specific business applications.

Includes index.

About the Authors; Acknowledgments; Contents; Introduction; Part 1: Foundations of Dashboards and Balanced Scorecards; Chapter 1: Introduction to Balanced Scorecards; Origins of Strategic Management Systems; Tools of Today's Management; Benefits of Today's Scorecards; Choosing the Right Technology for the Task; Designing for Audience Usability; Organizing Your Balanced Scorecard; Summary; Chapter 2: Planning Your Dashboard and Scorecard Initiative; Defining Scope and Gathering Requirements; Selecting the Right Performance Metrics; Planning Development and Implementation.

Managing Expectations and ScopeSummary; Part 2: Building and Extending Dashboards and Balanced Scorecards; Chapter 3: Building Your First Dashboard and Balanced Scorecard; Anatomy of a Reporting Services Project; Building Your First Dashboard; Summary; Chapter 4: Enhancing Your Dashboard and Balanced Scorecard; Organizing and Achieving Visual Consistency; Formatting Dashboard Elements; Conditional Formatting; Custom and Data-driven Labels and Titles; Summary; Chapter 5: Interactive Dashboards and Balanced Scorecards; Common Interactive Features; Parameterization; Summary.

Chapter 6: Visual Dashboards and Balance…