1 / 16

E XECUTIVE D ASH C ASE S TUDY

E XECUTIVE D ASH C ASE S TUDY. G ARY P RITCHARD A SHWORTH E UROPE. 29 th Sept 2007 Hosted by: MUA. Part of Ashworth Group ( US ) Based Basildon – Essex 100 employees Buy, Stock and Distribute across ‘Europe’ - Three brands - Ashworth Calloway ‘Brand S’

wanda-pearson
Download Presentation

E XECUTIVE D ASH C ASE S TUDY

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. EXECUTIVE DASH CASE STUDY GARY PRITCHARD ASHWORTH EUROPE 29th Sept 2007 Hosted by: MUA

  2. Part of Ashworth Group ( US ) Based Basildon – Essex 100 employees Buy, Stock and Distribute across ‘Europe’ - Three brands - Ashworth Calloway ‘Brand S’ INTERNATIONAL BRANDS IN GOLF & PERFORMANCE OUTERWEAR About Ashworth Europe

  3. Examples of our Products -

  4. Ashworth Europe and M3 • Planned Go-Live Nov ’07 • SALES • LOGISTICS • PURCHASING • FINANCE • We think we have a simple business BUT- • Fashion products - proliferate by style, colour, size, fit, season • 35,000 Stock keeping units • 5,000 SKUs Two seasons per year Buy per season, products from Far East • 8,000 Customers, • 1000+ line Purchase and Customer Orders • 100+ Different embroidery lines on one order Complex Pricing, discounting

  5. Ashworth Europe M3 Solution Standard M3 V12 with - • Modifications by Lawson • Embroidery ( HUGE ) • Bonus & Commisions ( Small ) • Bar-code Warehouse apps from BEC • Windows Based, One custom API • Reporting • Financial Spreadsheet Server • Executive Dash • In House SQL legacy data

  6. Ashworth Future M3 Developments • Lawson CRM • Lawson LBI • Roll out to Ashworth US sites • Will include • Manufacturing • Integration to Automated Warehouse

  7. Executive Dash Building on Spreadsheet Server

  8. Executive-Dash • Builds on Spreadsheet Server Same technology Not preconfigured Requires technical and M3 application expertise LIVE Data - refreshed at will, Excel User Interface • Excel formulas via Add-Ins • Present data • Drill Down to detail • Use Excel’s graphical capabilities

  9. Executive Dash can access- • Multiple Data Sources - • iSeries ( M3 ), SQL Server, MS Access, Over the Internet via .Net Web Services • Each connection customized • Prompted and Non-Prompted connections • Connection validation/testing • Include data from virtually any ODBC data source

  10. Executive Dash Architecture Access to virtually any data source, providing real time query results for analysis, presentation or distribution mySQL ODBC

  11. Executive Dash Overview Tables, Fields Filters, Params Links Excel Format Present Query Catalog RUN Query Builder Excel DRILL DOWN Detail Results Query Report

  12. Executive Dash - Quick Example

  13. Executive Dash - Quick Example

  14. Dash at Ashworth Europe • Non-financial Management Reports • Available to Sell Reports • Bespoke Logistics Reports • Customer Embroidery Image Display • Database/ conversion validation and cross checks • Modification testing • Ad-hoc queries and Enquiries

  15. Why Executive Dash ? • Real Time Data • Existing development and user skills in Excel and sql • Drill down capabilities • Speed of deployment • In house resource • Rapid development/ prototyping • Checking file content during project – conversion/mods • Combine M3 and Legacy data in same report • Including image database • No ability/ risk of affecting M3 database

  16. Thank You ! Questions ? Or speak to me and/or eVentura later

More Related