Sample data module

This data module is a combination of two source files that are not joined:

• Sample File Go Sales xls: SampleFile_GOSales.xls
• Sales Staff Xlsx: Sales_Staff.xlsx

The table named Sample File Go Sales xls contains two calculated columns. The first column is named Product line code. It uses a case statement to assign a specific code to each product line:

case
when ( Product_line ) = 'Camping Equipment' then (991)
when ( Product_line ) = 'Mountaineering Equipment' then (992)
when ( Product_line ) = 'Personal Accessories' then (993)
when ( Product_line ) = 'Outdoor Protection' then (994)
else (995)
end

The second calculated column is named Product type code:

case
when (Product_type) = 'Cooking Gear' then (951)
when (Product_type) = 'Tents' then (952)
when (Product_type) = 'Packs' then (954)
when (Product_type) = 'Rope' then (956)
when (Product_type) = 'Climbing Accessories' then (958)
when (Product_type) = 'Watches' then (960)
when (Product_type) = 'Knives' then (962)
when (Product_type) = 'Navigation' then (964)
when (Product_type) = 'Sunscreen' then (966)
when (Product_type) = 'Irons' then (968)
when (Product_type) = 'Putters' then (970)
when (Product_type) = 'Golf Accessories' then (971)
when (Product_type) = 'Sleeping Bags' then (953)
when (Product_type) = 'Lanterns' then (955)
when (Product_type) = 'Safety' then (957)
when (Product_type) = 'Tools' then (959)
when (Product_type) = 'Eyewear' then (961)
when (Product_type) = 'Binoculars' then (963)
when (Product_type) = 'Insect Repellents' then (965)
when (Product_type) = 'First Aid' then (967)
when (Product_type) = 'Woods' then (969)
end