Balanced Scorecards and Operational Dashboards with Microsoft Excel


Author: Ron Person
Publisher: John Wiley & Sons
ISBN: 1118610849
Category: Computers
Page: 480
View: 9877

Continue Reading →

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 guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations. Covers Excel 2010 back to Excel 2003 Shows how to develop consensus on strategy and operational plans with the executive teams Details steps in creating tactical action plans Gives step-by-step guidance in creating the most powerful management dashboards Puts over ten years of experience in one book Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.

Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services


Author: Christopher Price,Adam Jorgensen,Devin Knight
Publisher: John Wiley & Sons
ISBN: 1118849094
Category: Computers
Page: 312
View: 7667

Continue Reading →

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.

Balanced Scorecard

Step-by-Step for Government and Nonprofit Agencies
Author: Paul R. Niven
Publisher: John Wiley & Sons
ISBN: 9781118045268
Category: Business & Economics
Page: 384
View: 7614

Continue Reading →

This book provides an easy-to-follow roadmap for successfully implementing the Balanced Scorecard methodology in small- and medium-sized companies. Building on the success of the first edition, the Second Edition includes new cases based on the author's experience implementing the balanced scorecard at government and nonprofit agencies. It is a must-read for any organization interested in achieving breakthrough results.

Alignment

Using the Balanced Scorecard to Create Corporate Synergies
Author: Robert S. Kaplan,David P. Norton
Publisher: Harvard Business Press
ISBN: 9781591396901
Category: Business & Economics
Page: 302
View: 1367

Continue Reading →

The creators of the Balanced Scorecard apply their proven approach to corporate level strategy and offer a framework for aligning all of a company's individual business units with the organizations' overall strategy to ensure optimal business performance.

Balanced Scorecard Step-by-Step

Maximizing Performance and Maintaining Results
Author: Paul R. Niven
Publisher: John Wiley and Sons
ISBN: 9780470893739
Category: Business & Economics
Page: 336
View: 8746

Continue Reading →

PRAISE FOR Balanced Scorecard Step-By-Step: MaximizingPerformance and Maintaining Results, Second Edition "As a practitioner and thought leader, Paul Niven is superblybridging the gulf between BSC theory and application throughhands-on experiences and real-world case studies. The book providesa practical road map, step-by-step, to plan, execute, and sustain awinning scorecard campaign. Easy to read . . . tells a powerfulstory with lessons learned/best practices from global customerimplementations. Must-read for anyone interested in BSC orgrappling with how to create a strategically alignedorganization." —Vik Torpunuri, President and CEO, e2e Analytix "In Balanced Scorecard Step-by-Step, Second Edition, PaulNiven provides an intuitive and incredibly effective blueprint fortransitioning strategic ambition to execution. Paul's pragmaticapproach provides leaders with a tool for managing a company'sjourney from strategic ideas to world-class performance. TheBalanced Scorecard is a masterful tool for guiding companiesthrough transformation, and I speak from personal experience when Isay Paul's blueprint works! It is the most effective guide I haveseen. Balanced Scorecard Step-by-Step will serve any leaderwell if their ambition is to efficiently engage their teams inachieving a set of strategic goals." —Allan A. MacDonald, Vice President, Sales and CustomerSolutions Bell Canada National Markets "Paul Niven has done it again!!! With this book, he has furtheroperationalized the enlightened Balanced Scorecard concept into afully functional system that optimizes business execution andperformance!" —Barton Johnson, President, Financial Freedom Senior FundingCorporation, The Reverse Mortgage Specialist

Project Management Metrics, KPIs, and Dashboards

A Guide to Measuring and Monitoring Project Performance
Author: Harold Kerzner
Publisher: John Wiley & Sons
ISBN: 1119427320
Category: Technology & Engineering
Page: 448
View: 6044

Continue Reading →

Harold Kerzner’s essential strategies on measuring project management performance With the growth of complex projects, stakeholder involvement, and advancements in visual-based technology, metrics and KPIs (key performance indicators) are key factors in evaluating project performance. Dashboard reporting systems provide accessible project performance data, and sharing this vital data in a concise and consistent manner is a key communication responsibility of all project managers. This third edition of Kerzner's groundbreaking work, Project Management Metrics, KPIs, and Dashboards: A Guide to Measuring and Monitoring Project Performance, helps functional managers gain a thorough grasp of what metrics and KPIs are and how to use them. Plus, this edition includes new sections on processing dashboard information, portfolio management PMO and metrics, and BI tool flexibility. • Offers comprehensive coverage of the different dashboard types, design issues, and applications Provides full-color dashboards from some of the most successful project management companies, including IBM, Microsoft, and others Aligns with PMI’s PMBOK® Guide and stresses value-driven project management PPT decks are available by chapter and a test bank will be available for use in seminar presentations and courses Get ready to bolster your awareness of what good metrics management really entails today—and be armed with the knowledge to measure performance more effectively.

