Page 379 - Using MIS

Q2 What Are the Three Primary Activities in the BI Process? 347

Figure 9-7
Creating the Customer Summary
Query

set that criterion for Number Orders in the query in Figure 9-9. To select only parts that are or-
dered in small quantities, she first created a column that computes average order size (Units /
[Number Orders]) and then set a criterion on that expression that the average must be less than
2.5. Their last two criteria were that the part be relatively inexpensive and that it be lightweight.
They decided to select parts with a unit price (computed as Revenue / Units) less than 100 and a
shipping weight less than 5 pounds.
The results of this query are shown in Figure 9-10. Of all the parts that AllRoad sells, these
12 fit the criteria that Addison and Drew created.
Drew wondered what revenue potential these parts represent. Accordingly, Addison cre-
ated a query that connected the selected parts with their past sales data. The results are shown
in Figure 9-11.

Figure 9-8
Customer Summary