Databases Reference
In-Depth Information
CHAPTER
5
Example Data Warehouse
Overview of Orion Star Sports & Outdoors
43
Asking the Right Questions
44
Possible High-Level Questions
44
Which Salesperson Is Making the Most Sales?
45
Identifying Relevant Information
45
Identifying Sources
45
Source for Staff Information
45
Source for Organization Information
46
Source for Order Information
46
Source for Order Item Information
47
Source for Customer Information
47
Identifying Targets
48
Target That Combines Order Information
48
Target That Combines Organization Information
48
Target That Lists Total Sales by Employee
48
Creating the Report
48
What Are the Time and Place Dependencies of Product Sales?
49
Identifying Relevant Information
49
Identifying Sources
49
Sources Related to Customers
49
Sources Related to Geography
50
Sources Related to Organization
50
Sources Related to Time
50
Identifying Targets
50
Target to Support OLAP
50
Target to Provide Input for the Cube
51
Target That Combines Customer Information
51
Target That Combines Geographic Information
51
Target That Combines Organization Information
51
Target That Combines Time Information
51
Building the Cube
51
The Next Step
51
Overview of Orion Star Sports & Outdoors
Orion Star Sports & Outdoors is a fictitious international retail company that sells
sports and outdoor products. The headquarters is based in the United States, and retail
stores are situated in several other countries including Belgium, Holland, Germany, the
United Kingdom, Denmark, France, Italy, Spain, and Australia. Products are sold
through physical retail stores, as well as through mail-order catalogs and on the
Search WWH ::
Custom Search