| Description |
1 online resource (1 volume) : illustrations |
| Note |
"Deliver critical information and insight at the speed of a click"--Cover |
|
Includes index. |
| Summary |
This book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. The reader is challenged to think about Excel and data analytics differently. You will learn how to: apply data visualization principles for more effective dashboards; employ dynamic charts and tables to create dashboards that are constantly up-to-date and providing fresh information; use understated yet powerful formulas for Excel development; apply advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards; create dynamic systems for decision support in your organization; avoid common problems in Excel development and dashboard creation; get started with the Excel data model, PowerPivot, and Power Query. -- Edited summary from book. |
| 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. |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Dashboards (Management information systems)
|
|
Statistics -- Charts, diagrams, etc.
|
|
Business report writing.
|
|
Tableaux de bord (Gestion) |
|
Statistique -- Tableaux, graphiques, etc. |
|
Style commercial. |
|
Computer networking & communications. |
|
Microsoft programming. |
|
Business report writing |
|
Dashboards (Management information systems) |
|
Statistics |
|
Excel (Programa de aplicación) |
|
Hojas de cálculo. |
|
Negocios. |
| Genre |
Charts, diagrams, etc.
|
| Added Author |
Duggirala, Purnachandra, author.
|
| Other Form: |
Print version: Goldmeier, Jordan. Dashboards for Excel. [New York] : Apress, [2015] 9781430249443 (OCoLC)924548884 |
| ISBN |
9781430249450 |
|
1430249455 |
|
1430249447 |
|
9781430249443 |
|
More Resources