Dashboards for Excel. ([2015])

• Record Type: Book
• Further Information: Note: Jordan Goldmeier, Purnachandra Duggirala.
• Authors: Goldmeier, Jordan; Duggirala, Purnachandra
• 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; The Data Problem; Enter Excel: The Most Dangerous Program in the World; Not Realizing How Far Spreadsheets Have Come; Garbage In, Gospel Out ; How Excel Fits In ; A Commercial-Off-the- Shelf Solution; Flexible and Customizable ; Familiarity and Ubiquity ; Inexpensive-ish ; Quick Turnaround Time ; A Good Return on Investment ; What Excel Isn't Good For. A Full-Fledged Database Enterprise-Level Reporting ; A Full Software Package; Predicting the Future; Buzzword Bingo: Dashboards, Reports, Data Visualization, and Others; Dashboards; Decision Support Systems; The Excel Development Trifecta ; Good Visualization Practices; Good Development Practices; Thinking Outside the Cell ; Available Resources; The Last Word; 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; Radial Gauges ; So Many Metrics, So Little Working Memory; Is the Logo Necessary? ; Visualizations That Look Cool but Just Don't Work; Data Journalism ; Why These Examples Are Important; The Last Word; Chapter 3: The Principles of Data Visualization in Microsoft Excel; What Is Visual Perception and How Does It Work?; Perception and the Visual World; Our Bias Toward Forms: Perception and Gestalt Psychology ; Similarity. ProximityClosure; Common Groups of Shapes and Points; Continuation; The Preattentive Attributes of Perception; Color Attributes ; High-Precision Judging ; Lower Precision, but Still Useful; The Last Word; Chapter 4: The Excel Data Presentation Library; Tables ; Line and Bar Charts ; Scatter Charts; Scatter Charts vs. Line Charts ; Correlation Analysis ; Correlation Fit and Coefficient ; Linear Relationship and Using R2 Correctly; Bullet Graphs ; Small Multiples ; Charts Never to Use; Cylinders, Cones, and Pyramid Charts ; Pie Charts ; Doughnut Charts. Charts in the Third Dimension Surface Charts ; Stacked Columns and Area Charts ; Radar Charts ; The Last Word; Part II: Excel Dashboard Design Tools and Concepts; Chapter 5: Getting Started: Thinking Outside the Cell; House Hunters: Excel Edition; The Purely VBA Method; The Semi-code Method; Say Cheese: Introduction to the Camera Tool ; Using the Camera Tool; The No-Code Method; Sorting; The Rollover Method; Rollover Method Basics; Implementing the Rollover Method; The Last Word; Chapter 6: Visual Basic for Applications for Excel, a Refresher.
• Publisher Details: New York : Apress
• Publication Date: 2015
• Copyright Date: 2015
• Extent: 1 online resource (1 volume), illustrations
• Subjects: 658.4/038011; Computer science; Dashboards (Management information systems); Statistics -- Charts, diagrams, etc; Business report writing; Microsoft software; Microsoft .NET Framework; Information systems; Business report writing; Dashboards (Management information systems); Statistics; Computers -- Online Services -- General; Computer networking & communications; Computers -- Programming -- Microsoft Programming; Microsoft programming; Electronic books; Charts, diagrams, etc
• Languages: English
• ISBNs: 9781430249450; 1430249455; 1430249447; 9781430249443
• Related ISBNs: 9781430249443
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.