- Cover
- Title
- Copyright
- Dedication
- Contents at a glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: Dashboards and Data Visualization
- Chapter 1: Introduction to Dashboard and Decision Support Development
- Chapter 2: A Critical View of Information Visualization
- Understanding the Problem
- Of Pilots and Metaphors
- A Metaphor Too Far: Driving Down the Information Superhighway
- A Brief History of Dashboards and Information Visualization
- A Quick Summary Before Taking a Critical Look
- Dashboards by Example: U.S. Patent and Trademark Office
- Visualizations That Look Cool but Just Don’t Work
- The Last Word
- Chapter 3: The Principles of Data Visualization in Microsoft Excel
- Chapter 4: The Excel Data Presentation Library
- Part II: Excel Dashboard Design Tools and Concepts
- Chapter 5: Getting Started: Thinking Outside the Cell
- Chapter 6: Visual Basic for Applications for Excel, a Refresher
- Chapter 7: Avoiding Common Pitfalls in Development and Design
- Chapter 8: The Elements of Good Excel Dashboards and Decision Support Systems
- Part III: Formulas, Controls, and Charts
- Chapter 9: Introducing Formula Concepts
- Chapter 10: Advanced Formula Concepts
- Chapter 11: Metrics: Performance and Context
- Chapter 12: Charts with Heart (or, How to Avoid a Chart Attack)
- Chapter 13: Creating an Interactive Gantt Chart Dashboard
- Chapter 14: An Interactive Gantt Chart Dashboard, Data Visualization
- Chapter 15: An Interactive Gantt Chart Dashboard, Data Details on Demand
- Part IV: From User Interface to Presentation
- Chapter 16: Working with Form Controls
- Chapter 17: Getting Input from Users
- Chapter 18: Storage Patterns for User Input
- Chapter 19: Building for Sensitivity Analysis
- Chapter 20: Perfecting the Presentation
- Part V: Data Models, PowerPivot, and Power Query
- Chapter 21: Data Model Capabilities of Excel 2013
- Chapter 22: Advanced Modeling with Slicers, Filters, and Pivot Tables
- Chapter 23: Introduction to Power Query
- Chapter 24: Introduction to PowerPivot
- Index
About the Authors
Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author, speaker, and CEO. He is the owner of Cambia Factor, a data consulting agency, and a talent analyst for Ernst & Young. He is the author of Advanced Excel Essentials, a book on developing advanced analytics with Excel. He has consulted with and provided training for NATO Training Mission, the Pentagon, Air Force and Navy, Financial Times, University of Cincinnati, and others. His work has been cited by and quoted in the Associated Press, Bloomberg BusinessWeek, Dice News, and American Express OPEN Forum. He has held the prestigious MVP award from Microsoft since 2013 and is an owner and producer of Excel.TV, an online community devoted to sharing the stories, setbacks, and lessons from experts and practitioners in Excel, business intelligence, big data, and analytics.
Purnachandra “Chandoo” Duggirala is an author, speaker, blogger, teacher, and CEO. He is the creator of one of the most popular Excel and data analytics blogs, Chandoo.org, where he helps people become awesome in Excel. He is the author of The VLOOKUP Book, a book on various lookup formulas in Excel. He has worked as a consultant and trainer for many reputed organizations around the world, including Microsoft, KPMG, CapGemini, Novartis, and so on. He has held the prestigious MVP award from Microsoft since 2009. He lives in India and likes to travel, bicycle, and play with LEGOs in his free time.
-
No Comment