Databases Reference
In-Depth Information
Which Salesperson Is Making the Most Sales?
Identifying Relevant Information
To answer the question, “Which salesperson is making the most sales?”, the data
warehousing team decided to design a report that lists total sales by employee. The
following display shows an example of such a report.
Display 5.1
Total Sales by Employee Report
The next step is to identify how such a report could be created.
Identifying Sources
The data warehouse team examined existing tables to determine if they could be
used to the create the report shown in the previous display. They identified several
tables that could be used. These tables are described in the following sections.
Source for Staff Information
The STAFF table contains information about employees, such as name, ID,
department, supervisor, and salary, as shown in the following display.
Display 5.2
The STAFF Table
Search WWH ::
Custom Search