| Table name | Short description |
| AuditPkgExecution | Receives a row each time an Integration Services package is executed |
| AuditTableProcessing | Audit dimension tags each data row with the the process that added or updated it. |
| DimAudit | Audit dimension tags each data row with the the process that added or updated it. |
| DimCurrency | Dimension table that itemizes different currencies |
| DimCustomer | The Customer dimension includes all Adventure Works customers |
| DimDate | Date dimension contains one row for every day, beginning at 1/1/2000. There may also be rows for "hasn't happened yet." |
| DimEmployee | Employee info, including sales territory for sales reps |
| DimOrderInfo | OrderInfo is the "junk" dimension that includes miscellaneous information about the Order transaction |
| DimProduct | Information about products |
| DimPromotion | Contains information about marketing promotions |
| FactExchangeRates | FactExchangeRates captures daily exchange rates to/from USD |
| FactOrders | FactOrders captures order transactions at the order line item level |