Retail Data Warehouse

100 %
0 %
Information about Retail Data Warehouse

Published on October 29, 2007

Author: Woodwork


The SF Goodwill Retail Reporting Data Warehouse:  The SF Goodwill Retail Reporting Data Warehouse Why Build a Data Warehouse?:  Because few affordable POS products incorporate comparisons to goal and other cross-departmental reports. Because a data warehouse provides control over what data you see. Because data can be integrated with other management reporting systems for a one-stop overview of agency performance. Why Build a Data Warehouse? Project Goals:  Project Goals One-Stop for Sales and Inventory Reports. High-level information including sales to shipment and performance compared to goals. Web-based, automated reports available from in or outside of the office first thing in the morning. POS Requirements:  POS Requirements Logical database structure. Easy export of all pertinent data to common format (text delimited or SQL). Automation tools to support hands-off collection of data. Reliable internet connections between all stores and main office. Warehouse Requirements:  Warehouse Requirements Simple to read, drill-down reporting No duplicate data entry - all sales and inventory to be pulled from POS system; sales/inventory goals to be entered annually. Standardized design tools - SQL, HTML and PHP with documentation of all code. Report Features:  Report Features High level info summarized at top; drill down for details. Filter reports by store, district, or any combination. Export to Excel by clicking icon for current page’s data. Web-based - available to authorized Intranet members from office or remote locations. Opening Summary Page:  Opening Summary Page Reports Screen:  Reports Screen Cash/Tender Report:  Cash/Tender Report Inventory Reports:  Inventory Reports Inventory Reports - Color:  Inventory Reports - Color Inventory Reports - Price Point:  Inventory Reports - Price Point Sellthru Report:  Sellthru Report Sales Goal Report:  Sales Goal Report Time of Day Report:  Time of Day Report Exception Report:  Exception Report Reporting Toolbar:  Report Criteria Selection:Stores, Dates, Custom Reports, Period to Date Reporting Toolbar Tools:Navigation, Export to Excel, Retail and Promotional Calendars, Help Reporting Toolbar (Cont.):  Reporting Toolbar (Cont.) Custom Reports:  Custom Reports Notes:  Notes All work © Goodwill Industries of San Francisco, Inc., 2003. Consulting, installation and customization of these reports on your system is available. Contact: Peter Campbell, VP Information Technology Goodwill Industries of San Francisco 1500 Mission St., SF, CA, 94103 415.575.2151 *

Add a comment

Related presentations

Related pages

Oracle Retail Data Warehouse April3

ORACLE DATA SHEET 1 ORACLE RETAIL DATA WAREHOUSE KEY BENEFITS Pre-built integration with Oracle solutions including: • Oracle Retail Merchandising
Read more

IBM Retail Data Warehouse - IBM - United States

IBM Retail Data Warehouse is an industry-specific blueprint that provides data warehouse design models, business terminology and analysis templates.
Read more

Retail Data Warehouse - SearchDataManagement

Use your retail data warehouse to get a view of your business from the perspective of your customers.
Read more

Retail Data Warehousing | Information Management Magazine

The problems of data collection and handling large volumes of transactional information are familiar to retailers. Data warehouse technology provides new ...
Read more

Retail Data Warehouse Choice (Commerce Anywhere Blog)

Retail Data Warehouse Choice By David Dorf-Oracle on Nov 14, 2008. Anybody can be a retailer, but only a select few can be profitable retailers. What ...
Read more

Retail Data Warehousing—The-State-of-the-Art by Dan Ross ...

Retail Data Warehousing—The-State-of-the-Art Business Intelligence Dan Ross Best Practices,Business Intelligence,Data Mining and Statistical ...
Read more

Oracle Retail Data Model - Oracle | Integrated Cloud ...

Oracle Retail Data Model is a standards-based data model, designed and pre-tuned for Oracle data warehouses, including the HP Oracle Database Machine.
Read more

Oracle® Retail Data Warehouse - Oracle Software Downloads ...

Figure 1–1 Data Sources for Oracle Retail Data Warehouse Oracle Retail Solutions ... Introduction to Oracle Retail Data Warehouse 1-5 Data Granularity
Read more

IBM Retail Data Warehouse - IBM - United States

IBM Retail Data Warehouse ist ein branchenspezifischer Entwurf, mit dem Designmodelle für Data Warehouses, Geschäftsterminologie und Analysevorlagen ...
Read more

Data warehouse - Wikipedia, the free encyclopedia

1970s — ACNielsen and IRI provide dimensional data marts for retail sales. [8] ... Building the Data Warehouse (2005) John Wiley and Sons, ...
Read more