Problem
Using SaaS Enterprise Guide 8.3 program
A. How many distinct transactions have been captured in the SALE_FACT?
B. How many unique customers have made purchases?
C. What is the average transaction size by Region?
D. What is the busiest day of the week in terms of transactions for the Toronto Store?
E. What is the total sales for the organization by Month & Year and by Region?
F. What was the product with the highest sales volume in terms of revenue in the western region in December 1997 (month=12)?
G. What is the average number of transactions by customer?
H. What is the breakdown in revenue by Channel and store for fishing line?
I. What is the most popular item in terms of volume for 1998?
J. Who are the top 10 customers in terms of revenue for 1997?