Strategy Maps

Converting Intangible Assets Into Tangible Outcomes
Author: Robert S. Kaplan,David P. Norton
Publisher: Harvard Business Press
ISBN: 9781591391340
Category: Business & Economics
Page: 454
View: 6465

Continue Reading →

Strategy Maps takes readers to the next level of precision in strategy implementation Strategy Maps introduces a new tool that has evolved from Robert Kaplan and David Norton’s ongoing research with hundreds of Balanced Scorecard adopters across the globe, and its premise is simple: if you can visually map your strategy, the people within your organization will better understand it and therefore be better able to execute it effectively. Offers a visual cause-and-effect explanation of what’s working and what doesn’t in a way that everyone in the company can understand. Helps get the entire organization involved in strategy.

Execution Excellence

Making Strategy Work Using the Balanced Scorecard
Author: Sanjiv Anand
Publisher: John Wiley & Sons
ISBN: 1119196477
Category: Business & Economics
Page: 288
View: 354

Continue Reading →

A hands-on guidebook for making your strategy work with effective Balanced Scorecard design, deployment, and maintenance Execution Excellence is the practitioner's guide to real-world implementation. Designed by a Balanced Scorecard (BSC) thought leader with 30 years of experience and over 300 global implementations under his belt across a range of industry sectors, this guide gives you a hands-on framework for putting the BSC methodology into action. Clear, concise, and easy to read, this book skips the theoretical exposition to get right to the point—how can companies use BSC to effectively deploy strategy and drive individual and enterprise performance? You'll find the answers here. The discussion outlines the ways in which firms commonly fail in implementing BSC. These failures can be traced back to common design and implementation flaws: making the process too complicated and focusing on the BSC process rather than the outcome. The discussion will also cover design optimization across a range of key industry sectors. You'll gain expert insight into avoiding these missteps and the practical tools and perspective you need to implement BSC correctly the first time. While the Balanced Scorecard framework is widely accepted and praised, about half of firms that implement it fail to realize the full benefits. The fault lies not with the framework, but with the design, and more importantly—execution. This book gives you the information and tools you need to adopt BSC successfully. Design a BSC that truly and simply reflects your strategy Customize the BSC to reflect your industry's uniqueness Define clear measurements and ownership that suit your strategy Develop a framework for efficient data collection and reporting Implement effective reviews to keep your business on track Use your Balanced Scorecard data to close performance gaps Developed in the early 1990s, the Balanced Scorecard framework has been recognized as one of the most seminal business ideas in the last 75 years. Thousands of companies around the world use BSC to create and maintain a performance-oriented enterprise, yet just as many try and fail. Execution Excellence shows you what you need to know and do to become a BSC success story. Praise for EXECUTION EXCELLENCE "Execution Excellence is a very clear roadmap for any manager serious about improving performance with a team. Sanjiv has decades of experience solving problems with real-world companies and the challenges they face. This is a superb summary of his learning, communicated in concise, specific and easy to understand steps. I highly recommend it." —RON SANDERS, President, Warner Bros. Worldwide Home Entertainment "This book is full of sensible, practical advice on how to improve your business using the powerful tools of the Balanced Scorecard. Businesses of all types can see how to achieve their goals more effectively and quickly if they adopt the techniques shown here. Read and prosper!" —JON MOULTON, Founder and Managing Partner, Better Capital "Sanjiv certainly did not disappoint. The book is certainly a compendium of incredible experience he has had as a Consultant in different circumstances. It makes for extremely interesting reading. It is full of substance with practical and implementable suggestions and explains in an incredibly simple and straight forward manner how a tool like the Balance Scorecard can help in terms of framing and implementing business strategy in today's complex and multi dimensional business world." —AKHIL GUPTA, Vice Chairman, Bharti Enterprises "If you ever wondered how great generals manage their troops, this is your chance. Sanjiv is the general when it comes to implementing the BSC, having seen him in board rooms. If you are passionate about execution, then this is your back pocket guide. If you want more, read between the lines." —SALEH LOOTAH, Chairman, Ssl Holdings, Former Board Member, Dubai Islamic Bank "Sanjiv's thirty year experience in helping firms drive enterprise and individual performance, and bringing alignment between these components comes clearly through in this book. The insights are practical, global, and across industry sectors. A must read!" —LEENA NAIR, Chief Hr Officer, Unilever

