Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

✍ Scribed by Knight, Devin; Jorgensen, Adam; Price, Christopher

• Publisher: Wiley
• Year: 2014
• Tongue: English
• Leaves: 314
• Edition: 1
• Category: Library

✦ Synopsis

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

Content: 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 Balanced ScorecardsGeneral Guidelines for Data Visualizations
Working with Charts and Graphs
Working with Sparklines and Data Bars
Working with Gauges and Bullet Graphs
Working with Indicators
Working with Maps
Summary
Chapter 7: Mobile Dashboards and
Planning for the Right Audience
Browser or Native?
Choosing a Mobile Platform
General Considerations for Mobile Dashboards
Design Considerations
Summary
Chapter 8: Extending Dashboards and Balanced Scorecards with Custom Code
Choosing to Embed Custom Code
Creating Assemblies for Reusability.

✦ Subjects

Client/server computing.;Database management.;Organizational effectiveness;Data processing.;SQL server.;COMPUTERS;Programming Languages;SQL.