I have a specific impedance mismatch where data is stored in normalized fashion:
customer | Year | Value -------------------------- Fu 2007 9000000 Fu 2008 10000000 times 2008 20000000 Fu 2009 12000000 times 2009 15000000
But Users consume, visualize and understand it in a disproved fashion:
Customer | 2007 values | 2008 values | 2009 Price --------------------------------------------- Fu 9000000 10000000 12000000 times - 20000000 15000000
Which is all right and good - I have many types of solutions, which meet the data between rendering and firmness to roam and explore. However, in the case of the real world, there are dozens of columns denormalized rendering, which is used to get used and carry people around the head.
Keeping this in mind that the user currently does not want to mess with his denormalized forest, and that I try to change it, for a better presentation of detailed table data What are the strategies? I know that this is not a new problem, but I do not know where the good insight is from.
I'm not looking for a specific answer for a single presentation environment. Regardless of the comprehensive presentation of data in web browser or spreadsheet, it is just a mentally difficult task and I am looking for general strategies or current changes- or pointers for resources- to reduce that difficulty.
A picture can go a long way, a graph of data can provide to the people that they Generally looking at - Patterns and abnormalities In the case of your denormalized data table, I suggest adding a spark chart on each line which shows all the values. By looking at this list it can see how different values have changed.
Some examples of people here use inline charts in these figures, which provide visual numbers of difficult numbers:
Edward Tupe There are some extraordinary guidelines for viewing statistics, see their Wikipedia page.
Comments
Post a Comment