What is the Discoverer Plus Relational sample database?

Discoverer is supplied with a sample database containing data about a fictitious company called Video Stores. Information in the Video Stores sample database includes:

• sales region

• year

• department

• sum of profit

• size of store (in square metres)

• type of store design (e.g. compact, modern, or traditional)

• store name

Discoverer is also supplied with a sample workbook called Video Tutorial Workbook that you can use to analyze the example data. The Video Tutorial Workbook contains a number of worksheets, including:

• a table worksheet called Tabular Layout

• a crosstab worksheet called Crosstab Layout

Note: The Discoverer manager might have given the sample workbook a different name from Video Tutorial Workbook.

Both worksheets enable you to analyze the sales and profitability of Video Stores (see figure below).

Figure 2-10 Sample Discoverer worksheets in the Video Tutorial Workbook

Description of the illustration sampws.gif

Key to figure:
a. The Tabular Layout worksheet, showing profit figures for departments across regions for 2000.
b. The Crosstab Layout worksheet, showing a comparison of profit figures for each department in quarter one (Q1) and quarter two (Q2) across regions for 2000.