Performance Dashboards

Measuring, Monitoring, and Managing Your Business
Author: Wayne W. Eckerson
Publisher: John Wiley & Sons
ISBN: 9780470918425
Category: Business & Economics
Page: 336
View: 4528

Continue Reading →

Tips, techniques, and trends on harnessing dashboard technology to optimize business performance In Performance Dashboards, Second Edition, author Wayne Eckerson explains what dashboards are, where they can be used, and why they are important to measuring and managing performance. As Director of Research for The Data Warehousing Institute, a worldwide association of business intelligence professionals, Eckerson interviewed dozens of organizations that have built various types of performance dashboards in different industries and lines of business. Their practical insights explore how you can effectively turbo-charge performance–management initiatives with dashboard technology. Includes all-new case studies, industry research, news chapters on "Architecting Performance Dashboards" and "Launching and Managing the Project" and updated information on designing KPIs, designing dashboard displays, integrating dashboards, and types of dashboards. Provides a solid foundation for understanding performance dashboards, business intelligence, and performance management Addresses the next generation of performance dashboards, such as Mashboards and Visual Discovery tools, and including new techniques for designing dashboards and developing key performance indicators Offers guidance on how to incorporate predictive analytics, what-if modeling, collaboration, and advanced visualization techniques This updated book, which is 75% rewritten, provides a foundation for understanding performance dashboards, business intelligence, and performance management to optimize performance and accelerate results.

Key Performance Indicators for Government and Non Profit Agencies

Implementing Winning KPIs
Author: David Parmenter
Publisher: John Wiley & Sons
ISBN: 0470944544
Category: Business & Economics
Page: 309
View: 8926

Continue Reading →

Winning techniques and strategies for nonprofits and government agencies in creating successful and critical key performance indicators By exploring measures that have transformed businesses, David Parmenter has developed a methodology that is breathtaking in its simplicity and yet profound in its impact. Key Performance Indicators for Government and Nonprofit Agencies: Implementing Winning KPIs is a proactive guide representing a significant shift in the way KPIs are developed and used, with an abundance of implementation tools for government agencies and nonprofit groups. Implementation variations and short cuts for government and not-for-profit organizations How to brainstorm performance measures Templates for reporting performance measures A resource kit for a consultant who is acting as a coach / facilitator to the in-house project team Also by David Parmenter: Key Performance Indicators: Developing, Implementing, and Using Winning KPIs, Second Edition Filled with numerous case studies and checklists to help readers develop their KPIs, this book shows government agencies and nonprofits how to select and implement winning key performance indicators to ensure that their performance management initiatives are successful.

Dashboards for Excel


Author: Jordan Goldmeier,Purnachandra Duggirala
Publisher: Apress
ISBN: 1430249455
Category: Computers
Page: 542
View: 4906

Continue Reading →

This book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision support systems. Throughout the book, the reader is challenged to think about Excel and data analytics differently—that is, to think outside the cell. This book shows you how to create dashboards in Excel quickly and effectively. In this book, you learn how to: Apply data visualization principles for more effective dashboards Employ dynamic charts and tables to create dashboards that are constantly up-to-date and providing fresh information Use understated yet powerful formulas for Excel development Apply advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards Create dynamic systems for decision support in your organization Avoid common problems in Excel development and dashboard creation Get started with the Excel data model, PowerPivot, and Power Query

Balanced Scorecard Strategy For Dummies


Author: Charles Hannabarger,Frederick Buchman,Peter Economy
Publisher: John Wiley & Sons
ISBN: 1118051491
Category: Business & Economics
Page: 388
View: 684

Continue Reading →

A practical, easy-to-understand guide to Balanced Scorecard for busy business leaders The Balanced Scorecard method is an analysis technique designed to translate an organization's mission and vision statement and overall business strategies into specific, quantifiable goals, and to monitor the organization's performance in achieving these goals. Much less technology driven then other analysis approaches, it analyzes an organization's overall performance in four regards: financial analysis, customer service, productivity and internal analysis, and employee growth and satisfaction. Balanced Scorecard Strategy For Dummies breaks down the basics of Balanced Scorecard in simple language with practical, Dummies-style guidance on getting it done. This book covers all the basics of Balanced Scorecard for busy executives and managers-and does it without the high price tag of most professional level Balanced Scorecard guides.

Balanced Scorecard Evolution

A Dynamic Approach to Strategy Execution
Author: Paul R. Niven
Publisher: John Wiley & Sons
ISBN: 111893900X
Category: Business & Economics
Page: 368
View: 3819

