Dashboards for Excel. ([2015])
- Record Type:
- Book
- Title:
- Dashboards for Excel. ([2015])
- Main Title:
- Dashboards for Excel
- 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 PrinciplesAt 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. … (more)
- 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.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.371353
- Ingest File:
- 03_018.xml