Visual Report Design Bringing Sexy Back Paul Turley

Visual Report Design Bringing Sexy Back Paul Turley Mentor, Solid. Q October 11 -14, Seattle, WA

Principles of Effective Design Visual Design Skills Form Technical Development Skills Functional Business Skills Fit Function BID-304 -S | Visual Report Design 2

Balance & the Zen of Report Design BID-304 -S | Visual Report Design 3

Examples The “Australian Sparkline” Scorecard with integrated map BID-304 -S | Visual Report Design 4

Business Intelligence Self-Service Reporting • Share. Point • Excel & Excel Services • Performance Point • Power. Pivot • BISM Tabular Models • Report Builder 3. 0 • Project Crescent BID-304 -S | Visual Report Design 5

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 6

Demonstrations Color scales Dashboard design Map reports Crescent BID-304 -S | Visual Report Design 7

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 8

Keep Balance BID-304 -S | Visual Report Design 9

Know Your Audience BID-304 -S | Visual Report Design 10

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 11

Questions & Resources My Blog ……………… Sql. Server. Bi. Blog. com Book downloads…. . . Wrox. com View reports online. . . Report. Surfer. com Solid. Q Journal……… Solid. Q. com/sqj articles & whitepapers Questions? BID-304 -S | Visual Report Design 12

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 13

Thank you for attending this session and the 2011 PASS Summit in Seattle October 11 -14, Seattle, WA