How:Slice & Dice Library Data: Difference between revisions

Jump to navigation Jump to search

How:Slice & Dice Library Data (view source)

Revision as of 15:01, 28 October 2016

775 bytes added ,  28 October 2016
m
no edit summary
mNo edit summary
mNo edit summary
Line 112: Line 112:
: Another tool Memento provides for data analysis is charting the data. Memento charting is very flexible, providing visual views of the data.
: Another tool Memento provides for data analysis is charting the data. Memento charting is very flexible, providing visual views of the data.


=== Ad hoc analysis ===
=== Ad hoc analysis (finally) ===
This is where you view the data however you can to see various aspects of the data in different ways. Generally, as time moves forward and you data grows and/or moves forward in time, you can notice trends and detect patterns that you might not have anticipated and which inform your decisions regarding the process your data represents.
 
; Filtering
: Choose from the list of filters you've previously defined to focus in on the data you want to analyze, or choose no filter to analyze all the data. It is best here to be as inclusive as possible, so don't over-filter. For now, let's not filter, or choose the Consumers filter or whichever filter yields you the most test data.


; Grouping
; Grouping
: Then, within the filtered data, you may want to see certain data sparsely from others, such as orders of certain products or fuel purchases from certain gas stations. If you group your order entries by product or your fuel purchase entries by gas station, you can then not only see them separately and quickly switch between them, but aggregations will be displayed for each, in addition to aggregation of the entire set.
: Then, group by '''Customer type''' and see how consumer data compares to institutional data. Do they both make sense? Are there any surprises?
: Then, group by '''Customer zip'''. Are people in the east buying differently from people in the west?
: Then, group by '''Product category'''. Are you more profitable selling lumber or tools? Can the margins be increased within either category?


; Sorting
; Sorting
: With sorting, you can determine the order of entries, and if grouped, the order of the groups and the order of entries within groups.
: Use sorting primarily to maintain a meaningful order of groups and within groups and also to make the '''No grouping''' list the most useful. Sorting by numeric values can make the largest stand out from the smallest while grouping this way and that.


=== Putting it all together ===
=== Putting it all together ===
Retrieved from "https://wiki.mementodatabase.com/index.php?title=Special:MobileDiff/1445"

Navigation menu