Balanced scorecards & operational dashboards with Microsoft Excel /

Mostrar otras versiones (2)

Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Person, Ron, 1948-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : John Wiley & Sons, Inc., [2013]
Edición:Second edition.
Colección:Office Essentials collection
Temas:
Microsoft Excel (Computer file)
Balanced scorecard (Management)
Performance technology.
Dashboards (Management information systems)
Tableaux de bord (Gestion)
COMPUTERS > Management Information Systems.
Performance technology
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Introduction
  • Part I. 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 rollout and strategic reviews
  • Part II. Operational performance with dashboards. Developing executive and operational dashboards
  • Mapping your operational processes
  • Identifying critical metrics and key performance indicators
  • Part III. 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
  • Retrieving data from lists and tables of data
  • Creating miniature charts and tables
  • Controlling charts with menus, combo boxes, and buttons
  • Working with pivot tables
  • Working with power pivot
  • 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.

Ejemplares similares