List of Figures

2-1 Entity Types and Populating Oracle Retail Data Model Tables
6-1 Intra-ETL Main Process Flow
6-2 Intra-ETL Derived Process Flow
6-3 Intra-ETL Independent MV Process Flow
6-4 Intra-ETL Aggregate Process Flow
6-5 OLAP Map Process Flow
6-6 Mining Flow Process
10-1 Mining Model Components
12-1 Customer Demographics by Income Band and Household Size Report
12-2 Frequent Shopper Penetration Report
12-3 Frequent Shopper Sales Analysis
12-4 Frequent Shopper Transactions
12-5 Frequent Shopper Distribution Report
12-6 RFM Scoring Report
12-7 RFMP Trending Report
12-8 Cluster Analysis
12-9 Frequency Defection
12-10 Customer Loyalty DT Profile
12-11 Customer Loyalty Factor Rank
12-12 Customer Loyalty Prediction Report
12-13 Customer Segmentation Report
12-14 Customer Segmentation Details Report
12-15 Promotional Planning
12-16 Promotion Comparison
12-17 Promotional Forecast Planning
12-18 Contribution by Promotion Event Type Store
12-19 Promotion Scorecard Report
12-20 Promotional Performance Report
12-21 Promotion Impact Report
12-22 Response Report
12-23 Contribution Scorecard
12-24 Item Profit on Cost Report
12-25 Pack Sales Report
12-26 Profit on net Cost Contribution Report
12-27 Cost Trend Report
12-28 Class Item Level Profit Contribution Report
12-29 Bottom Performance by Sales
12-30 Space Performance
12-31 Bottom Performing Items by % Profit Report
12-32 Top Performance Report
12-33 Top Selling Department by Store Report
12-34 Product Pricing Detail Report
12-35 Organization Pricing Detail Report
12-36 Price Analysis Report
12-37 Department Sales By Banner Report
12-38 Candidates for Delisting (Bottom 10% SV) Report
12-39 Sales by Channel Report
12-40 Listing by Category Report
12-41 Sales by Channel Report
12-42 Cross Sell Profit Potential by Item
12-43 Vendor Sales by Channel Report
12-44 Gross Profit by Department Report
12-45 Sales, Profit, and Returns by Channel (Local) Report
12-46 Sales, Profit and Returns by Channel Report
12-47 Item Sales and Profit by Product Cluster Report
12-48 Product Cluster Sales & Profit Report
12-49 Sales and Profit by Customer Cluster Report
12-50 Sales Profit and Returns by Location Trait Report
12-51 Product Price Elasticity Sales Prediction Batch Mode Report
12-52 Product Price Elasticity Dynamic Sales Prediction Report
12-53 Product Category Mix Report
12-54 Product Category Mix Product Set Rank by Support Report
12-55 Product Category Mix Product Set Rank by Probability Report
12-56 Merchandise Flow Analysis Fast Moving Items Report
12-57 Store Sales Flash Compared with Last Year Report
12-58 Department Chain Sales Flash Report
12-59 Store Sales Flash Report
12-60 Margin Contributions Product, Sales, Profit Value Against Last Year Report
12-61 Margin Contribution to Chain Report
12-62 Margin Contribution Organization Sales and Profit Report
12-63 Margin Contribution Sales and Stock
12-64 Margin Contribution Sales, Profit and Return by Store Trait Report
12-65 Margin Contribution Sales, Profit and Returns by Channel Report
12-66 Contract Detail by Item Report
12-67 Performance Vendor Report
12-68 Margin Contribution Top Performance
12-69 Vendor Product Summary Report
12-70 Performance Commitment Summary
12-71 Daily Performance Report
12-72 Monthly Performance Trend Report
12-73 Pack Compared to Standalone Sales
12-74 Vender Performance Report
12-75 Delivery and Timeliness Report
12-76 Zero Selling Report
12-77 Sales Analysis Product Sales and Return Report
12-78 Sales Analysis Item, Profit Base Cost Contribution and net Cost Contribution Report
12-79 Sales Analysis Net Cost and Net Profit Report
12-80 Sales Analysis Department Sales Report
12-81 Sales Analysis Vendor Sales Report
12-82 Sales Analysis Spatial Sales Report
12-83 Sales Analysis Markdown Report
12-84 Scorecard Sales Scorecard Report
12-85 Scorecard Store Sales Scorecard Report
12-86 Scorecard Vendor Scorecard Report
12-87 Scorecard Markdown Scorecard Report
12-88 Stock Movement Receipts Report
12-89 Stock Movement Stock Ledger Report
12-90 Stock Movement Inventory Report
13-1 Salesperson Monthly Performance Report
13-2 Salesperson Ranking Report
13-3 Salesperson Profit Report
13-4 Workforce Performance Cashier Report
13-5 Workforce Ranking Cashier Ranking Report
13-6 Workforce Salesperson Ranking Report
13-7 Employee Sales and Returns Report
13-8 Cashier Transaction Summary Report
13-9 Workforce Employee Basket DT Profile
13-10 Employee Basket Factor Rank Report
13-11 Employee Basket Prediction Report
13-12 Employee Sales DT Profile Report
13-13 Employee Sales Factor Rank Report
13-14 Employee Sales Prediction Report
13-15 Employee Combination DT Profile
13-16 Point of Sale Sales Conversion
13-17 Point of Service Sales Comparison
13-18 Point of Sale Store Traffic Day
13-19 Store Traffic-Conversion Rate (Week) Report
13-20 Point of Sale Associate Entry Method (Column Total)
13-21 Point of Service Associate Entry Method (Row Total) Report
13-22 Point of Service Flow Analysis Store Traffic Report
13-23 Hourly Sales Trend Transactions Count Report
13-24 Hourly Sales Trend (Sales Value and Sales Unit) Report
13-25 Hourly Transaction Profile
13-26 Sales Productivity Scorecard Report
13-27 Location Sales Productivity Scorecard Report
13-28 Selling Location Productivity Report
13-29 Till History Totals Report
13-30 Customer Transactions by Associate Report
13-31 Hourly Transaction Profile Report
13-32 Retail Transaction Type by Store Report
13-33 Loss Prevention Transactions Report
13-34 Defection Monetary Report
13-35 Defection Profitability Report
13-36 Category Trending Shrink and Theft Report
13-37 Transaction by Tender Report
13-38 Customer Transactions by Associate Report
13-39 Associate Tendering Report
13-40 Statistical Emp Outlier Report
13-41 Statistical Store Outlier Report
13-42 Store Credits Reports
13-43 Stock Ledger Gross Margin Report
13-44 Adjustments Summary
13-45 Inventory Adjustment Details Report
13-46 Availability Analysis Report
13-47 Inventory Vendor Compliance Report
13-48 Inventory Vendor Performance Report
13-49 Merchandise Comp Sales Report
13-50 Merchandise Vendor Product Report
13-51 Merchandise RTV Trend Report
13-52 Merchandise Sales and Inventory Item Report
13-53 Merchandise Vendor Sales Report
13-54 Merchandise Sales and Inventory Report
13-55 Quality Assurance Delivery Accuracy Report
13-56 Quality Measure Report
13-57 Quality Assurance Timeliness Report
13-58 Stock Movement Inventory and Receipts
13-59 Stock Movement Receipts and Inventory by Vendor Report
13-60 Stock Movement Vendor Inventory Report
13-61 Ending On Hand (EOH) Value Report
13-62 Order Status Report
13-63 Comp Store Sales Analysis Report
13-64 Sales Comparison Report
13-65 Comp Store Profit Analysis Report
13-66 Store Performance Contribution Report
13-67 Store Performance Report
13-68 Store Performance Ranking Report
13-69 Store Performance Scorecard Report
13-70 Employee Over/Short Report
13-71 Store Over/Short Report
13-72 Traffic Store Traffic Day Report
13-73 Store Traffic Week Report
13-74 Store Operation Transaction Hourly Sales Report
13-75 Hourly Sales Trend Report
13-76 Store Loss Analysis Store Loss DT Profile Report
13-77 Store Loss Analysis Store Loss Factor Rank Report
13-78 Store Loss Prediction Report