Overview: The Product Dimension

The Product dimension in the Adventureworks database consists of quite a few tables.

For this Training we will denormalize ProductModel, ProductCategory, and ProductSubcategory tables into the Product table.

Many of the records in the product table are not associated with any model or category. In these cases we will clean up the data by replacing Null values with "None"

In addition, the product table contains a collection of entries only used for work orders which we wish to exclude for analysis. These records are identified by the "FinishedGoodsFlag" field, 1 indicating finished goods and 0 for unfinished goods.