Excel Dashboards and Reports (Mr. Spreadsheet's Bookshelf)
The most effective reports and presentations are simple, direct, and visualize data that asks the right questions and supplies answers. Invest time in training yourself about data visualization techniques. If you need inspiration, visit the New York Times Visualization Lab (http://zqi.me/nytvlab).
Avinash Kaushik • Web Analytics 2.0: The Art of Online Accountability and Science of Customer Centricity
Often dashboards are 28-tab Excel files or 34-slide PowerPoint decks. In either format, you track too many metrics and rarely segment and highlight performance, which makes it impossible for others to distill a cogent meaning from what happened and take action.
Avinash Kaushik • Web Analytics 2.0: The Art of Online Accountability and Science of Customer Centricity
Good dashboards anticipate followups. A good dashboard says, "This dip, right here, which I know sticks out immediately? It was caused by our pricing change." A bad dashboard leaves the user wondering, "What happened then?" A good dashboard makes rates of change — week-over-week, year-over-year — immediately apparent. A bad dashboard leaves the use... See more
Andrew Bartholemew • Good dashboard, bad dashboard — Andrew Bartholomew
1. Strive for graphical integrity2. Maximize Data Ink3. Avoid Chart Junk4. Aim for High Data Density5. Use Classic Design Solutions6. Apply Aesthetics & Technique
Anil Bas • Lessons from Edward Tufte
Be smart with color. The use of color should always be an intentional decision; use color sparingly and strategically to highlight the important parts of your visual. Pay attention to alignment. Organize elements on the page to create clean vertical and horizontal lines to establish a sense of unity and cohesion. Leverage white space. Preserve marg
... See moreCole Nussbaumer Knaflic • Storytelling With Data