Continue Reading →

The best plan is useless without effective execution The future of business has become so unpredictable that your five-year plan may be irrelevant next week. To succeed in the modern market, you must constantly assess your progress and adapt on the fly. Agility, flexibility, continual learning, and adaptation are the new rules of business success. A differentiating strategy is crucial, but it will only lead to competitive advantage if you execute it flawlessly. You'll succeed only if you have the right insight for strategic planning and the agility to execute your plan. Balanced Scorecard Evolution: A Dynamic Approach to Strategy Execution provides the latest theory and practice from strategic planning, change management, and strategy execution to ensure your business is flexible, future ready, and primed for exceptional execution. Author Paul R. Niven guides you through the new principles of The Balanced Scorecard and shows you how to apply them to your planning and strategy execution endeavors. Read case studies that illustrate the theory and practice of strategic agility and execution Learn how to create the objectives, measures, targets, and strategic initiatives that can make your plan a reality Use the latest change management techniques to boost strategy execution success Gain the knowledge and tools you need to face your challenges head-on Motivate your employees to change behaviors toward plan accommodation Making a plan isn't enough. You must actually take steps to implement your plan, and this requires excellent leadership skills. Change can be hard, and your organization may be resistant. Balanced Scorecard Evolution: A Dynamic Approach to Strategy Execution provides everything you need to make things happen.

Excel VBA Programming For Dummies


Author: John Walkenbach
Publisher: John Wiley & Sons
ISBN: 1119077443
Category: Computers
Page: 408
View: 5836

Continue Reading →

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all! Provides step-by-step instructions for creating VBA macros to maximize productivity Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want Fully updated for Excel 2016 All sample programs, VBA code, and worksheets are available at dummies.com If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.

The Balanced Scorecard

Translating Strategy into Action
Author: Robert S. Kaplan,David P. Norton
Publisher: Harvard Business Review Press
ISBN: 1422148165
Category: Business & Economics
Page: 322
View: 9011

Continue Reading →

The Balanced Scorecard translates a company's vision and strategy into a coherent set of performance measures. The four perspectives of the scorecard--financial measures, customer knowledge, internal business processes, and learning and growth--offer a balance between short-term and long-term objectives, between outcomes desired and performance drivers of those outcomes, and between hard objective measures and softer, more subjective measures. In the first part, Kaplan and Norton provide the theoretical foundations for the Balanced Scorecard; in the second part, they describe the steps organizations must take to build their own Scorecards; and, finally, they discuss how the Balanced Scorecard can be used as a driver of change.

Excel Dashboards and Reports for Dummies


Author: Michael Alexander
Publisher: John Wiley & Sons
ISBN: 1119076773
Category: Computers
Page: 384
View: 3198

Continue Reading →

Make the most of your data using the power of Excel When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data—and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values. As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds. Analyze and report on large amounts of data in a meaningful way Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting!

The Execution Premium

Linking Strategy to Operations for Competitive Advantage
Author: Robert S. Kaplan,David P. Norton
Publisher: Harvard Business Press
ISBN: 1422163636
Category: Business & Economics
Page: 336
View: 8615

Continue Reading →

In a world of stiffening competition, business strategy is more crucial than ever. Yet most organizations struggle in this area--not with formulating strategy but with executing it, or putting their strategy into action. Owing to execution failures, companies realize just a fraction of the financial performance promised in their strategic plans. It doesn't have to be that way, maintain Robert Kaplan and David Norton in The Execution Premium. Building on their breakthrough works on strategy-focused organizations, the authors describe a multistage system that enables you to gain measurable benefits from your carefully formulated business strategy. This book shows you how to: Develop an effective strategy--with tools such as SWOT analysis, vision formulation, and strategic change agendas Plan execution of the strategy--through portfolios of strategic initiatives linked to strategy maps and Balanced Scorecards Put your strategy into action--by integrating operational tools such as process dashboards, rolling forecasts, and activity-based costing Test and update your strategy--using carefully designed management meetings to review operational and strategic data Drawing on extensive research and detailed case studies from a broad array of industries, The Execution Premium presents a systematic and proven framework for achieving the financial results promised by your strategy.

Excel 2010 Formulas


Author: John Walkenbach
Publisher: John Wiley & Sons
ISBN: 9780470625538
Category: Computers
Page: 816
View: 7674

Continue Reading →

Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010. You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else. Demonstrates how to use all the new features of Excel 2010 to maximize your formulas Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more Serves as an indispensable reference no matter your skill level Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.