140 likes | 364 Views
Visual Report Design. Bringing Sexy Back. Paul Turley. Mentor, SolidQ. Principles of Effective Design. Visual Design Skills. Technical Development Skills. Functional Business Skills. Balance & the Zen of Report Design. Examples. The “Australian Sparkline”. Scorecard with integrated map.
E N D
Visual Report Design Bringing Sexy Back Paul Turley Mentor, SolidQ
Principles of Effective Design Visual Design Skills Technical Development Skills Functional Business Skills BID-304-S | Visual Report Design
Balance & the Zen of Report Design BID-304-S | Visual Report Design
Examples The “Australian Sparkline” Scorecard with integrated map BID-304-S | Visual Report Design
Business Intelligence • Self-Service Reporting • SharePoint • Excel & Excel Services • Performance Point • PowerPivot • BISM Tabular Models • Report Builder 3.0 • Project Crescent BID-304-S | Visual Report Design
Color Palettes • Stephen Few • Use color in context • Color should be meaningful • Don’t clutter, keep design simple perceptualedge.com COLOURLovers.com BID-304-S | Visual Report Design
Demonstrations Color scales Dashboard design Map reports Crescent BID-304-S | Visual Report Design
Don’t Go To Extremes Does “dashboard” really mean that it has to look like the CEO’s Jaguar? Can an executive business user consume this information in 5 seconds? Are 3-D charts really THAT cool? BID-304-S | Visual Report Design
Keep Balance BID-304-S | Visual Report Design
Know Your Audience BID-304-S | Visual Report Design
Principles of Effective Design • Know Your Audience • Executive analytical reports: 5 second consumption • Operational analytic reports: enable deep exploration • Prioritize Objectives • Maintain Balance • Consider Trade-Offs: super reports & simple reports • Don’t take visuals too far • Use POCs & throw them away • Get a Second Opinion • Accept Feedback & Be Willing to Learn BID-304-S | Visual Report Design
Questions & Resources My Blog ……………… SqlServerBiBlog.com Book downloads…... Wrox.com View reports online... ReportSurfer.com SolidQ Journal……… SolidQ.com/sqjarticles & whitepapers Questions? BID-304-S | Visual Report Design
Complete the Evaluation Form to Win! • Win a $100 gift card – every day – just for handing in your completed form. Each session evaluation form represents a chance to win. • Pick up your evaluation form: • In each presentation room • Online on the PASS Summit website • Drop off your completed form: • Near the exit of each presentation room • At the Registration desk • Online on the PASS Summit website BID-304-S | Visual Report Design
Thank you for attending this session and the 2011 PASS Summit in Seattle