Person R. Balanced Scorecards & Operational Dashboards with Microsoft Excel

Wiley – 2009, 480 pages
ISBN: 0470386819, 9780470386811Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.Strategic Performance with Balanced Scorecards.
Accelerating Strategic Performance.
Developing Your Strategic Foundation.
Preparing to Build Your Balanced Scorecard.
Step-by-Step to Building Your Strategy Map.
Step-by-Step from Strategy to Action.
Step-by-Step to Selecting Metrics and Setting Targets.
Step-by-Step to Developing Your Implementation Plan.
Step-by-Step to Roll-Out and Strategic Reviews.
Operational Performance with Dashboards.
Developing Executive and Operational Dashboards.
Mapping Your Operational Processes.
Identifying Critical Metrics and Key Performance Indicators.
Building Maps, Scorecards and Dashboards.
Creating Dashboards for Decision Making.
Drawing Process and Strategy Maps.
Using Microsoft Excel for Balanced Scorecards and Dashboards.
Text-Based Dashboards.
Custom Labels and Formatting.
Working with Data That Changes Size.
Working with Lists and Tables of Data.
Creating Miniature Charts and Tables.
Controlling Charts with Menus, Combo Boxes, and Buttons.
Working with PivotTables.
Smoothing Data and Forecasting Trends.
Identifying Targets and Displaying Alerts.
Building Powerful Decision Making Charts.
Drilling to Detail.
Using Excel Add-Ins for Extra Capabilities.
Finishing Touches.
Data Integration Methods.
Publishing Balanced Scorecards and Dashboards.