1 st october 2010 save the pies for lunch! visualising data with sql server reporting services tim...
TRANSCRIPT
![Page 1: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/1.jpg)
1st October 2010
Save the Pies for Lunch!Visualising Data with SQL Server Reporting Services
@timk_adatishttp://blogs.adatis.co.uk
![Page 2: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/2.jpg)
Visualising Data with SQL Server Reporting Services
Agenda
Definition of a dashboard\report
Principles of good design
SQL Server Reporting Services demo
2008 R2 Maps
Report Management
Report Builder
![Page 3: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/3.jpg)
Visualising Data with SQL Server Reporting Services
SSRS as a Visualisation Tool?
![Page 4: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/4.jpg)
Visualising Data with SQL Server Reporting Services
Definition of a Dashboard
Visual Displayof
The most important information needed to achieve objectives
which
Fits entirely on a single screenso it can be
Monitored at a glance
![Page 5: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/5.jpg)
Visualising Data with SQL Server Reporting Services
Definition of a Dashboard
![Page 6: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/6.jpg)
Visualising Data with SQL Server Reporting Services
Brrrm Brrrm
![Page 7: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/7.jpg)
Visualising Data with SQL Server Reporting Services
Keep everything on one screen
![Page 8: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/8.jpg)
Visualising Data with SQL Server Reporting Services
Demo
Output Control
![Page 9: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/9.jpg)
Visualising Data with SQL Server Reporting Services
Meaningless without context
Compared to what?
Avoid too much context!
![Page 10: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/10.jpg)
Visualising Data with SQL Server Reporting Services
Use the correct measure Actual vs Budget isn’t always useful
![Page 11: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/11.jpg)
Visualising Data with SQL Server Reporting Services
Use the correct measure Use Labels appropriately
Think about what you are trying to tell your user
![Page 12: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/12.jpg)
Visualising Data with SQL Server Reporting Services
Demo
Variance Graphs
![Page 13: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/13.jpg)
Visualising Data with SQL Server Reporting Services
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?
![Page 14: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/14.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph? Bar – show values with categorical axis
Line – show trends with interval axis
Pie – always something better
![Page 15: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/15.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph? Sparklines – ensure detail is available
Gauges – rarely appropriate
Exception is bullet graphs
![Page 16: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/16.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph?
Scatter Graphs – use for showing spread\correlation of data
Bump graphs – for showing wins and losses over intervals
![Page 17: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/17.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph? Lattice Charts\Small Multiples
![Page 18: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/18.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph?
Heatmaps
Icon Charts
![Page 19: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/19.jpg)
Visualising Data with SQL Server Reporting Services
What type of graph?
Radar Graphs \ Polar Graphs
Box Plots
![Page 20: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/20.jpg)
Visualising Data with SQL Server Reporting Services
Demo
Bump Charts
![Page 21: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/21.jpg)
Visualising Data with SQL Server Reporting Services
The Data-Ink Ratio
Remove all unnecessary non-data pixels
De-emphasize any non-data pixels that remain
Remove all unnecessary data pixels!
![Page 22: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/22.jpg)
Visualising Data with SQL Server Reporting Services
Avoid “Decoration”
Statistics don’t have to be boring!
![Page 23: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/23.jpg)
Visualising Data with SQL Server Reporting Services
Avoid “Decoration” Colour
![Page 24: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/24.jpg)
Visualising Data with SQL Server Reporting Services
Avoid “Decoration” 3d
![Page 25: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/25.jpg)
Visualising Data with SQL Server Reporting Services
Avoid “Decoration”
Gridlines and Borders
![Page 26: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/26.jpg)
Visualising Data with SQL Server Reporting Services
What remains?
Use legible fonts
Avoid excessive detail or precision
Drill to detail where required
Highlight what’s important
Sales Sales Sales£565,692 £565,692 £565,692
![Page 27: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/27.jpg)
Visualising Data with SQL Server Reporting Services
Demo
Indicators
![Page 28: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/28.jpg)
Visualising Data with SQL Server Reporting Services
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
![Page 29: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/29.jpg)
Visualising Data with SQL Server Reporting Services
Questions
![Page 30: 1 st October 2010 Save the Pies for Lunch! Visualising Data with SQL Server Reporting Services Tim Kent tim.kent@adatis.co.uk @timk_adatis](https://reader035.vdocuments.us/reader035/viewer/2022062404/55164ad05503469d698b490b/html5/thumbnails/30.jpg)
Visualising Data with SQL Server Reporting Services
Resources
Resources
Stephen Few – Information Dashboard Design
Edward Tufte - The Visual Display of Quantitative Information
Adatis Blogs – blogs.adatis.co.uk