1 / 27

Thu Jun 2 2005

Thu Jun 2 2005. FoodMart 2000 OLAP Queries long version. Unit Sales by Promotion Media Type Subheading. Units Shipped and Ordered by Store Subheading. Store Units Shipped Units Ordered Store 6 10,759 11,699 Store 7 24,587 26,463 Store 24 23,835 26,270 Store 14 1,696 1,875

yardley-kramer
Download Presentation

Thu Jun 2 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Thu Jun 2 2005 FoodMart 2000 OLAP Queries long version Source: XXXX

  2. Unit Sales by Promotion Media Type Subheading Source: XXXX

  3. Units Shipped and Ordered by Store Subheading Store Units Shipped Units Ordered Store 6 10,759 11,699 Store 7 24,587 26,463 Store 24 23,835 26,270 Store 14 1,696 1,875 Store 11 8,515 9,109 Store 13 32,393 35,797 Store 2 2,348 2,454 Store 3 22,734 24,610 Store 15 24,110 26,703 Store 16 11,889 12,828 Store 17 32,411 35,930 Store 22 1,860 2,074 Store 23 10,589 11,426 Source: XXXX

  4. Store Sales (last period) by Department Subheading Source: XXXX

  5. Accumulated Sales by Product Department Source: XXXX

  6. Costs and Profit Rate by Product Department Source: XXXX

  7. Percent of Alcoholic Drinks Subheading Source: XXXX

  8. Sales and Accumulated Sales by Month (1997) Source: XXXX

  9. Sales and Accumulated Sales by Month (1997) Source: XXXX

  10. Ranked top 10 first-level managers Subheading Source: XXXX

  11. Topcount Example Subheading Source: XXXX

  12. Descendents example Subheading Source: XXXX

  13. Store Profit for the first quarter of each year Source: XXXX

  14. Sales of a Product Brand as a percentage of the sales of that product within its subcategory Source: XXXX

  15. Percentage of sales for top 10 promotion compared only to other promotions Source: XXXX

  16. Sales Growth Over Time Subheading Source: XXXX

  17. Monthly Year-to-Date Sales for each product category in 1997 Source: XXXX

  18. Store Sales Profit for those whose unit sales exceed 25,000 in 1997 for each city based against the store type Source: XXXX

  19. Top Dozen Stores by Sales Count Source: XXXX

  20. Sales Measures for cities whose sales count accounts for 50 percent of all the sales Source: XXXX

  21. Unit Sales and Customer Count by product category Source: XXXX

  22. Unit Sales and Percent of States Sales by store Source: XXXX

  23. Percentage Profit for States months 1997 Source: XXXX

  24. Aggregated Store Sqft Member Property Subheading Source: XXXX

  25. Top Store Costs by City Subheading Source: XXXX

  26. Store Sales by Month with +/- 3 St.Dev. Control Source: XXXX

  27. Store Sales Growth by Product Month-to-Month 1997 Source: XXXX

More Related