160 likes | 255 Views
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’
E N D
EXECUTIVE DASH CASE STUDY GARY PRITCHARD ASHWORTH EUROPE 29th 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’ INTERNATIONAL BRANDS IN GOLF & PERFORMANCE OUTERWEAR About Ashworth Europe
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
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
Ashworth Future M3 Developments • Lawson CRM • Lawson LBI • Roll out to Ashworth US sites • Will include • Manufacturing • Integration to Automated Warehouse
Executive Dash Building on Spreadsheet Server
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
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
Executive Dash Architecture Access to virtually any data source, providing real time query results for analysis, presentation or distribution mySQL ODBC
Executive Dash Overview Tables, Fields Filters, Params Links Excel Format Present Query Catalog RUN Query Builder Excel DRILL DOWN Detail Results Query Report
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
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
Thank You ! Questions ? Or speak to me and/or eVentura later