Lesson 11 – complex data presentation

Overview

In this lesson we get to know more complex data diagrams, which are properly suited for “intergroup” analysis.

Trellis

Trellis graphs serve the same visualization with a uniform scale to visualize different categories.

Screenshot 2015-03-31 21.12.50

You can decide yourself which dimensions you want to “distinguish”.

Screenshot 2015-03-31 21.54.50

In the advanced settings you can define the quantity per column and line.

 Tables with conditioanl formatting

Keep in mind, these visualizations ONLY work with the graph type “Table”!

Screenshot 2015-03-31 21.13.02

This form of visualization has proven it’s worth “exclusively” for power-useers. Otherwise the information density would be too high to keep track.

 Sparklines

Also ONLY possible with graph type “table”. Exception: you can also integrate these so called “mini-diagrams” in a listbox.

Screenshot 2015-03-31 21.13.28

Tachometer

Screenshot 2015-03-31 21.13.41

Exercises

  • Build a simple Dashboard with 5 or less than 5 KPIs.
  • Look out for all the “mischiefs” and eliminate them.

We advise you to orient yourself with modern “CSS-Web-Frameworks”. For example – Microsoft Metro UI or Twitter Bootstrap.

Leave a Reply