Page History
...
The data in this database will assist managers of Ski Team to understand the profitability of each of their programs, identify who their most profitable clients are and better manage their best performing camps.
Ski Team Core Tables
...
The main tables used in Ski Team examples areFor the examples in this tutorial only four tables from the Ski Team database are used. These are:
Athlete Fact | This contains information about each athlete and their participation on a camp. In this database the person fact will generally have one record for each camp and each person for every year. The fact record is concerned about the individual trips for each program. |
Camp | This is a dimensional table which contains information about each camp. For example the name and location of the camp. Camp ID is the Key to this table. |
Person | The person table contains information about the athlete such as name and address details. Person ID is the Key to this table. |
Date Lookup | This table is used to create data hierarchies used for drill down purposes. Day Date is the Key to this table. |
...
. |
About this Tutorial
| Styleclass | ||
|---|---|---|
| ||
...