e xecutive d ash c ase s tudy n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
E XECUTIVE D ASH C ASE S TUDY PowerPoint Presentation
Download Presentation
E XECUTIVE D ASH C ASE S TUDY

Loading in 2 Seconds...

play fullscreen
1 / 16

E XECUTIVE D ASH C ASE S TUDY - PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on

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’

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'E XECUTIVE D ASH C ASE S TUDY' - wanda-pearson


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
e xecutive d ash c ase s tudy
EXECUTIVE DASH CASE STUDY

GARY PRITCHARD ASHWORTH EUROPE

29th Sept 2007

Hosted by: MUA

about ashworth europe
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
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
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
Ashworth Future M3 Developments
  • Lawson CRM
  • Lawson LBI
  • Roll out to Ashworth US sites
    • Will include
      • Manufacturing
      • Integration to Automated Warehouse
slide7

Executive Dash

Building on Spreadsheet Server

executive dash
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
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
Executive Dash Architecture

Access to virtually any data source, providing real time query results for analysis, presentation or distribution

mySQL

ODBC

executive dash overview
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
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
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
slide16

Thank You !

Questions ?

Or speak to me and/or eVentura later