The Big Book of Dashboards
Visualizing Your Data
Using Real-World
Business Scenarios
Cover image: Course Metrics Dashboard by Jeffrey Shaffer
Cover design: Wiley
Copyright © 2017 by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave. All rights reserved.
Published by John Wiley & Sons, Inc., Hoboken, New Jersey.
Published simultaneously in Canada.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600, or on the Web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.
For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.
Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.
A catalog record for this book is available from the Library of Congress.
ISBN 978-1-119-28271-6 (Paperback)
ISBN 978-1-119-28278-5 (ePDF)
ISBN 978-1-119-28273-0 (ePub)
ISBN 978-1-119-28308-9 (obook)
Acknowledgments
From the three of us
Stephen Few, whose books have made a profound and lasting impression on us.
Alberto Cairo for his invaluable feedback and for his leadership in the data visualization community.
Our technical reviewers greatly improved our first drafts. Thanks to Troy Magennis, Andy Kirk, Jon Schwabish, Ariel Pohoryles, Trudy Weiss Craig, Michael Fry, and a special thanks to Cole Nussbaumer Knaflic for introducing us to the Wiley team and who went far beyond our expectations with her detailed edits and comments.
All the contributors to this book gave significant time to tweak their dashboards according to our requests. We thank you for allowing us to include your work in the book.
Thanks, also, to Mark Boone, KK Molugu, Eric Duell, Chris DeMartini, and Bob Filbin for their efforts.
Our stellar team at Wiley: acquisitions editor Bill Falloon for fighting so hard on our behalf; editor Christina Verigan for her deft reworking and invaluable help optimizing flow; senior production editor Samantha Hartley for overseeing the daunting process of making this book a beautiful, tangible thing; copy editor Debra Manette for such detailed editing and insights; proofreader Hope Breeman for her meticulous proof check; the team at WordCo for a comprehensive index and marketing manager Heather Dunphy for her exceptional expertise in connecting author with audience.
From Steve
My wife, Laura, and my daughters, Janine and Diana, for the never-ending support and love.
Ira Handler and Brad Epstein, whose friendship, encouragement, and example have been a godsend for the past dozen years.
Joe Mako, who has always been willing to help me with “the difficult stuff” and provided much needed encouragement when I was starting out.
The Princeton University Triangle Club, where I learned how to bring talented people together to make wonderful things. Without my experiences there I don't know if I would have had the insight and ability to recruit my fellow authors.
Jeff and Andy, who not only made the book way better than it would have been had I tackled it on my own, but for providing me with one of the most rewarding and enriching experiences of my career. Your abilities, candor, humor, grit, patience, impatience, thoughtfulness, and leadership made for a remarkable ride.
From Andy
I would like to thank Steve and Jeff for approaching me to join this project. I'd been procrastinating on writing a book for many years, and the opportunity to work with two passionate, skilled leaders was the trigger I needed to get going. I would like to thank them both for many hours of constructive debate (argument?) over the rights and wrongs of all aspects of dashboards and data visualization. It has been an enriching experience.
Finally, to Liz, my wife, and my daughters, Beatrice and Lucy. Thank you for your support and the freedom to abandon you all on weekends, mornings, and evenings in order to compete this project. I could not have done it without you.
From Jeff
Thank you, Steve and Andy. It was a pleasure working with you guys. I will miss the collaboration, especially our many hours of discussion about data visualization and dashboard design.
A special thank you to Mary, my wife, and to Nina and Elle, my twin daughters, for sacrificing lots of family time over many long nights and weekends. I would not have been able to complete this project without your support.
About the Authors
Steve Wexler has worked with ADP, Gallup, Deloitte, Convergys, Consumer Reports, The Economist, ConEd, D&B, Marist, Tradeweb, Tiffany, McKinsey & Company, and many other organizations to help them understand and visualize their data. Steve is a Tableau Zen Master, Iron Viz Champion, and Tableau Training Partner.
His presentations and training classes combine an extraordinary level of product mastery with the real-world experience gained through developing thousands of visualizations for dozens of clients. In addition to his recognized expertise in data visualization and Tableau, Steve has decades of experience as a successful instructor in all areas of computer-based technology. Steve has taught thousands of people in both large and small organizations and is known for conducting his seminars with clarity, patience, and humor.
Website: DataRevelations.com
Jeffrey A. Shaffer is Vice President of Information Technology and Analytics at Recovery Decision Science and Unifund. He is also Adjunct Professor at the University of Cincinnati, where he teaches Data Visualization and was named the 2016 Outstanding Adjunct Professor of the Year.
He