Slicing & Dicing: Difference between revisions

m
no edit summary
mNo edit summary
mNo edit summary
Line 22: Line 22:
: Calculate useful information — such as totals, averages, maximums, and minimums — across all entries in the library. During slicing & dicing, these calculations can become subcalculations for subsets of library entries in addition to the bottom calculations for the overall library.
: Calculate useful information — such as totals, averages, maximums, and minimums — across all entries in the library. During slicing & dicing, these calculations can become subcalculations for subsets of library entries in addition to the bottom calculations for the overall library.


== Slicing & Dicing ==
== Slicing & Dicing — ad hoc data analysis ==
Once the libraries are set up, and data is entered, the job of viewing the data and making sense of it is at hand. While viewing the list of library entries, the following activities will give you the best possible look at the data and any wisdom that may be contained within it.
Once the libraries are set up, and data is entered, the job of viewing the data and making sense of it is at hand. While viewing the list of library entries, the following activities will give you the best possible look at the data and any wisdom that may be contained within it.
=== Final bit of setup ===
First, consider the tools that you define & store for later use.


; Filters
; Filters
: First, you can restrict your investigation to a portion of the entries in the library. For example, you can filter to view orders only for a particular customer or gasoline only for your current car. Filters are defined & stored, so create those you may want to use later, during ad hoc data analysis.
: First, you can restrict your investigation to a portion of the entries in the library. For example, you can filter to view orders only for a particular customer or gasoline only for your current car. Filters are defined & stored, so save those you may want to use later.


; Charts
; Charts
: Another tool Memento provides for data analysis is charting the data. Memento charting is very flexible, providing visual views of the data. Since charts are also defined & stored, define those that might be the most helpful during subsequent ad hoc data analysis.
: Another tool Memento provides for data analysis is charting the data. Memento charting is very flexible, providing visual views of the data. Since charts are also defined & stored, save those that might be the most helpful during subsequent analysis.
 
=== Ad hoc data analysis (finally) ===
Now we're ready for the slicing & dicing you'll do anew every time you want to look at your data.


; Grouping
; Grouping