Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services - Softcover

Price, Christopher; Jorgensen, Adam; Knight, Devin

Softcover

ISBN 10: 111864719X ISBN 13: 9781118647196

Publisher: John Wiley & Sons, 2013

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.

About this title

About the Author

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.

From the Back Cover

Learn to create dashboards and balanced scorecards tailored to your needs

Balanced scorecards and performance dashboards are high value, high visibility tools for driving and monitoring organizational performance. This book shows you how to deliver these performance management reports using SQL Server Reporting Services.

First you′ll take a holistic look at performance management, metrics, and the steps required to implement dashboards and balanced scorecards. Then you′ll move step by step through designing, developing, and delivering scorecards and dashboards. Finally, you′ll examine case studies that illustrate common performance management report implementations across different industry segments.

• Gain a thorough understanding of the value of dashboards and balanced scorecards to the enterprise
• Build simple dashboards and scorecards with SQL Server Reporting Services
• Enhance them with interactive capability and data visualization
• Prepare them for mobile access and extend them with custom coding
• Add elements such as process and strategy maps, decision–making charts, and forecasting and trending solutions

Companion website

Find all completed sample code and Visual Studio projects demonstrated in this book on the companion website, www.wiley.com/go/performancedashboards

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2013
• Language: English
• ISBN 10: 111864719X
• ISBN 13: 9781118647196
• Binding: Paperback
• Number of pages: 312