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
Matt Mower and added
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
Tom Critchlow added
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
dane cads added
Tom Critchlow added
Often dashboard creators are “outsiders” such as consultants, and they don’t have deep practitioner experience for understanding the entrenched issues within the company, such as the previous three issues. Therefore, they make common mistakes that lead to unactionable dashboards and a loss of credibility.
Avinash Kaushik • Web Analytics 2.0: The Art of Online Accountability and Science of Customer Centricity
Tom Critchlow added
