>
Enterprise Reporting Test - The Data
The data for this test is pretty simple and fairly standard sales data.  There are two tables, although in reality there could be many more.  The Sales Table could have millions of rows.  A fact were are not considering in these tests, but one you need to consider.  So there are two tables - a sales table and a model table.  The sales table has information on sales.  The model table maps SKUs to product lines.   The tables are laid at below.

Sales Table
Date
SKU
Sales Units
Sales Dollars
Sales Margin
SKU Table
SKU
Alpha SKU Description
Product Line

Let's go to the first test.  Period to Period comparisons. 

First some quick questions.