Erik Danielsson +47 97 06 85 42 erik@quantumsolutions.no Product Responsible - Proteus

1. Presentation 3:Various ways to increase the information density in Planning/Management data, while making it more “understandable”. Erik Danielsson • +47 97 06 85 42 • erik@quantumsolutions.no Product Responsible - Proteus Quantum Solutions AS • 30 minutes - October 2009

2. Proteus Various ways to increase the information density in Planning/Management data, while making it more “understandable”.

3. 1. Introduction2. What is “Information Density” anyway?3. Techniques to increase information density4. Summary

4. Proteus Introduction – The shortest mail correspondence in history

5. 1. Introduction2. What is “Information Density” anyway?3. Techniques to increase information density4. Summary

6. Proteus What is information density (ID) anyway?? The Proteus approach to pin down a definition (first some terminology): • The raw (non manipulated) data set – No properties have been highlighted. • The “enhanced” data set - Property X has been highlighted. • When talking about ID one always relates this to a particular property, X – one particular set of glasses to look at data with. • Let’s call the time it takes for the brain to determine Property X for a set of raw data, T1. • Let’s call the time it takes for the same brain to determine Property X for the enhanced set, T2 • Finally the definition of ID: • ID = T1/T2 • Example: If it takes 10 seconds to find even numbers in a 3x3 matrix of numbers, and 1 second if they are colored red, then ID = 10/1 = 10. • Conclusion so far: The higher the ID, the less we have to strain the brain...

7. Proteus Examples of increased information density (ID) Raw data: ID = 1 Even numbers: ID = 20 Prime Numbers: ID = 50 Large Prime Numbers: ID = 100 000

8. Proteus Using coloring to increase ID Raw data: ID = 1 Magnitude mapped to bar width Magnitude mapped to 3 arrows Magnitude (3 bands): ID = X Magnitude (10 bands): ID > X? Magnitude as spectrum: ID > X?

9. Proteus Increased ID for more than one property Raw data: ID = 1 Magnitude mapped to fontsize Magnitude mapped to fontsize + “Primeness” to red background Magnitude mapped to fontsize and color bands

10. Proteus Other common ways you increase ID... (without knowing it?) • These transformations on raw data constitute the 6 primitives for improving ID: • Conditional formatting – highlight a property of interest • Filtering –How long would it take to find all values between 10 and 20 in a set of 1000 numbers? • Showing list of unique values – a prerequisite for “drill downs” • Sorting - How long will it take you to find the 5 smallest values in 1000 numbers? • Aggregating - (how long would it take you to add 1000 numbers?) • Graphing – showing numbers as spatial entities. • Grouping (same as showing list of unique and sorted values but with expandable details) • - Show how the Gantt-Grid in Proteus contains the first 5 of these.

11. Proteus • Conditional Formatting

12. Proteus • Filtering & Showing list of unique values

13. Proteus • Sorting and Aggregating (& Grouping)

14. Proteus Using the 6 primitives in conjunction with spatial arrangements... • Lets recap the 6 primitives for improving ID: • Conditional formatting – highlight a property of interest • Filtering –How long would it take to find all values between 10 and 20 in a set of 1000 numbers? • Showing list of unique values – a prerequisite for “drill downs” • Sorting - How long will it take you to find the 5 smallest values in 1000 numbers? • Aggregating - (how long would it take you to add 1000 numbers?) • Graphing – showing numbers as spatial entities. • When using these primitives in conjunction with spatial arrangements, we can really get some remarkable ID boosts! • We will look at 2 important examples...

15. Proteus Pivoting Pivoting: Each of the dimensions (X, Y) show unique, sorted values, and each intersecting cell represents a filtered and aggregated value. Adding graphing improves ID even further!

16. Proteus Completion Report The Completion Report: Each planning object is located in a grid where its horizontal location (column) says when in time it should be complete (a list sorted in time), the values within column are sorted in value, and conditional formatting of cell’s value further enhances ID. In addition, there are summary rows for each conditional format showing aggregated number of “hits” for it. Tooltips can help giving any detail info of relevance (including hierarchical “drill down”).

17. Proteus Completion Report – how its set up... The Proteus Configurator lets Administrator set up Completion Reports with any number of formatting criteria.

18. Proteus Mapping important “facts” to visual elements “Instant experience” can in a sense be given by coding important facts to visual elements in Gantt Chart. The Gantt chart at left use the following mappings to increase ID: A blue bar indicates the time-range of all child elements. It is hatched if the children are outside of parent range. A red frame is shown if the object is more than 5 days behind schedule, and it indicates where it should be located in time. The objects having more than 10 000 planned hours are red (as starting color gradient). The transparency of starting gradient color is higher the less hours an object has – i.e object with more hours are “more visible”.

19. 1. Introduction2. What is “Information Density” anyway?3. Techniques to increase information density4. Summary

20. Proteus Summary conclusion: The various techniques of increasing Information Density is to a large degree an “untapped grail” in the professional community... By letting professional people (planners, PM, CC) SEE what the data means instead of having to strain their brains to deduce this meaning, a tremendous amount of time can be saved, and mental energy used creatively on other things... The Proteus challenge: If your project team sits down and brainstorms up N ways that your project could increase the ID in its data, Proteus should be able to accommodate all of these quite easily...!