Microsoft® SQL Server 2012 Unleashed

CompSales International Requirements

A large computer manufacturer named CompSales International needs to do basic analytical processing of its product data in a new BI environment. The main business issues at hand are related to minimizing channel inventory and better understanding market demand for the company’s most popular products. The detailed data processing requirements are as follows:

1. You want to view sales unit actuals and sales returns for system and nonsystem products for the past two years via the product hierarchy (All Products, Product Types, Product Lines, Product Families, SKUs), geography hierarchy (All Geos, Major Geos, Countries, Channels, Customers), and different time levels (All Time, Years, Quarters, Months).

2. You ...