jump to navigation

What other data aggregate functions are useful besides averages and means? September 19, 2007

Posted by Peter Benza in Data Aggregates, Data Consolidation, Data Elements, Data Errors, Data Research.

(Be first to author an article on this topic.)


1. Mark Besaans - December 27, 2008

Obviously sums are also useful for comparing hash totals of two data sets at a compatible aggregated key level. This merely identifies that a problem exists. The trick is to produce a current exception spreadsheet based on differences detected at the lowest level, that can be used to analyze, identify and rectify causes. I have developed an Enterprise Utility in Java that does just this, which is in broad use at a listed South African Retailer today.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: