Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

  • 3h 33m
  • Adam Jorgensen, Christopher Price, Devin Knight
  • John Wiley & Sons (US)
  • 2014

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.

About the Authors

Christopher Price is a Senior Business Intelligence Consultant with Pragmatic Works. He specializes in data integration, ETL, and data warehouse architecture and design.

Adam Jorgensen is President of Pragmatic Works, Director at Large for the Professional Association of SQL Server, and a Microsoft SQL Server MVP.

Devin Knight is a Senior BI consultant with Pragmatic Works, a coauthor of six Knight's 24-Hour Trainer books for Wrox, and a conference speaker.

In this Book

  • Introduction to Balanced Scorecards
  • Planning Your Dashboard and Scorecard Initiative
  • Building Your First Dashboard and Balanced Scorecard
  • Enhancing Your Dashboard and Balanced Scorecard
  • Interactive Dashboards and Balanced Scorecards
  • Visual Dashboards and Balanced Scorecards
  • Mobile Dashboards and Balanced Scorecards
  • Extending Dashboards and Balanced Scorecards with Custom Code
  • Publishing Dashboards and Balanced Scorecards
  • Dashboards
  • Strategy and Process Maps
  • Balanced Scorecards Case Study
  • Decision-making Charts
  • Forecasting Trends and Data Smoothing
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)