Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.

    But before numerical information can be useful it must be analyzed, interpreted, and assimilated. Unfortunately, teaching the techniques for making sense of data has been neglected at all levels of our educational system. As a result, through our culture there is little appreciation of how to effectively use the volumes of data generated by both business and government. This book can remedy that situation. Readers report that this book as changed both the way they look a data and the very form their monthly reports. It has turned arguments about the numbers into a common understanding of what needs to be done about them. These techniques and benefits have been thoroughly proven in a wide variety of settings. Read this book and use the techniques to gain the benefits for your company.

    So why then do so many audiences leave feeling like they've wasted their time? All too often, presentations don't resonate with the audience and move them to transformative action.Just as the author's first book helped presenters become visual communicators, Resonate helps you make a strong connection with your audience and lead them to purposeful action. The author's approach is simple: building a presentation today is a bit like writing a documentary. Using this approach, you'll convey your content with passion, persuasion, and impact.Author has a proven track record, including having created the slides in Al Gore's Oscar-winning An Inconvenient TruthFocuses on content development methodologies that are not only fundamental but will move people to action Upends the usual paradigm by making the audience the hero and the presenter the mentor Shows how to use story techniques of conflict and resolution Presentations don't have to be boring ordeals. You can make them fun, exciting, and full of meaning. Leave your audiences energized and ready to take action with Resonate.

    While Lean methodologies were developed in manufacturing environments, many Lean principles can be applied to any kind of business or activity; from software development to accounting systems to household chores.This short book introduces the core concepts of kanban and offers a step by step guide to getting started with kanban.

    The term “complexity” can be misleading, however, because what makes West’s discoveries so beautiful is that he has found an underlying simplicity that unites the seemingly complex and diverse phenomena of living systems, including our bodies, our cities and our businesses. Fascinated by issues of aging and mortality, West applied the rigor of a physicist to the biological question of why we live as long as we do and no longer. The result was astonishing, and changed science, creating a new understanding of energy use and metabolism: West found that despite the riotous diversity in the sizes of mammals, they are all, to a large degree, scaled versions of each other. If you know the size of a mammal, you can use scaling laws to learn everything from how much food it eats per day, what its heart-rate is, how long it will take to mature, its lifespan, and so on. Furthermore, the efficiency of the mammal’s circulatory systems scales up precisely based on weight: if you compare a mouse, a human and an elephant on a logarithmic graph, you find with every doubling of average weight, a species gets 25% more efficient—and lives 25% longer. This speaks to everything from how long we can expect to live to how many hours of sleep we need. Fundamentally, he has proven, the issue has to do with the fractal geometry of the networks that supply energy and remove waste from the organism's body. West's work has been game-changing for biologists, but then he made the even bolder move of exploring his work's applicability to cities. Cities, too, are constellations of networks and laws of scalability relate with eerie precision to them. For every doubling in a city's size, the city needs 15% less road, electrical wire, and gas stations to support the same population. More amazingly, for every doubling in size, cities produce 15% more patents and more wealth, as well as 15% more crime and disease. This broad pattern lays the groundwork for a new science of cities. Recently, West has applied his revolutionary work on cities and biological life to the business world. This investigation has led to powerful insights into why some companies thrive while others fail. The implications of these discoveries are far-reaching, and are just beginning to be explored. Scale is a thrilling scientific adventure story about the elemental natural laws that bind us together in simple but profound ways. Through the brilliant mind of Geoffrey West, we can envision how cities, companies and biological life alike are dancing to the same simple, powerful tune, however diverse and unrelated they are to each other.From the Hardcover edition.

    This means channeling resources into the right efforts, striking a balance between innovation and control, and getting everyone pulling in the same direction.How to accomplish all this? Continually ask the right questions, advises Harvard Business School professor Robert Simons. By posing these provocative questions, you identify critical gaps in your strategy execution processes, focus on the most important choices you must make, and understand what's at stake in each one.In this concise guide, Simons presents the seven key questions you and your team must regularly explore together:·Who is your primary customer? Have you organized your company to deliver maximum value to that customer?·How do your core values prioritize shareholders, employees, and customers? Is everyone in your company committed to those values?·What critical performance variables are you tracking? How are you creating accountability for performance on those variables?·What strategic boundaries have you set? Does everyone know what actions are off-limits?·How are you generating creative tension? Is that tension catalyzing innovation across units?·How committed are your employees to helping each other? Are they sharing responsibility for your company’s success?·What strategic uncertainties keep you awake at night? How are you riveting everyone's attention on those uncertainties?These questions force you to reexamine the unspoken assumptions underlying your strategy and analyze how it's implemented through your business processes and structures. Simons' extensive examples then help you understand your options and make the tough choices needed for your company to excel at execution.Drawing on decades of research into performance management systems and organization design, Seven Strategy Questions is a no-nonsense, must-read resource for all leaders in your organization.

    Fully updated with the 2009 practice guidelines, this book will take you through every step of a project - from planning and establishing roles to closing and reviewing - offering practical and easy-to-understand advice on using PRINCE2. It also shows how to use the method when approaching the key concerns of project management, including setting up effective controls, managing project risk, managing quality and controlling change. PRINCE2 allows you to divide your project into manageable chunks, so you can make realistic plans and know when resources will be needed. PRINCE2 For Dummies, 2009 Edition provides you with a comprehensive guide to its systems, procedures and language so you can run efficient and successful projects.PRINCE2 For Dummies, 2009 Edition includes: Part I: How PRINCE Can Help You - Chapter 1: So What's a Project Method and Why Do I Need to Use One? - Chapter 2: Outlining the Structure of PRINCE2 - Chapter 3: Getting Real Power from PRINCE2Part II: Working Through Your Project - Chapter 4: Checking the Idea Before You Start - Chapter 5: Planning the Whole Project: Initiation - Chapter 6: Preparing for a Stage in the Project - Chapter 7: Controlling a Stage - Chapter 8: Building the Deliverables - the Work of the Teams - Chapter 9: Finishing the Project - Chapter 10: Running Effective Project BoardsPart III: Help with PRINCE Project Management - Chapter 11: Producing and Updating the Business Case - Chapter 12: Deciding Roles and Responsibilities - Chapter 13: Managing Project Quality - Chapter 14: Planning the Project, Stages, and Work Packages - Chapter 15: Managing Project Risk - Chapter 16: Controlling Change and Controlling Versions - Chapter 17: Monitoring Progress and Setting Up Effective ControlsPart IV: The Part of Tens - Chapter 18: Ten Ways to Make PRINCE Work Well - Chapter 19: Ten Tips for a Good Business Case - Chapter 20: Ten Things for Successful Project Assurance Part V: Appendices - Appendix A: Looking into PRINCE Qualifications - Appendix B: Glossary of the Main PRINCE2 Terms

    In this in-depth report, data scientist DJ Patil explains the skills, perspectives, tools and processes that position data science teams for success.Topics include: What it means to be "data driven." The unique roles of data scientists. The four essential qualities of data scientists. Patil's first-hand experience building the LinkedIn data science team.

    Douglas Hubbard helps us create a path to know the answer to almost any question in business, in science, or in life . . . Hubbard helps us by showing us that when we seek metrics to solve problems, we are really trying to know something better than we know it now. How to Measure Anything provides just the tools most of us need to measure anything better, to gain that insight, to make progress, and to succeed." -Peter Tippett, PhD, M.D. Chief Technology Officer at CyberTrust and inventor of the first antivirus software "Doug Hubbard has provided an easy-to-read, demystifying explanation of how managers can inform themselves to make less risky, more profitable business decisions. We encourage our clients to try his powerful, practical techniques." -Peter Schay EVP and COO of The Advisory Council "As a reader you soon realize that actually everything can be measured while learning how to measure only what matters. This book cuts through conventional cliches and business rhetoric and offers practical steps to using measurements as a tool for better decision making. Hubbard bridges the gaps to make college statistics relevant and valuable for business decisions." -Ray Gilbert EVP Lucent "This book is remarkable in its range of measurement applications and its clarity of style. A must-read for every professional who has ever exclaimed, 'Sure, that concept is important, but can we measure it?'" -Dr. Jack Stenner Cofounder and CEO of MetraMetrics, Inc.

    Organized around a strategic marketing framework"Services Marketing" guides readers into the consumer and competitive environments in services marketing. The marketing framework has been restructured for this edition to reflect what is happening in services marketing today.

    This-is-Lean

    In doing so, these otherwise well-intentioned leaders are working harder than they should while not getting all they could out of their teams.Lead Inside the Box gives leaders a way to get the best out of their teams by focusing their energy where it will make the biggest difference. It teaches leaders how to:Figure out where they are currently investing their time and energy across their teamsIdentify the unique leadership needs of each team memberMake smarter decisions about how and where to invest their time and energy to get the best results out of everyoneThrough simple frameworks brought to life with stories from the trenches, leaders will be able to see their own teams--and themselves--from a new perspective. Paradoxically these methods will enable leaders to improve their team's performance exponentially while expending half the effort.

    Topics covered range from the difference between deductive and inductive reasoning, to a discussion of how to highlight the structure of information.

    A manager spots consumer-spending patterns no one else sees and defines new market categories your enterprise can serve. A strategist anticipates global changes and correctly interprets their business implications. Companies' competitiveness, even survival, increasingly hinge on such "clever people." But the truth is, clever people are as fiercely independent as they are clever-they don't want to be led. So how do you corral these players in your organization and inspire them to achieve their highest potential? In Clever, Rob Goffee and Gareth Jones offer potent insights drawn from their extensive research. The authors explain how to: • Identify your clever people and their motivations • Shelter your "clevers" from political distractions that can inhibit their productivity • Help clevers generate even more value by creating clever teams • Manage the unique tensions that can arise when clevers work together Leading clever people can be enormously challenging, yet doing so effectively is the key to your organization's sustained success. Lively and engaging, this book provides the ideas, practices, and examples you need to create an environment where your most brilliant people can flourish.

    These insights may shake your assumptions, but they'll help you reach the "ah-ha!" moments that inspire truly great products.Validate or invalidate your hypothesis by talking to the right peopleLearn how to conduct successful customer interviews play-by-playDetect a customer's behaviors, pain points, and constraintsTurn interview insights into Minimum Viable Products to validate what customers will use and buyAdapt customer development strategies for large companies, conservative industries, and existing products