Скачать презентацию The SF Goodwill Retail Reporting Data Warehouse August Скачать презентацию The SF Goodwill Retail Reporting Data Warehouse August

a8bf1efae17f60e4784d18efe36b9668.ppt

  • Количество слайдов: 20

The SF Goodwill Retail Reporting Data Warehouse August 12, 2003 Prepared by Peter Campbell, The SF Goodwill Retail Reporting Data Warehouse August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 1

Why Build a Data Warehouse? • Because few affordable POS products incorporate comparisons to 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 onestop overview of agency performance. August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 2

Project Goals • One-Stop for Sales and Inventory Reports. • High-level information including sales 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. August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 3

POS Requirements • Logical database structure. • Easy export of all pertinent data to 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. August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 4

Warehouse Requirements • Simple to read, drill-down reporting • No duplicate data entry - 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. August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 5

Report Features • High level info summarized at top; drill down for details. • 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. August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 6

Opening Summary Page August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Opening Summary Page August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 7

Reports Screen August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Reports Screen August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 8

Cash/Tender Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Cash/Tender Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 9

Inventory Reports August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Inventory Reports August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 10

Inventory Reports - Color August 12, 2003 Prepared by Peter Campbell, VP Information Technology, Inventory Reports - Color August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 11

Inventory Reports - Price Point August 12, 2003 Prepared by Peter Campbell, VP Information Inventory Reports - Price Point August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 12

Sellthru Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Sellthru Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 13

Sales Goal Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Sales Goal Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 14

Time of Day Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, Time of Day Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 15

Exception Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Exception Report August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 16

Reporting Toolbar Tools: Navigation, Export to Excel, Retail and Promotional Calendars, Help Report Criteria Reporting Toolbar Tools: Navigation, Export to Excel, Retail and Promotional Calendars, Help Report Criteria Selection: Stores, Dates, Custom Reports, Period to Date August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 17

Reporting Toolbar (Cont. ) August 12, 2003 Prepared by Peter Campbell, VP Information Technology, Reporting Toolbar (Cont. ) August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 18

Custom Reports August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Custom Reports August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 19

Notes • All work © Goodwill Industries of San Francisco, Inc. , 2003. • 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 * [email protected] org August 12, 2003 Prepared by Peter Campbell, VP Information Technology, © Goodwill Industries of San Francisco, San Mateo and Marin Counties, Inc. 20