1 / 30

Save the Pies for Lunch!

Save the Pies for Lunch!. Visualising Data with SQL Server Reporting Services. 1 st October 2010. Tim Kent tim.kent@adatis.co.uk @ timk_adatis http://blogs.adatis.co.uk. Agenda. Definition of a dashboardeport Principles of good design SQL Server Reporting Services demo 2008 R2 Maps

aimon
Download Presentation

Save the Pies for Lunch!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services 1st October 2010 Tim Kent tim.kent@adatis.co.uk @timk_adatis http://blogs.adatis.co.uk

  2. Agenda • Definition of a dashboard\report • Principles of good design • SQL Server Reporting Services demo • 2008 R2 Maps • Report Management • Report Builder

  3. SSRS as a Visualisation Tool?

  4. Definition of a Dashboard Visual Display of The most important information needed to achieve objectives which Fits entirely on a single screen so it can be Monitored at a glance

  5. Definition of a Dashboard

  6. BrrrmBrrrm

  7. Keep everything on one screen

  8. Demo Output Control

  9. Meaningless without context Compared to what? Avoid too much context!

  10. Use the correct measure Actual vs Budget isn’t always useful

  11. Use the correct measure Use Labels appropriately Think about what you are trying to tell your user

  12. Demo Variance Graphs

  13. Use Effective Display Media • Avoid Variety for the sake of variety • It’s OK to only have one type of graph • Don’t be frightened of tables • What type of graph should I use?

  14. What type of graph? • Bar – show values with categorical axis • Line – show trends with interval axis • Pie – always something better

  15. What type of graph? • Sparklines – ensure detail is available • Gauges – rarely appropriate • Exception is bullet graphs

  16. What type of graph? • Scatter Graphs – use for showing spread\correlation of data • Bump graphs – for showing wins and losses over intervals

  17. What type of graph? • Lattice Charts\Small Multiples

  18. What type of graph? • Heatmaps • Icon Charts

  19. What type of graph? • Radar Graphs \ Polar Graphs • Box Plots

  20. Demo Bump Charts

  21. The Data-Ink Ratio Remove all unnecessary non-data pixels De-emphasize any non-data pixels that remain Remove all unnecessary data pixels!

  22. Avoid “Decoration” Statistics don’t have to be boring!

  23. Avoid “Decoration” Colour

  24. Avoid “Decoration” 3d

  25. Avoid “Decoration” Gridlines and Borders

  26. What remains? • Use legible fonts • Avoid excessive detail or precision • Drill to detail where required • Highlight what’s important

  27. Demo Indicators

  28. Summary Consider your display Media Remember your user’s objectives Everything on a single screen Information at a glance Simplicity, Simplicity, Simplicity Reporting Services is a fully featured visualisation tool Good dashboard design is a hard sell

  29. Questions

  30. Resources • Resources • Stephen Few – Information Dashboard Design • Edward Tufte - The Visual Display of Quantitative Information • Adatis Blogs – blogs.adatis.co.uk

More Related