Databases Reference
In-Depth Information
Internet. Customers who sign up as members of the Orion Star Club organization can
receive favorable special offers; therefore, most customers enroll in the Orion Star Club.
Note:
The sample data for Orion Star Sports & Outdoors is for illustration only. The
reader is not expected to use sample data to create the data warehouse that is
described in the manual.
Asking the Right Questions
Possible High-Level Questions
Suppose that the executives at Orion Star Sports & Outdoors want to be proactive in
regard to their products, customers, delivery, staff, suppliers, and overall profitability.
They might begin by developing a list of questions that needed to be answered, such as
the following:
Product Sales Trends
What products are available in the company inventory?
What products are selling?
What are the time and place dependencies of product sales?
Who is making the sales?
Slow-Moving Products
Which products are not selling?
Are these slow sales time or place dependent?
Which products do not contribute at least 0.05% to the revenue for a given
country/year?
Can any of these products be discontinued?
Profitability
What is the profitability of products, product groups, product categories, and
product line?
How is the profitability related to the amount of product sold?
Discounting
Do discounts increase sales?
Does discounting yield greater profitability?
After reviewing their list of questions, Orion Star executives might select a few
questions for a pilot project. For example, the executives might choose the following two
initial questions:
Which salesperson is making the most sales?
What are the time and place dependencies of product sales?
The executives would then direct the data warehousing team to answer the selected
questions. The examples used in this manual are derived from the selected questions.
Search WWH ::
Custom Search