AGE, MINIMUM, or MAXIMUM, such as number of customers, total sales dollars or average quantity. An aggregation is typically organized or grouped by another column, such as sum of sales by region, or average quantity of product line B sold by sales rep. By placing an index on aggregated values, performance can be enhanced. Summary Data is the building block for useful information. With access to accurate and timely information, appropriate business decisions can be made to maximize profit and gain competitive advantage over other competitors. Most companies today have no shortage of data; however, the data exists in the form that is difficult for human access or interpretation. The challenge lies in transforming the data into useful information. With the data warehousing technology, the means of achieving this is possible....
