+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)


Balanced Scorecards and Operational Dashboards with Microsoft Excel. 2nd Edition

  • ID: 2329967
  • Book
  • January 2013
  • 480 Pages
  • John Wiley and Sons Ltd
1 of 3

Drive strategic performance with Balanced Scorecards and operational dashboards

Balanced Scorecards help translate business strategy into action. Performance dashboards are critical for monitoring operations and tactics. This fully updated guide shows you how to create and implement a program of Balanced Scorecards and dashboards using Excel, the preferred tool for the job. Incorporating the latest enhancements, it leads you step by step through the process, preparing you to leverage these tools for improved performance in your organization.

  • Understand how and why Balanced Scorecards work
  • Develop your strategic foundation, build your strategy map, select metrics, and set targets
  • Create executive and operational dashboards to aid in decision–making
  • Identify critical metrics and key performance indicators
  • Examine the pros and cons of using Excel so you can leverage its power
  • Provide more information with miniature charts and tables
  • Smooth data, forecast trends, and display alerts
  • Publish with PowerPoint templates or in secure formats
  • Add extra functionality to Excel
Note: Product cover images may vary from those shown
2 of 3

Introduction xxvii

Part I Strategic Performance with Balanced Scorecards 1

Chapter 1 Accelerating Strategic Performance 3

Chapter 2 Developing Your Strategic Foundation 17

Chapter 3 Preparing to Build Your Balanced Scorecard 31

Chapter 4 Step–by–Step to Building Your Strategy Map 47

Chapter 5 Step–by–Step from Strategy to Action 61

Chapter 6 Step–by–Step to Selecting Metrics and Setting Targets 71

Chapter 7 Step–by–Step to Developing Your Implementation Plan 85

Chapter 8 Step–by–Step to Rollout and Strategic Reviews 91

Part II Operational Performance with Dashboards 101

Chapter 9 Developing Executive and Operational Dashboards 103

Chapter 10 Mapping Your Operational Processes 109

Chapter 11 Identifying Critical Metrics and Key Performance Indicators 121

Part III Building Maps, Scorecards, and Dashboards 133

Chapter 12 Creating Dashboards for Decision–Making 135

Chapter 13 Drawing Process and Strategy Maps 147

Chapter 14 Using Microsoft Excel for Balanced Scorecards and Dashboards 157

Chapter 15 Text–Based Dashboards 167

Chapter 16 Custom Labels and Formatting 183

Chapter 17 Working with Data That Changes Size 207

Chapter 18 Retrieving Data from Lists and Tables of Data 229

Chapter 19 Creating Miniature Charts and Tables 243

Chapter 20 Controlling Charts with Menus, Combo Boxes, and Buttons 267

Chapter 21 Working with PivotTables 283

Chapter 22 Working with PowerPivot 297

Chapter 23 Smoothing Data and Forecasting Trends 317

Chapter 24 Identifying Targets and Displaying Alerts 331

Chapter 25 Building Powerful Decision–Making Charts 347

Chapter 26 Drilling to Detail 371

Chapter 27 Using Excel Add–ins for Extra Capabilities 385

Chapter 28 Finishing Touches 395

Chapter 29 Data Integration Methods 405

Chapter 30 Publishing Balanced Scorecards and Dashboards 425

Index 441

Note: Product cover images may vary from those shown
3 of 3


4 of 3

Ron Person is a senior consultant of business optimization at Sitecore. For the 27 years prior to that, Ron′s independent consulting firm helped organizations clarify their strategy and build measurable high performance. His clients included Medtronic Vascular, the U.S. Navy, Naval Undersea Warfare Center, the U.S. Army Corps of Engineers, and the Motion Picture Artists Association.

Note: Product cover images may vary from those shown